topic Re: Flagging code in SAS Programming

Flagging code

anirudhs — Mon, 13 Nov 2017 12:00:39 GMT

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

Thanks

Re: Flagging code

PeterClemmensen — Mon, 13 Nov 2017 12:03:34 GMT

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 ..

Re: Flagging code

RW9 — Mon, 13 Nov 2017 12:09:56 GMT

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;

Or:

data new;
  set new;
  check=ifn(your_date < today(),0,1);
run;
data want;
  set old new;
run;

Assumes real datetime.