topic Re: PROC Report Across Columns in SAS Procedures

PROC Report Across Columns

Doug — Fri, 31 Aug 2012 12:51:12 GMT

I have code which produces a report where the number of columns may vary based upon the dataset using the ACROSS specification. Column grand totals are stored in unique macro variables GT_1 .... GT_x for as many columns as exist in the data. My question is, with a varying number of columns, is there any way to place the GT_x values above those columns (e.g., (N = 234), etc.)?

Re: PROC Report Across Columns

data_null__ — Fri, 31 Aug 2012 13:59:23 GMT

I would create a value label format for the values of ACROSS that includes N=. This can be done using a data step to create a CNTLIN data set for PROC FORMAT. This will provide a data driven solution that will be flexable based on the number of levels in the ACROSS variable.

Re: PROC Report Across Columns

Ksharp — Mon, 03 Sep 2012 02:38:41 GMT

I am afraid it is hard for proc report ,but it maybe easy for data step. What is your sample data and output you like ?

Ksharp

Re: PROC Report Across Columns

Cynthia_sas — Mon, 03 Sep 2012 15:07:20 GMT

Hi:

It is possible to do you you want because you can nest ACROSS variables under other ACROSS variables in order to get another level of variable -- which gives you another level of header. The fact that you are creating macro variables suggests that you have some degree of macro knowledge. Possibly something like a user-defined format might work, using CNTLIN, as already suggested.

Without more information from you, like seeing your existing code or getting an idea of your data in more detail, it's hard to provide specific advice.

Here's a very simple example, that uses a DATA step program to make the "extra" header variable from a macro variable and then uses the NOCOMPLETECOLS option of PROC REPORT to get only 1 header above every unique value of AGE. See attached screenshot.

cynthia