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

[confused_saser]

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?

[data_null__]

---

@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

[Astounding]

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;

[Kurt_Bremser · Accepted solution]

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

[atzamis]

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