Hello,
I used to use proc tabulate to get a range of dates in a normal format (e.g., 2018/07/18).
proc tabulate data=mydata;
var dob;
table dob,
n nmiss (min max)*f=mmddyy10.;
run;
Now, I started using SAS Enterprise Guide and I am looking for pull-down menus (if there are any) to get this information.
Could anybody tel me how to get a range of dates in a normal format?
Thank you,
Yoko
Yes, it's a little obscure. In "Summary Tables", the second tab lets you "draw" your table by dragging your variables and the statistics. When you've done that (I've attached what mine looks like), right click on the "max" header, select "Data Value Properties", select the "Format" tab, and pick the desired date format.
Tom
The "Summary Tables" task will let you do exactly this.
Once you have the table set up the way you like it, right-click on the "max" box and select "Data Value Properties". There's a "Format" tab, where you can pick the desired date format.
Tom
Hi Tom,
I got a table and right-clicked on the max. But, there was no option for formatting. Could you explain what you mean by the table set up? I guess you did not mean the actual table to click...
Thank you,
Yoko
Yes, it's a little obscure. In "Summary Tables", the second tab lets you "draw" your table by dragging your variables and the statistics. When you've done that (I've attached what mine looks like), right click on the "max" header, select "Data Value Properties", select the "Format" tab, and pick the desired date format.
Tom
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.