Proc freq result layout

[ChrisWoo]

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?

[PaigeMiller]

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.

[yabwon]

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

[ChrisWoo]

my code just simple as this

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

[Tom]

What is ODS TAGSETS.SASREPORT1?

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

[ChrisWoo]

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

Probably it is by default.

[Tom]

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-so...

[ChrisWoo]

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.

[FreelanceReinh · Accepted solution]

---

@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.

[ballardw]

---

@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.