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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.