Hello all. It's really a simple question, but I can't find the solution. I have a file with a time variable and another dataset with the starting date. The time variable is over several days and I want to create a time date variable (that increase the date by 1 at midnight of course) My solution so far doesn't work: Time is time variable in text format. Datum is date in text format. Code below (inside a macro): data &dataset_name.date; set &dataset_name.id; timme=substr(time,1,2)*1; if _n_ eq 1 then do; set &dataset_name._date(rename=(data=datum)); end; datumnum=mdy(substr(datum,6,2),substr(datum,9,2),substr(datum,1,4)); run; data &dataset_name.dateid; retain datumnum; set &dataset_name.date; by datumnum; if dif(timme)<0 then datumnum+1; Timedate=DHMS( datumnum, substr(time,1,2), substr(time,4,2), substr(time,7,2) ); format Timedate datetime.; run;
... View more