Monday, 10 October 2011

SAS - date and time sql


proc sql;
select * from sashelp.air where month(date)>=4 and month(date)<=6;
quit;

proc sql;
select * from sashelp.air where month(date)>=4 and month(date)<=6
and year(date)=1950;
quit;

proc sql;
select * from sashelp.air where year(date)in (1950 1955);
quit;

No comments:

Post a Comment