CODEWITHSUNDEEP
sas
Leo Barca
Leo Barca

Reputation: 39

The Subsetting IF Statement with date in SAS

I have been working on a SAS problem on the University Edition where it is given that:

Separate out the data only for passenger vehicle launched after 1-October-2014;

data passenger;
set avik1.clean;
informat Latest_Launch ddmmyy10.;
if Vehicle_type = "Passenger" and Latest_Launch > "01-10-2014";
run;
proc print data=passenger;
run;

I am able to separate only the passenger vehicles however my date has no effect as it doesn't separate out the dates after 01/10/2014.

I ran the Proc Contents Command just in case you would like to have a look on my data attributes

Proc Contents Print Output

I am new to SAS and I am facing some issues whenever there is a date problem.

Upvotes: 1

Views: 2005

Answers (1)

data _null_
data _null_

Reputation: 9109

In SAS date constants are written 'DDMONYYYY'D date9 format followed by D.

for you '01OCT2014'd

Upvotes: 3

Related Questions