topic Re: compiling proc freq results into one table in SAS Programming

compiling proc freq results into one table

yoyong555 — Tue, 07 Jan 2020 18:43:49 GMT

Happy New Year everyone!

I would like to merge the results of 3 tables as a result of my proc freq data step.

How do I do this?

Example:

proc freq data = step;

tables (site_1 site_2 site_3)*gender / norow nocol nopercent nocum;

run;

where site_1, site_2 and site_3 has three possible options (A,B,C)

and gender = (M,F)

Thanks.

Re: compiling proc freq results into one table

PaigeMiller — Tue, 07 Jan 2020 18:59:33 GMT

@yoyong555 wrote:

I would like to merge the results of 3 tables

This isn't particularly specific about what the "merge" should look like. Describe how such a "merge" should happen. Show us what the merged table should look like.

Re: compiling proc freq results into one table

yoyong555 — Tue, 07 Jan 2020 18:50:47 GMT

Hi Paige.

The table should look like this:

Site

Gender A B C Total

Total

Re: compiling proc freq results into one table

PaigeMiller — Tue, 07 Jan 2020 19:18:38 GMT

How do we derive the numbers in the cells? What is the math? What is the formula?

Re: compiling proc freq results into one table

yoyong555 — Tue, 07 Jan 2020 19:17:57 GMT

I will have three tables as a result of my proc freq datasetp. The tables will look like:

site_1

Gender A B C Total

F 1 1 1 3

M 2 2 0 4

Total 3 3 1 7

site_2

Gender A B C Total

F 3 4 6 13

M 2 0 3 5

Total 5 4 9 18

site_3

Gender A B C Total

F 2 1 1 4

M 4 2 5 11

Total 6 3 6 15

How do I merge the results of these tables to look like this:

site

Gender A B C Total

F 6 6 8 20

M 8 4 8 20

Total 14 10 16 40

Thank you.

Re: compiling proc freq results into one table

PaigeMiller — Tue, 07 Jan 2020 19:21:33 GMT

You change the data set

data want;
    set have;
    site=site_1; output;
    site=site_2; output;
    site=site_3; output;
run;

and then you run your PROC FREQ on site*gender

Re: compiling proc freq results into one table

Reeza — Tue, 07 Jan 2020 19:40:59 GMT

Use PROC TRANSPOSE to resturcture your input data, so that you have a single Site variable and then use PROC FREQ on the new data set.

Re: compiling proc freq results into one table

yoyong555 — Tue, 07 Jan 2020 19:41:21 GMT

Thank you.