BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
confused_saser
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION
4 REPLIES 4
data_null__
Jade | Level 19

@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
PROC Star

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;

 

atzamis
Obsidian | Level 7

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
01MAY200701DEC2010

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 8809 views
  • 0 likes
  • 5 in conversation