how make a cross table with proc report and divide the sum of two variables?

LAIO — Thu, 29 Sep 2022 01:56:32 GMT

hey @Cynthia_sas can you give a hand here please?

i have 4 variables (2 numeric and 2 categorical), two for column and row group like the exemple bellow (fx_cr and gh_simp). You can ignore the "x2" rows/columns.

and other two variable to make the sum(var 1)/sum(var 2) inside of each spot of the exemple above. Do you have a code for this? i tried but i couldnt do that.

Re: how make a cross table with proc report and divide the sum of two variables?

Cynthia_sas — Thu, 29 Sep 2022 15:22:18 GMT

Hi:
Without code and data, it's hard to provide any constructive suggestions. Your current output looks like PROC TABULATE output. What PROC REPORT code have you tried? It's not clear to me from your screen shot, which 2 variables need to be divided and whether the division results go in the row (at the bottom of the report) or in a column (to the right side of the report). Can you provide any sample data in the form of a DATA step program? To accomplish crosstabs with PROC REPORT, you have to define ACROSS variable(s). Here's a simple example using SASHELP.CLASS. Getting the sum of the HEIGHT variable is a bit silly, but is shows how to ask for the SUM statistic with a numeric variable under the ACROSS item and also shows the use of the absolute column number in the division:

Without data, it's hard to do more than provide you with this simple example.
Cynthia

topic how make a cross table with proc report and divide the sum of two variables? in SAS Programming

how make a cross table with proc report and divide the sum of two variables?

Re: how make a cross table with proc report and divide the sum of two variables?