Question about MONYY5. format

I have the following data set A with variable Mon (format: MONYY5.)

Mon
JAN10
FEB10
MAR10
APR10
MAY10

I want to get only records that after MAR10, but how can i use the GT in the code?

Data B;
Set A;
Where Mon GT 'MAR10'D.;------i KNOW its wrong, but I dont know how to do it right....
RUN;

Hello.  rockfido.
MONYY5. is an useful INFORMAT.  You can use this INFORMAT and INPUT function to convert a character into a date value.  The following is one of the solutions to your question.
Hope it helps.

1. data a;
   
2.         input Mon monyy5.;
   
3. cards;
   
4. JAN10
   
5. FEB10
   
6. MAR10
   
7. APR10
   
8. MAY10
   
9. ;
   
10. 
    
11. data b;
    
12.         set a;
    
13.         if mon gt input("MAR10",monyy5.);
    
14. run;

复制代码

Data B;
Set A;
Where mon GT '31MAR10'D;
RUN;

不知道怎么删自己的贴。 囧。

HI,try this code .
it works if the day  i added into doesn't make any difference
data test;
input mon monyy5.;
cards;
JAN10
FEB10
MAR10
APR10
MAY10
;
data b;
set test;
if mon >'01MAR10'd;
run;