topic Re: Using filter on Date in SAS Enterprise Guide

Using filter on Date

ilmare — Thu, 31 May 2012 16:26:53 GMT

I formated 8 byte character string into Date(CCYYMMDD) by using INPUT.

I now want to use this Date in Filter to say Date>19990613, so that I can only pick the records that have Date greater than June 13, 1999.

I know there are such records that meet this criteria but when I run the project with this filter, I am getting 0 record back.

What am I doing wrong?

Thank you!!

Re: Using filter on Date

Haikuo — Thu, 31 May 2012 16:34:42 GMT

Hi,

When SAS does the comparison on date, it compares the true numeric value instead of formated value:

data _null_;

a=input('19990613',anydtdte.);

put a= a=date9.;

run;

So you can see, if you do: date>14408, then see what happens.

Haikuo

Re: Using filter on Date

FloydNevseta — Thu, 31 May 2012 17:59:22 GMT

...or date>'13jun1999'd

Re: Using filter on Date

ilmare — Thu, 31 May 2012 18:51:28 GMT

Haikuo:

Thank you for your advie.

As I am not familiar to the SAS coding, where can I go to find out the numeric value of 14408 in SEG? BTW, I used 14408 and it ran successfully with the date greater than Jun 13, 1999.

SAS_Bigot:

Thank you also for your advice.

I tried to use your expression on the Query Builder/Filter but it gave me an error. I must have done incorrectly.

Re: Using filter on Date

Haikuo — Thu, 31 May 2012 19:23:17 GMT

Sorry. My EG experience is close to '0'. There are many with EG skills on the forum, your question will be answered sufficiently.

Haikuo

Re: Using filter on Date

ilmare — Thu, 31 May 2012 19:27:03 GMT

Thank you, HaiKuo,

I was able to compute the Date by using Input w. anydtdte as you suggested, to come up with the numeric values in EG.

I appreciate your help.