topic Re: SAS Date in SAS Programming

SAS Date

robertrao — Tue, 22 Dec 2015 20:56:18 GMT

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;

Re: SAS Date

Reeza — Tue, 22 Dec 2015 20:59:10 GMT

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.

Re: SAS Date

robertrao — Tue, 22 Dec 2015 21:02:43 GMT

Thank you for the reply.

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

Regards