topic Re: delete observation based on dates in SAS Procedures

delete observation based on dates

sasphd — Fri, 22 Feb 2019 15:16:04 GMT

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 — Fri, 22 Feb 2019 15:13:44 GMT

We can use the date literals as below 


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

novinosrin — Fri, 22 Feb 2019 15:16:04 GMT

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 — Fri, 22 Feb 2019 15:16:19 GMT

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 — Fri, 22 Feb 2019 15:17:50 GMT

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

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