DATA Step, Macro, Functions and more

Flagging code

Reply
Contributor
Posts: 22

Flagging code

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

PROC Star
Posts: 768

Re: Flagging code

[ Edited ]

Are you working with a datetime variable or a date and a time variable separately? Smiley Happy

 

Post some example data, that makes it a lot easier to give a usable answer ..

Super User
Super User
Posts: 7,997

Re: Flagging code

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.

Ask a Question
Discussion stats
  • 2 replies
  • 73 views
  • 0 likes
  • 3 in conversation