DATA Step, Macro, Functions and more

sas date

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 102
Accepted Solution

sas date

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


Accepted Solutions
Solution
‎06-21-2013 04:13 PM
Super User
Super User
Posts: 6,500

Re: sas date

proc summary  ;

  var date1 date2 ;

  output out=stats;

run;

proc print data=stats;

where _stat_ in ('MIN','MAX');

format date1 date2 year.;

run;

View solution in original post


All Replies
Solution
‎06-21-2013 04:13 PM
Super User
Super User
Posts: 6,500

Re: sas date

proc summary  ;

  var date1 date2 ;

  output out=stats;

run;

proc print data=stats;

where _stat_ in ('MIN','MAX');

format date1 date2 year.;

run;

Frequent Contributor
Posts: 102

Re: sas date

Thanks, Tom.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 141 views
  • 0 likes
  • 2 in conversation