topic Re: How to retain crosstab table percentages in output dataset? in SAS Programming

How to retain crosstab table percentages in output dataset?

RobertWF1 — Wed, 15 May 2024 16:27:38 GMT

I'm outputting the frequency counts and %s from a crosstab table to a data set (out=test_freq in example code below).

The conditional percentages by x values are correct in the SAS Results tab, however the %s in the test_freq output dataset are not correct.

Is my syntax incorrect?

data test;
input x $ y $;
cards;
Alice blue
Alice blue
Alice blue
Alice green
Alice green
Alice red
Bob blue
Bob green
Bob green
Bob green
Bob red
Bob red
Bob red
Bob red
;
run;

proc freq data=test;
table x*y / nopercent nocol out=test_freq;
run;

Re: How to retain crosstab table percentages in output dataset?

PaigeMiller — Wed, 15 May 2024 16:40:31 GMT

@RobertWF1 wrote:

The conditional percentages by x values are correct in the SAS Results tab, however the %s in the test_freq output dataset are not correct.

Never say something is incorrect without explanation. We don't know what you expect. What is not correct about the percents?

Re: How to retain crosstab table percentages in output dataset?

ballardw — Wed, 15 May 2024 16:44:15 GMT

I think you should provide example of what exactly is "not correct" and what you expect the result to be.

By default the OUT= only provides the PERCENT, not the row and column percentages. If you want those using the OUT= option then you need the OUTPCT option to add them the data.

proc freq data=work.test;

table x*y / nopercent nocol outpct out=work.test_freq;
run;

Re: How to retain crosstab table percentages in output dataset?

RobertWF1 — Wed, 15 May 2024 17:31:34 GMT

The row percents in the crosstab output don't match the table %s in the output dataset.

Re: How to retain crosstab table percentages in output dataset?

RobertWF1 — Wed, 15 May 2024 17:32:13 GMT

The OUTPCT option is what I'm looking for, thank you!