Desktop productivity for business analysts and programmers

Format Class Variables When Using 'Summary Tables' in EG

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Format Class Variables When Using 'Summary Tables' in EG

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


Accepted Solutions
Solution
‎05-14-2017 08:54 PM
PROC Star
Posts: 1,146

Re: Format Class Variables When Using 'Summary Tables' in EG

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

View solution in original post


All Replies
PROC Star
Posts: 7,433

Re: Format Class Variables When Using 'Summary Tables' in EG

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

New Contributor
Posts: 4

Re: Format Class Variables When Using 'Summary Tables' in EG

That's a useful guide, thank you Art.
Solution
‎05-14-2017 08:54 PM
PROC Star
Posts: 1,146

Re: Format Class Variables When Using 'Summary Tables' in EG

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

New Contributor
Posts: 4

Re: Format Class Variables When Using 'Summary Tables' in EG

Thank Tom, that's exactly what I'm looking for.
☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 162 views
  • 2 likes
  • 3 in conversation