Having a data folder with lots of xlsx files, and each xlsx file has several sheets, and one of these sheets is "data1". How to use Proc IMPORT to read multiple .xlsx files? My following code has some problem. My SAS:  9.3 (TS1M1), and excel 2010 %let DATAFILE= C:\Users\test\Desktop\test\*.xlsx; Title "Import multiple .xlsx files"; PROC IMPORT OUT= test             DATAFILE= "&DATAFILE"             DBMS=EXCELCS REPLACE ;      RANGE="data1$";      SCANTEXT=YES;      USEDATE=YES;      SCANTIME=YES; RUN; ... View more

Having a data folder with lots of xlsx files, and each xlsx file has several sheets, and one of these sheets is "data1". How to use Proc IMPORT to read multiple .xlsx files? My following code has some problem. My SAS:  9.3 (TS1M1) %let DATAFILE= C:\Users\test\Desktop\test\*.xlsx; Title "Import multiple .xlsx files"; PROC IMPORT OUT= test             DATAFILE= "&DATAFILE"             DBMS=EXCELCS REPLACE ;      RANGE="data1$";      SCANTEXT=YES;      USEDATE=YES;      SCANTIME=YES; RUN; ... View more

Data test; input date Body_Weight_Kg; datalines; 1/1/2012  20 1/2/2012  . 1/3/2012 . 1/4/2012 25 1/5/2012 27 1/6/2012  . 1/7/2012 30 1/8/2012 . 1/9/2012 33 ............ ; I have thousand lines of data, I want to calculate average daily weight gain. For example 1/2/2012, 1/3/2012, and 1/4/2012, WG=(25-20)/3. On 1/5/2012, WG=(27-25)/1.  ... View more

Raw data look like: Date  a 1     . 2    . 3    4    (note total number from day 1 to 3) 4  . 5 . 6  . 7  9  (note total number from day 4 to 7) 8 . 9 . 10 8 How to change these irregular total to daily average? It looks the daily average gradually increase, so I didn't want to calculate as: day 1-3: 4/3 day 4-7: 9/5 day 8-10: 8/3 thanks a lot! ... View more

About data: (1) Prepared 4 different diets for pig industry: diet Ingredient A Ingredient B A_low_B_low Low Low A_high_B_low High Low A_low_B_high Low High A_high_B_high High High (2) Twelve (12) group pigs were randomly assigned to one of the diets, so 3 group pigs per diet treat. (3) Twelve group pigs' weight (total) was monitored for 30 days (daily total weight). The following questions might be asked: (1)  Does the ingredient A affect pig performance? (2) Does the ingredient B affect pig performance? (3) Does age affect pig performance? (4)  Is there evidence of interactions among ingredient A, B and Age? I have tried to build the flowing model, but I am not so sure it is correct, please help: Title "proc mixture"; proc mixed data=pigs;    Class group ingredA ingredB Age ;    Model Weight =ingredA|ingredB;    random group;    repeated Age/type=cs subject=group; run; ... View more

Using Proc sgplot, and having some numbers needed to be subscript. Tried to use ODS escpechar='^";   and move options, but they did not work. Data test; input x y; datalines; 1 2 3 6 7 10 8 19 ; run; proc sgplot data=test;    scatter x=x y=y;   xaxis label="H2O"; yaxis label ="(NH3)2SO4"; run; ... View more

How to do data1 stat (for example mean) calculation based on data2 time range? Data1 time x y 11:00 2 3 11:02 7 8 11:03 4 5 11:07 10 30 12:00 30 20 12:03 21 4 .............. Data2 TimeStart TimeEnd 11:00 11:07 11:03 12:00 12:00 12:03 .................... Want to get results TimeStart TimeEnd MeanX meanY 11:00 11:07 ? ? 11:03 12:00 ? ? 12:00 12:03 ? ? ............................ ... View more

Data1 time x y 11:00 2 3 11:03 4 5 11:07 10 30 12:00 30 20 12:03 21 4 .............. Data2 TimeStart TimeEnd 11:00 11:07 11:03 12:00 12:00 12:03 .................... Want to get results TimeStart TimeEnd MeanX meanY 11:00 11:07 ? ? 11:03 12:00 ? ? 12:00 12:03 ? ? ............................ ... View more