Converting 12OCT2012:00:00:00 to SAS numeric date

[teg_76]

Hi,

I'm trying to compare the dates in two fields, and delete the row based on a condition.  Here's what I have:

DATA PL.TREATMENT_PLANS_YEAR_365;

      SET PL.TREATMENT_PLANS_YEAR;

      current=date();

      date365=intnx('day',date(),365);

       if recalldate1>date365 then delete;

RUN;

recalldate 1 is in the format:

12OCT2012:00:00:00

date365 is in the SAS date format:

19466

How do I convert one or the other to make this comparison?

Thank you in advance

[Haikuo · Accepted solution]

  if datepart( recalldate1)>date365 then delete;

Haikuo

[Haikuo]

Update:

or if ' recalldate1' is character variable, then:

datepart(input( recalldate1 ,datetime20.)) >date365 then delete;

Haikuo

[teg_76]

Thanks Hai.kuo.  Would you know how to do this within a PROC SQL:

PROC SQL;

CREATE TABLE PX_RECALL_1 AS

SELECT * FROM

(SELECT SUM(UNITS) AS RECALL1_UNITS

FROM

PL.TREATMENT_PLANS_2012_04_11

WHERE RECALLTYPE='PX'

AND RECALLDATE1<=SYSDATE+365);

RUN;

It doesn't recognize sysdate.

ERROR: The following columns were not found in the contributing tables: SYSDATE.

[Haikuo]

if sysdate is a SAS table variable, then you don't have it.

If what you are trying to do is to extract the SAS session starting date, then use &sysdate,

if what you need is the today's date, then use today() or date()

Haikuo

[teg_76]

Thank you Haikuo!

[Reeza]

sysdate will be a date variable as will today() and date(), you'll still need to convert recalldate1 to a date format using datepart

ie

AND datepart(RECALLDATE1)<=(&SYSDATE+365)

[teg_76]

Thanks Reeza!