delete observation based on dates

[sasphd]

data output;
set datarolling_ETFS;
if rankdate < '20050630'YYMMDDN8. then delete;
run;

I have problem to define the format date 

Edit by KB: Formatted code and put it in correct window.

[Jagadishkatam · Accepted solution]

We can use the date literals as below 


data output; 
set datarolling_ETFS; 
if rankdate<'30Jun2005'd then delete; 
run;

[novinosrin]

Assuming your date is a numeric sas date formatted with yymmddn8

if rankdate<'30JUN2005'd then delete;

should work

However, you need to confirm whether or not your date is numeric or char

Proc contents should give you that information

[Astounding]

The answer depends on what your variable actually contains. 

It is a true SAS date?  Then use:

if rankdate < '30Jun2005'd then delete;

Is it a six-digit number?  Then use:

if rankdate < 20050630 then delete;

Is it a character variable of some sort?  Then use:

if input(rankdate, 6.) < 20050630 then delete;

But you need to understand some basic information about what is in your variable to select the proper answer.

[Kurt_Bremser]

To keep the ymd date format, use the input() function:

data output;
set datarolling_ETFS;
if rankdate < input('20050630',YYMMDD8.) then delete;
run;