11-13-2017 07:00 AM
i am searching for code where it should flag current date & time as 1 and previous all records as 0
e.g. st_date= 13/11/2017 15:30:33 =1
where st_date=13/11/2017 14:30:33 =0;
As i am appending the data to new data set so if it runs multiple times the flag should tag the latest run as 1 rest as 0
11-13-2017 07:02 AM - edited 11-13-2017 07:03 AM
Are you working with a datetime variable or a date and a time variable separately?
Post some example data, that makes it a lot easier to give a usable answer ..
11-13-2017 07:09 AM
So if your appending data, and presumably this will continue into the future, what happens to new data nest time? Or does this process affect all the data new and old? The logic is simple either way but which you choose depends on your situation:
data want; set old new; check=ifn(your_date < today(),0,1); run;
data new; set new; check=ifn(your_date < today(),0,1); run; data want; set old new; run;
Assumes real datetime.