topic Re: Why does the dataset I generated with my proc means table look different than my proc means tabl in SAS Software for Learning Community

Why does the dataset I generated with my proc means table look different than my proc means table?

wwwckk — Mon, 26 Feb 2024 22:49:27 GMT

/* FOLLOWING ARE MY CODES */

title "Base salary discrepancy within ranks";

title2 "By Gender";
PROC MEANS DATA=MD_Data mean;
VAR 'Base Salary'n;
CLASS 'Department Name'n Grade Gender;
output out = PayGap;
RUN;

The new dataset 'PayGap' looks different from the PROC MEANS table I generated. Why and how to fix it?

Thank you!

Re: Why does the dataset I generated with my proc means table look different than my proc means tabl

Reeza — Mon, 26 Feb 2024 22:49:36 GMT

Because it does 🙂

(Different output options can generate differently styled output).

Use the STACKODS option and ODS OUTPUT statement to get a table that looks like the output though.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p17h6q7ygvkl1sn13qzf947dundi.htm

@wwwckk wrote:

/* FOLLOWING ARE MY CODES */

title "Base salary discrepancy within ranks";

title2 "By Gender";
PROC MEANS DATA=MD_Data mean;
VAR 'Base Salary'n;
CLASS 'Department Name'n Grade Gender;
output out = PayGap;
RUN;

The new dataset 'PayGap' looks different from the PROC MEANS table I generated.

Thank you!

Re: Why does the dataset I generated with my proc means table look different than my proc means tabl

wwwckk — Mon, 26 Feb 2024 22:52:41 GMT

Thank you so much!!!

Re: Why does the dataset I generated with my proc means table look different than my proc means tabl

Tom — Tue, 27 Feb 2024 03:55:00 GMT

Because you asked for the DEFAULT output dataset instead of telling the OUTPUT statement what you actually wanted.

This should generate a dataset that is much closer.

output out = PayGap  mean=;

Read the documentation on what the OUTPUT statement can do.

If you are really desperate you could try using ODS OUTPUT statement to snag a copy of the data that the proc used to generate the printed report. But since that was structure designed to be PRINTED and not ANALYZED it will usually require a fair amount of work to make it useful.