calculating previous dates

[Raj00007]

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]

T

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

[Kurt_Bremser · Accepted solution]

---

@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]

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.