05-31-2012 12:26 PM
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?
05-31-2012 12:34 PM
When SAS does the comparison on date, it compares the true numeric value instead of formated value:
put a= a=date9.;
So you can see, if you do: date>14408, then see what happens.
05-31-2012 02:51 PM
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.
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.