1. Announcement:
    Want access to a chatbox?
    Dason ‎(Devorador de queso)
    05-10-2017
    Views:
    2,716
+ Post New Thread
Page 3 of 22 FirstFirst 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 LastLast
Threads 121 to 180 of 1298

Forum: SAS

SAS usage and programming. SAS/Base, SAS/Stat, proc sql, SAS macro...

  1. Sticky Thread Sticky: Share your SAS tips

    Since SAS isn't as reliant on UDFs as much as R is, I thought a thread on tips/useful gems hidden in SAS documentation/stuff you learned would be...

    Started by Janus‎, 11-18-2012 12:34 AM
    2 Pages
    1 2
    • Replies: 22
    • Views: 28,719
    06-26-2015, 10:17 AM Go to last post
  1. trouble reading in a csv

    Hi, I have a csv file I am trying to read into SAS, and the output from my proc print step shows me that the data isn't being read properly in...

    Started by ahart‎, 08-11-2015 04:39 AM
    • Replies: 14
    • Views: 2,826
    08-18-2015, 07:32 AM Go to last post
  2. Transpose Data

    Hi there. I am trying to transpose my data without proc transpose. I have the following data: ID Fall_Adj Fall_Raw Spring_Adj Spring_Raw 1...

    Started by ali.hash‎, 08-17-2015 12:34 AM
    transpose
    • Replies: 1
    • Views: 1,266
    08-17-2015, 01:41 AM Go to last post
  3. CSV file date format

    I have a csv file I am reading in SAS and I am trying to format the dates and it doesn't seem to work the csv has this date 12/04/2008 00:00:00...

    Started by ahart‎, 08-06-2015 03:21 AM
    • Replies: 4
    • Views: 1,531
    08-11-2015, 01:03 PM Go to last post
  4. Import/Merge weekly file to Master historic

    Hi I would like to ask some help I have 3 steps described below, in a nut shell I would like import csv file (New_Customers_weekTEST) have it...

    Started by ahart‎, 08-06-2015 06:18 AM
    2 Pages
    1 2
    • Replies: 16
    • Views: 3,043
    08-11-2015, 08:40 AM Go to last post
  5. CSV import tp SAS dataset doesn't show any results

    hi, I have done some work on a csv file and following this, I am looking to import it into SAS as a SAS dataset within a specified library. My...

    Started by ahart‎, 08-11-2015 03:37 AM
    • Replies: 0
    • Views: 1,220
    08-11-2015, 03:37 AM Go to last post
  6. ERROR: Procedure GEE not found

    Hi Professionals, I've just read this webpage about building weighted GEE models with PROC GEE. The link is:...

    Started by freezingswallow‎, 08-06-2015 03:26 PM
    proc gee, procedure not found
    • Replies: 2
    • Views: 1,926
    08-06-2015, 03:58 PM Go to last post
  7. Saturated correlates in SAS

    This is designed to add auxiliary variables to a FIML model. It is easy to do in SEM software, but I can't find it even mentioned in SAS. Without it,...

    Started by noetsi‎, 07-28-2015 03:38 PM
    • Replies: 4
    • Views: 1,430
    07-30-2015, 02:05 PM Go to last post
  8. Categorical (>2 groups) Missingness Dataset

    Noetsi, This is for you. Many times you have coding questions, which I think come from not actively using a dataset. I created a dataset with a...

    Started by hlsmith‎, 07-29-2015 10:57 AM
    • Replies: 2
    • Views: 1,364
    07-29-2015, 11:06 AM Go to last post
  9. Sampling question

    Hello all - quick question on sampling - say I have a population whose X average is 100, with stddev of 50. How can I sample (using proc...

    Started by agp‎, 07-28-2015 08:01 AM
    • Replies: 9
    • Views: 2,614
    07-28-2015, 06:32 PM Go to last post
  10. PROC MI FCS question

    When you want to run multiple imputation variables not just one how do you do it? For example proc mi nimpute=3 data=work.c62 seed=987...

    Started by noetsi‎, 07-20-2015 01:41 PM
    2 Pages
    1 2
    • Replies: 20
    • Views: 7,042
    07-24-2015, 04:14 PM Go to last post
  11. reshaping data

    I am trying to reshape data in SAS in a very specific way. The data looks like: ID Q1 Q2 491 0 0 491 0 1 1040 0 1 1040 1 0 1040 2 1

    Started by sandeep249‎, 07-18-2015 06:36 PM
    arrays, sas
    • Replies: 0
    • Views: 1,725
    07-18-2015, 06:36 PM Go to last post
  12. SAS Code for sending mail with attachment and summary on face of the mail.

    Hi i tried to write a code in which the outcome should be : 1. A mail to be sent to the mail id's mentioned with the summary on the body of the...

    Started by santhosh‎, 07-13-2015 04:09 AM
    • Replies: 0
    • Views: 1,487
    07-13-2015, 04:09 AM Go to last post
  13. Logistic Reg Sample Size Recommendations

    from SAS communities https://communities.sas.com/thread/80844

    Started by noetsi‎, 07-09-2015 12:26 PM
    • Replies: 3
    • Views: 2,300
    07-09-2015, 06:35 PM Go to last post
  14. Sumproduct with arrays - Should be easy

    Hi, I'm relatively new to SAS. I feel like this should be an easy fix but for the life of me I can't figure out what is wrong. Basically what I'm...

    Started by ZColl‎, 06-26-2015 12:34 PM
    • Replies: 1
    • Views: 1,812
    06-26-2015, 12:38 PM Go to last post
  15. Proc mixed - repeated

    Dear all I have the following question concerning the fitting of a model with PROC MIXED: If in PROC MIXED we use just the repeated statement,...

    Started by sternchen‎, 06-26-2015 06:11 AM
    • Replies: 1
    • Views: 1,157
    06-26-2015, 09:21 AM Go to last post
  16. Proc calis

    Anyone know a good source for learning to use this (I don't find SAS documentation particularly good for the first time you use a PROC). I need to...

    Started by noetsi‎, 03-23-2015 11:24 AM
    • Replies: 3
    • Views: 1,859
    06-26-2015, 09:03 AM Go to last post
  17. Help

    Hi Anybody can give me some help? how to code my study? Please check the attachment Fdate refer to forecast announcement date, Adate refers to...

    Started by Ianacct‎, 06-25-2015 04:08 PM
    • Replies: 1
    • Views: 1,210
    06-25-2015, 04:40 PM Go to last post
  18. proc calis

    I found this from Alison to be bemusing

    Started by noetsi‎, 06-25-2015 03:25 PM
    • Replies: 0
    • Views: 1,904
    06-25-2015, 03:25 PM Go to last post
  19. Proc logistic - penalty/shrinkage

    Hi, I need to perform a penalty/shrinkage logistic regression (penalize/shrink the size of the regression coefficients - RIDGE/LASSO regression). ...

    Started by thomas41‎, 06-23-2015 03:55 AM
    • Replies: 2
    • Views: 3,925
    06-23-2015, 07:54 AM Go to last post
  20. Multiple imputation; Friedman Test, Wilcoxon Test

    Hi, I would like to run the Friedman or Wilcoxon test on data I already imputed. This is how far i got: proc mi data=WORK.MASTER_TEST_SAS...

    Started by edlarge‎, 04-22-2012 11:55 AM
    • Replies: 7
    • Views: 7,663
    06-22-2015, 12:29 PM Go to last post
  21. SAS code to create game scheduler for 8 players

    I'm trying to set up a pseudo tournament competition thing. There are 8 players and at any given time 4 of the 8 players can participate. I would...

    Started by lancearmstrong1313‎, 06-05-2015 08:17 AM
    • Replies: 0
    • Views: 1,958
    06-05-2015, 08:17 AM Go to last post
  22. How to create value-weight returns from equal-weight returns when I have market caps?

    Hey SAS users! I'm creating a dataset where I want to calculate the value-weighted returns on 10 volatility portfolios (the portfolios are called...

    Started by SAS_robbert‎, 05-27-2015 05:37 AM
    sas 9.3, value-weighted returns
    • Replies: 0
    • Views: 3,377
    05-27-2015, 05:37 AM Go to last post
    • Replies: 0
    • Views: 1,057
    05-26-2015, 03:49 AM Go to last post
  23. #Occurences counter for each ID

    Hello i am trying to have a # of occurrences counter in a data set for each specific ID. I tried using the _N_ function, but that doesn't reset at...

    Started by cwick2521‎, 05-21-2015 12:40 PM
    • Replies: 5
    • Views: 1,305
    05-21-2015, 03:14 PM Go to last post
  24. SAS sources

    This looks like an amazing source for SAS material http://support.sas.com/resources/papers/proceedings10/185-2010.pdf

    Started by noetsi‎, 05-18-2015 08:28 AM
    • Replies: 0
    • Views: 1,753
    05-18-2015, 08:28 AM Go to last post
  25. Using Proc Glimmix or NLMIXED

    Using proc glimmix

    Started by anne747‎, 03-12-2015 03:30 PM
    • Replies: 3
    • Views: 2,811
    05-11-2015, 06:56 PM Go to last post
  26. Sum of multiple variables by group

    Hi so not really sure how to explain this (new to SAS forums) but I can't seem to find a way of doing this.... I have a dataset with over 900...

    Started by SDavis‎, 05-08-2015 10:02 AM
    • Replies: 2
    • Views: 1,376
    05-11-2015, 11:56 AM Go to last post
  27. Check if macro variable exists within another macro variable string

    Let's say I have the following code: %LET X = a b c d e; %LET Y = b; Is there an easy way to do an if/then that checks if &Y exists in...

    Started by lancearmstrong1313‎, 05-06-2015 06:36 AM
    • Replies: 4
    • Views: 1,595
    05-06-2015, 09:56 AM Go to last post
  28. troubleshooting: if then statement populating new variable with missing values

    Hello I'm trying to convert variable hist_type (a character variable with values like lobular, ductal, etc) to a newly named variable hist_code...

    Started by crahillytierney‎, 05-02-2015 12:49 PM
    • Replies: 2
    • Views: 1,725
    05-04-2015, 09:53 AM Go to last post
  29. SAS Reshape Table Wide to Long Format

    So let's say I have some data in a wide format (multiple representations of a variable across columns). data wide; input x y z1 z2 z3;...

    Started by bryangoodrich‎, 05-01-2015 10:34 AM
    • Replies: 2
    • Views: 3,164
    05-01-2015, 10:52 AM Go to last post
  30. Estimate mean survival time (fit weibull distribution)

    I have a dataset that has a unique ID for each person, their time until event or censoring and then a variable indicating if that person was censored...

    Started by lancearmstrong1313‎, 04-28-2015 01:26 PM
    • Replies: 2
    • Views: 1,875
    04-30-2015, 12:10 PM Go to last post
  31. Red face How to get daily census of patient's stay?

    I am trying to write a code for the daily midnight census for patient's stay in the hospital. The daily midnight census counts how many patients at...

    Started by Janoose‎, 04-27-2015 02:31 PM
    • Replies: 4
    • Views: 1,846
    04-30-2015, 07:44 AM Go to last post
  32. Question SAS code for Two way ANOVA

    Below is the dataset for three way Anova and I would like someone to help me with the sas code for this. I am not sure how to solve this two way...

    Started by Deepali‎, 04-27-2015 08:25 AM
    • Replies: 9
    • Views: 2,447
    04-29-2015, 07:42 AM Go to last post
  33. Bootstrapping code for linear regression

    I am brand new to doing bootstrapping as a method and in SAS so I would appreciate comments on this. I started by replicating the data base...

    Started by noetsi‎, 04-27-2015 11:00 AM
    • Replies: 8
    • Views: 1,859
    04-27-2015, 03:38 PM Go to last post
  34. Transforming 1 time variable into a covariate

    Hello, I am trying to perform a mixed model anova analysis on a dataset with measurements at 0-6 time points. At each time point, patients 1 - 20...

    Started by aclarke‎, 04-21-2015 08:01 PM
    • Replies: 1
    • Views: 1,918
    04-25-2015, 06:36 AM Go to last post
  35. White's test, white's standard error in PROC REG

    Anyone know the code for White's test of unequal error variance and how to generate White's SE in PROC REG? I actually found one source for this,...

    Started by noetsi‎, 04-21-2015 04:58 PM
    • Replies: 2
    • Views: 5,282
    04-21-2015, 05:45 PM Go to last post
  36. Scale= statement

    I am trying to run the Vuong macro and I have everything set up, minus a few things. For nparm1 and nparm2 I just looked at the output for number of...

    Started by wernie07‎, 04-10-2015 06:30 PM
    • Replies: 1
    • Views: 1,313
    04-11-2015, 10:21 PM Go to last post
  37. Question Do I need this variable in the class statement? And IRRs

    I am trying to calculate incidence rate ratios and 95% CIs for the interaction between two variables: area and time. My variables are n, area,...

    Started by wernie07‎, 04-08-2015 06:24 PM
    class, incidence rate ratio
    • Replies: 1
    • Views: 1,415
    04-11-2015, 10:16 PM Go to last post
  38. R and SAS book

    Anyone read this? It sounds interesting. http://sas-and-r.blogspot.com/2010/03/example-730-simulate-censored-survival.html I think this...

    Started by noetsi‎, 01-12-2015 03:48 PM
    • Replies: 4
    • Views: 2,439
    04-08-2015, 06:02 PM Go to last post
  39. SAS code for converting arcsine-transformed percent data to original unit

    I am working on the SAS code for multiple linear regression where the dependent variable is a continuos variable and is in percent. I log transformed...

    Started by sb1605‎, 04-07-2015 04:17 PM
    • Replies: 2
    • Views: 7,207
    04-08-2015, 05:35 PM Go to last post
  40. Help plz proc_format

    Hi everyvody, I'm working with an alphanumeric variable, I applied a frequence proc on it and I want to know how to make a format function to...

    Started by Ihssanee‎, 03-26-2015 05:37 AM
    • Replies: 1
    • Views: 1,447
    03-26-2015, 07:45 AM Go to last post
  41. MACRO variable inside MACRO

    I'm curious why the following code does not work: %LET mbr_list=1,2,3,4,5; %MACRO mbr_loop(mbr_values); %let...

    Started by lancearmstrong1313‎, 03-24-2015 02:33 PM
    • Replies: 3
    • Views: 2,345
    03-25-2015, 06:13 AM Go to last post
  42. Extracting/Selecting observations of the last 20 mins of a SAS data set

    Hey guys, I hope anyone can help me on this. I have a data set, which is continuously updated. For each observation, I have the time and date...

    Started by plnc‎, 03-10-2015 06:25 PM
    • Replies: 4
    • Views: 1,471
    03-13-2015, 10:25 AM Go to last post
  43. Graphics in PROC GLIMMIX

    Hello, I'm looking to add graphs in SAS using PROC GLIMMIX. I've tried the statement: ods graphics on; before my programming statement...

    Started by compassion83‎, 04-14-2014 07:35 PM
    • Replies: 2
    • Views: 2,398
    03-09-2015, 06:58 PM Go to last post
  44. How to read a .wpd file inot sas data set?

    Hi, I am unable to read a .wpd (WPS) file into sas data set. Suppose there is a file Employee_Details.wpd stored at location z\:... Can I...

    Started by Shashank Prasad‎, 06-17-2014 06:18 AM
    • Replies: 1
    • Views: 5,277
    03-06-2015, 09:15 AM Go to last post
  45. Poissonness plot

    This is essentially the equivalent of a QQ plot for Poisson distribution, which can not use QQ plots since the distribution is of discrete data....

    Started by noetsi‎, 01-29-2015 09:08 AM
    2 Pages
    1 2
    • Replies: 15
    • Views: 5,632
    03-02-2015, 06:00 PM Go to last post
  46. Question Quick way to sum?

    I'm having trouble figuring out how to pick out the pieces of data that I need to then sum those pieces. So I have 3 areas ('east', 'west', and...

    Started by wernie07‎, 02-18-2015 05:00 AM
    • Replies: 5
    • Views: 1,914
    02-25-2015, 04:25 AM Go to last post
  47. SAS University Edition won't let me upload a large file

    Hi, I am doing a project for work with de-idenitifed secondary NHANES data. I have a .dat file and the SAS code for opening and labeling it. I...

    Started by alanend‎, 02-18-2015 11:08 AM
    • Replies: 4
    • Views: 5,070
    02-19-2015, 08:43 AM Go to last post
  48. Cool Performing multiple t-tests on different variables between the same two groups

    Hey everyone I would like to perform multiple t test on different variables ( let's say A B C D E ) in two different groups ( 1 2 ) and test if...

    Started by morgano‎, 02-17-2015 05:51 PM
    r help, sas data manipulation, ttest
    • Replies: 0
    • Views: 2,133
    02-17-2015, 05:51 PM Go to last post
  49. DO LOOP Creates a new variable that is the index I am using

    Hi, Sorry if this is a basic question but I have not been able to find a solution/answer. I am using a do loop with an array to process some...

    Started by Mike5‎, 02-12-2015 12:18 PM
    • Replies: 3
    • Views: 1,526
    02-12-2015, 02:25 PM Go to last post
  50. 4 categorical variables and 1 continuous varible (indep) analysis

    What stat analyses would be adviceble to run if you want to anayse the effects of 4 categorical variables on 1 continuous variable (indep)? var1 =...

    Started by vestllink‎, 02-10-2015 04:47 AM
    • Replies: 0
    • Views: 1,196
    02-10-2015, 04:47 AM Go to last post
  51. Specifying one age group? Proc genmod

    I'm trying to run a negative binomial (or poisson if it's saturated) model and have area and period as the class variables. I want to check if my...

    Started by wernie07‎, 02-03-2015 10:00 PM
    • Replies: 6
    • Views: 2,012
    02-04-2015, 10:43 PM Go to last post
  52. Interpreting proc genmod output

    I have hospitalization data (nsum) over a 17 year period for 3 different study areas (variables period and area). I have the log of the population as...

    Started by wernie07‎, 01-30-2015 09:33 PM
    • Replies: 0
    • Views: 2,868
    01-30-2015, 09:33 PM Go to last post
  53. Create excel sheet (from SAS) with Data Validation Options

    Hopefully this makes sense: So in excel you can use the Data Validation tool to create drop down lists to essentially force a user to have to...

    Started by lancearmstrong1313‎, 01-29-2015 09:46 AM
    • Replies: 1
    • Views: 2,562
    01-29-2015, 11:00 AM Go to last post
  54. Repeated Measures Nested Model in PROC Mixed?

    Hello, I'm looking for help analyzing data. Here's the experimental setup: 12 experimental plots, divided into 3 blocks. Each block...

    Started by MikeS‎, 01-29-2015 09:23 AM
    nested anova, proc mixed, repeated measures
    • Replies: 0
    • Views: 2,246
    01-29-2015, 09:23 AM Go to last post
  55. Negative binomial model - saturated?

    I am trying to run a model for cases (n) to see if area, period, and area*period are significant predictors. I am really only interested in the...

    Started by wernie07‎, 01-07-2015 05:40 PM
    • Replies: 2
    • Views: 1,999
    01-22-2015, 07:30 PM Go to last post
  56. interpretation for %DFTEST results

    Hello, I need to interpret the results of this macro %DFTEST: proc print data=sashelp.air;run; %dftest(sashelp.air, air, ar=1, dif=(1),...

    Started by Lubomir‎, 01-20-2015 12:42 PM
    %dftest, dftest, dickey fuller test, non-stationarity, stationarity
    • Replies: 0
    • Views: 2,046
    01-20-2015, 12:42 PM Go to last post
  57. SAS proceedings

    This is a gold mine both for stats, and other areas, and coding. I have only gone to the 2010 and 2014 sites and I have five pages of links that I...

    Started by noetsi‎, 01-13-2015 01:12 PM
    • Replies: 0
    • Views: 1,341
    01-13-2015, 01:12 PM Go to last post
  58. Problems with matched sampling using SAS

    Hi, I tried to find matched control matches to multiple variables: 1) age +/- 10 years and 2) diabetes I used the codes as shown below...

    Started by biscodyl‎, 01-12-2015 07:08 AM
    matched controls, matched variables, matching
    • Replies: 1
    • Views: 1,811
    01-12-2015, 10:51 AM Go to last post
  59. Generating distributions for all variables in a data set.

    This is fairly simple, but I figured others might find this of value. https://communities.sas.com/thread/64329

    Started by noetsi‎, 01-08-2015 12:20 PM
    • Replies: 0
    • Views: 1,354
    01-08-2015, 12:20 PM Go to last post

+ Post New Thread
Page 3 of 22 FirstFirst 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 LastLast

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 300 views
Hot thread with unread posts
More than 15 replies or 300 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats