Desktop productivity for business analysts and programmers

Getting range of dates as a summary

Accepted Solution Solved
Reply
Contributor
Posts: 26
Accepted Solution

Getting range of dates as a summary

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 


Accepted Solutions
Solution
‎07-20-2018 10:52 AM
PROC Star
Posts: 1,334

Re: Getting range of dates as a summary

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

SASTemp.png

View solution in original post


All Replies
PROC Star
Posts: 1,334

Re: Getting range of dates as a summary

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

Contributor
Posts: 26

Re: Getting range of dates as a summary

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

Solution
‎07-20-2018 10:52 AM
PROC Star
Posts: 1,334

Re: Getting range of dates as a summary

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

SASTemp.png

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 100 views
  • 0 likes
  • 2 in conversation