topic Format Class Variables When Using 'Summary Tables' in EG in SAS Enterprise Guide

Format Class Variables When Using 'Summary Tables' in EG

Macavity — Fri, 12 May 2017 02:38:33 GMT

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

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

art297 — Fri, 12 May 2017 16:01:33 GMT

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

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

TomKari — Fri, 12 May 2017 17:09:33 GMT

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

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

Macavity — Mon, 15 May 2017 00:54:51 GMT

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

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

Macavity — Mon, 15 May 2017 00:56:47 GMT

That's a useful guide, thank you Art.