topic Re: calculating previous dates in New SAS User

calculating previous dates

Raj00007 — Thu, 13 Aug 2020 05:29:39 GMT

Hi,

i have variable (Date) with dates such as 01MARCH2010 till 12 DEC2011.

How do i get only variables less than 10JUN2010. iam trying with this code, but it's not executing properly.

data flightdelays;
set lib.flightdelays;
where Date < 10JUN2010;
run;
proc print;
run;

TarunKumar — Thu, 13 Aug 2020 05:35:05 GMT

data flightdelays;
set lib.flightdelays;
if Date < '10JUN2010'n;
run;
proc print;
run;

Kurt_Bremser — Thu, 13 Aug 2020 06:14:53 GMT

@TarunKumar wrote:

T

data flightdelays;
set lib.flightdelays;
if Date < '10JUN2010'n;
run;
proc print;
run;

Do you really think @Raj00007 has a variable named

10JUN2010

The proper character for a date literal is d:

'10JUN2010'd

Kurt_Bremser — Thu, 13 Aug 2020 06:18:26 GMT

Use a correct date literal:

data flightdelays;
set lib.flightdelays;
where Date < '10JUN2010'd;
run;

You do not need to create a separate dataset, though; WHERE statements (or WHERE= dataset options) can be used in most procedures.