topic Re: Converting 12OCT2012:00:00:00 to SAS numeric date in SAS Procedures

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

teg_76 — Wed, 18 Apr 2012 17:15:41 GMT

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

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

Haikuo — Wed, 18 Apr 2012 17:23:17 GMT

if datepart( recalldate1)>date365 then delete;

Haikuo

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

Haikuo — Wed, 18 Apr 2012 17:29:58 GMT

Update:

or if ' recalldate1' is character variable, then:

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

Haikuo

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

teg_76 — Wed, 18 Apr 2012 17:41:25 GMT

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.

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

Haikuo — Wed, 18 Apr 2012 17:51:57 GMT

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

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

Reeza — Wed, 18 Apr 2012 18:00:44 GMT

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

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

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

teg_76 — Wed, 18 Apr 2012 18:40:50 GMT

Thank you Haikuo!

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

teg_76 — Wed, 18 Apr 2012 18:42:26 GMT

Thanks Reeza!