Dear all,
I have a huge dataset (over 1,000,000 records) with TWO date variables, date1 (Date9.) format, date2 (YYMMDDN8.) format.. I want to see the lowest and highest values of the date variable to verify this dataset contains all the years I needed.
for example, I expect the earliest year is 1976, and latest is 2011.
I tried:
proc means var date1 date2;
but it shows numeric values, I can't tell which year it is.
Is there an easier way?
Thanks,
Lan
proc summary ;
var date1 date2 ;
output out=stats;
run;
proc print data=stats;
where _stat_ in ('MIN','MAX');
format date1 date2 year.;
run;
proc summary ;
var date1 date2 ;
output out=stats;
run;
proc print data=stats;
where _stat_ in ('MIN','MAX');
format date1 date2 year.;
run;
Thanks, Tom.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.