Hello,
I have a numeric SAS date and a number. Can i compare the two.???
when i try the below code it would give me all missing values under the flag variable being created.
I have multiple records per ID with Procedure_date being same for the ID but the Recorded_Time varies....
ID RECORDED_TIME(numeric date) PROCEDURE_DATE(number)
101 09FEB2014:09:20:00.000 20140204
101 10FEB2014:09:20:00.000 20140204
101 11FEB2014:09:20:00.000 20140204
data RN2;
set RN;
by ID;
if datepart(RECORDED_TIME) ge ProcedureDate then flag=1;
run;
Thank you for the reply.
I will change to a sas date and then do the comparision.
Regards
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.