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?
proc sql;
select max(datevar) as maxdate, min(datevar) as mindate
from have;
quit;
@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
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;
proc sql;
select max(datevar) as maxdate, min(datevar) as mindate
from have;
quit;
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;
01MAY2007 | 01DEC2010 |
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.