topic Re: How can I find the earliest and latest date in my dataset? in SAS Procedures

How can I find the earliest and latest date in my dataset?

confused_saser — Mon, 23 Jan 2017 21:54:33 GMT

I just want to visually see what the earliest and latest date is in my dataset for a specific date variable. How can I accomplish this?

Re: How can I find the earliest and latest date in my dataset?

data_null__ — Mon, 23 Jan 2017 22:10:52 GMT

@confused_saser wrote:

I just want to visually see what the earliest and latest date is in my dataset for a specific date variable. How can I accomplish this?

min

max

Re: How can I find the earliest and latest date in my dataset?

Astounding — Mon, 23 Jan 2017 22:16:32 GMT

Calculate and print:

proc summary data=have;

var datevar;

output out=stats min=mindate max=maxdate;

run;

proc print data=stats;

var mindate maxdate;

format mindate maxdate yymmdd10.;

run;

Re: How can I find the earliest and latest date in my dataset?

Kurt_Bremser — Mon, 23 Jan 2017 22:21:58 GMT

proc sql;
select max(datevar) as maxdate, min(datevar) as mindate
from have;
quit;

Re: How can I find the earliest and latest date in my dataset?

atzamis — Fri, 10 Mar 2017 13:10:42 GMT

You could alse try proc tabulate (assuming variable values are stored as sas date)

data test;
input dt date9.;
datalines;
01jul2009
01may2007
.
01dec2010
;
proc tabulate data=test format=date9.;
var dt;
table dt=''*(min='min date' max='max date') ;
run;

min date max date

01MAY2007

01DEC2010