topic Proc freq result layout in SAS Enterprise Guide

Proc freq result layout

ChrisWoo — Mon, 07 Oct 2024 16:47:08 GMT

Hi guys,

would like to ask why my proc freq layout (1st image) is so much different from the SAS documentation example (2nd image)?

Why the "Frequency", "Percent", "Row Pct" and "Col Pct" aren't placed at the top left corner like 2nd image?

Re: Proc freq result layout

PaigeMiller — Mon, 07 Oct 2024 16:51:39 GMT

Obviously, something is different in your code. So, please show us your code. Paste the code as text into the window that appears when you clikc on the "little running man" icon.

Re: Proc freq result layout

yabwon — Mon, 07 Oct 2024 16:55:14 GMT

My first guess is they are using different style or options then you.

Show us your code, give us link to that doc. you've been referring to, this way we could start to help you...

Bart

Re: Proc freq result layout

ChrisWoo — Mon, 07 Oct 2024 17:05:39 GMT

my code just simple as this

proc freq data = merge_compare_audit_SDIS1 ;
     tables variable*app_sys_code ;
     where tag <> "Match";
run;

Re: Proc freq result layout

Tom — Mon, 07 Oct 2024 18:41:09 GMT

What is ODS TAGSETS.SASREPORT1?

Did you submit this code from some front end tool that added that? SAS Enterprise Guide perhaps?

Re: Proc freq result layout

ChrisWoo — Tue, 08 Oct 2024 02:24:20 GMT

hmmm. i suspect of that too.
However, i didn't write and submit that code.

Probably it is by default.

Re: Proc freq result layout

Tom — Tue, 08 Oct 2024 02:38:38 GMT

So what version of Enterprise Guide are you using?

What version of SAS is Enterprise Guide using to run the SAS code it submits for you? You can check the value of the automatic macro variable SYSVLONG (normally you can see the version of SAS you are using at the top of your SAS LOG file, but tools like Enterprise Guide that submit the code to SAS for you normally do not show you the full end to end SAS log).

%put &=sysvlong ;

Note that SAS has been on version 9.4 for over a decade so which maintenance level you are using is very important. https://blogs.sas.com/content/iml/2013/08/02/how-old-is-your-version-of-sas-release-dates-for-sas-software.html

Re: Proc freq result layout

ChrisWoo — Tue, 08 Oct 2024 06:52:19 GMT

hmmm, i run the code in SAS EG and it shows 9.04.0M5P091317.

I believe i'm using the latest SAS version 9.4.

However, it's probably due to my Enterprise Guide version is old (SAS EG 7.1),
becuase i run the same code (proc freq) in Base SAS, the report is looking fine and neat.

Re: Proc freq result layout

FreelanceReinh — Tue, 08 Oct 2024 08:13:33 GMT

@ChrisWoo wrote:
i run the code in SAS EG and it shows 9.04.0M5P091317.
... my Enterprise Guide version is old (SAS EG 7.1),

Hello @ChrisWoo,

I'm using exactly the same SAS and SAS EG versions (but normally I do not use SAS EG) and I can confirm your findings.

With

ods html file = your_fileref_or_path;

... your PROC FREQ step ...

ods html close;

the resulting HTML file should have the normal layout as in the documentation example.

Instead of coding the ODS HTML statements yourself as shown above, you can change the SAS EG settings to switch from the default ODS Tagset to ODS HTML:

In Tools → Options... → Results → Results General → Result Formats deselect the checkbox "SAS Report" and select the checkbox "HTML" instead.

Re: Proc freq result layout

ballardw — Tue, 08 Oct 2024 14:23:02 GMT

@ChrisWoo wrote:
hmmm, i run the code in SAS EG and it shows 9.04.0M5P091317.

I believe i'm using the latest SAS version 9.4.

However, it's probably due to my Enterprise Guide version is old (SAS EG 7.1),
becuase i run the same code (proc freq) in Base SAS, the report is looking fine and neat.

SAS 9.4.8 (9.04.0M8 has been out for quite a while M5 would be 3 releases ago).

And it is the behavior EG 7.1 even with later versions of SAS.