06-03-2016 10:45 AM
I need to replace missing values in my data set. I need SAS to reference the previous observation and calculate the date of the current observation based on the previous observation.
data Example; set Example1;
If Date = "." then do;
Date = Obs - 1 ....... Date+1;
06-03-2016 11:03 AM
There is a LAG function in SAS that allows you to reference the value of a variable on the previous observation.
It is well documented and works along the lines of
If date = . then date = lag(date) + 1;
06-03-2016 04:06 PM
Use a retained variable:
data want; retain previousDate; set have; date = coalesce(date, intnx("DAY", previousDate, 1)); previousDate = date; drop previousDate; run;