Hi all,   I have received an Excel file, where the date column is written in two formats: 7/nov/13 and 21oct2010. I can manually change the three month letter into /mon/ format in Excel.   However, I would like to do that only in SAS. When I use Libname abc xlsx "~\abc.xlsx"; data abc; set abc.Sheet1; run; The date column returns SAS Output 41585 and 21oct2010. I check with proc contents and the format for the date is char.   Do you have any idea of reading mixture date formats?   Thank you for reading my question! ... View more

Hi all,   I am using both SAS and R for my tasks. For a particular task, I use SAS for data manipulation, export, then import into R, and then use R to fit a Bayesian model with package rstan. For another task, I use R for data manipulation, export, then import into SAS.   I have known that we can call R into SAS by using proc iml. However, I think Rstudio is also strong as we can check values quickly so for me working with R in SAS is not much advantageous as working with R in Rstudio.   From your experience, could you suggest in which situations should we call R into SAS with proc iml rather than working independently as I mention above?   Thank you for reading!   Kind regards, Trung Dung. ... View more

Hi all,   I have a longitudinal data. Each subject is repeatedly measured over time:     data origin; input ID Time; cards; 12 3 12 5 12 18 16 7 16 25 16 28 16 44 ; run;     I would like to compute time distance. For the first measurement, time distance is set at 0. From the second time point, time distance is computed by subtracting the previous time from the current time. Time distance is set back to 0 when ID goes to the next one.   I have tried a program, it works.   proc sort data=origin out=origin_sort; by ID Time; run; data distance; set origin_sort; retain distance previous; by ID; if first.ID=1 then do; distance=0; previous=time; end; else do; distance=Time-previous; previous=previous+distance; end; run; proc print; run; I obtain the output as I want.   However, I have to use two variables, and previous is exactly the same as Time.   Do you think this is a best way to do or could you suggest some way better?   Thank you for reading.   P/S: I cannot copy and paste table into this question so I have to use image. I do not know how to use table here. Could you please guide me?   ... View more

Hi all,   I have a longitudinal data where each subject has a number of repeated measurements, i.e., occupying several rows in the data table. Unfortunately, the ID is not starting from 1. Now I would like to create a new ID, starting from 1. I have completed a SAS code as follows:   data original; input ID ; cards; 12 12 12 16 16 19 19 19 27 27 27 ; run; data newID; set original; retain newID 1 previousID 12; if ID=previousID then newID=newID; else newID=newID+1; previousID=ID; drop previousID; run; Proc print data=newID noobs; run; This code works as I want. However, I feel the code complicated. Do you have any suggestion to make it simpler?   Thank you for reading! ... View more