Format Class Variables When Using 'Summary Tables' in EG

[Macavity]

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

[art297]

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

[Macavity]

That's a useful guide, thank you Art.

[TomKari · Accepted solution]

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

[Macavity]

Thank Tom, that's exactly what I'm looking for.