Hey Guys,
I have a bunch of daily data to be summarised/counted by year with the task 'Summary Tables' in EG. I know how to do that in code, which is like:
proc tabulate data=mydata missing;
class date;
format date year.;
tables date, n;
run;
But I would really like to achieve this with the built-in task. I've tried almost everywhere I can think of for specifying format for date column with no luck.
I must have missed some context memu or options that any of you can point out?
Ning
Here's what works for me...
For your data, select Describe | Summary Tables
In the Data tab, drag your date field to the Classification variables area.
There should be a box on the right where you can change the characteristics of the variable that's selected. Select the "Heading format" box, and put your date format in there.
Tom
I'm not an EG user, so might be off track, but can't you assign the format using either the table or data properties screens? Some nice step-by-step examples are shown at: chrome-extension://oemmndcbldboiebfnladdacbdfmadadm/http://www2.sas.com/proceedings/sugi31/113-31.pdf
Art, CEO, AnalystFinder.com
Here's what works for me...
For your data, select Describe | Summary Tables
In the Data tab, drag your date field to the Classification variables area.
There should be a box on the right where you can change the characteristics of the variable that's selected. Select the "Heading format" box, and put your date format in there.
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.