SAS Date

[robertrao]

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;

[Reeza]

If procedure date is a number as in 20,140,204 then no. You first need to convert that to a sas date or convert recorded time to a similar format. I would suggest using SAS dates on both.

[robertrao]

Thank you for the reply.

I will change to a sas date and then do the comparision.

Regards