topic Re: Modifying Proc Report in SAS Programming

Modifying Proc Report

Etoo12121 — Mon, 29 Nov 2021 21:11:07 GMT

Hi,

How can I get the below proc report output to show the statistics vertically? After every visit, I want to show all the statistics going down.

Here is the code I currently have:

proc report data=Test;
columns visit Groups, adlscore_: ;
define visit / 'Visit' group ;
define adlscore_N / ANALYSIS "N" Spacing=2;
define adlscore_Mean / analysis "Mean" format=6.2 Spacing=2;
define ADLSCORE_StdDev / analysis "SD" format=6.2 Spacing=2;
define ADLSCORE_LCLM / analysis "L95%CI" format=6.2 Spacing=2;
define ADLSCORE_UCLM / analysis "U95%CI" format=6.2 Spacing=2;
define ADLSCORE_Median /analysis "Median" format=6.2 Spacing=2;
define ADLSCORE_Min / analysis "Min" format=6.2 Spacing=2;
define ADLSCORE_Max / analysis "Max" format=6.2;
define groups / across ;

endcomp;

run;

Here is how the output should look

Re: Modifying Proc Report

PaigeMiller — Mon, 29 Nov 2021 21:27:08 GMT

This request seems to go against the grain of PROC REPORT.

You would need to re-arrange your data set and create a variable that takes on values N MEAN MIN MAX etc. So on the rows where this variable has the value N, you have the statistic n; on the rows with MEAN you have the statistic mean; and so on.

Re: Modifying Proc Report

PaigeMiller — Mon, 29 Nov 2021 22:07:32 GMT

Adding: you can in the wide layout that you show, have all the N together (three columns, one each for group 0, 1 and 2) and then have all the means together (three columns, one each for group 0, 1 and 2), and so on. This isn't hard to do in PROC REPORT.

Re: Modifying Proc Report

Reeza — Mon, 29 Nov 2021 22:22:11 GMT

PROC TABULATE seems like it would work here if you use the raw data rather than summarized data?

Something like this:

proc tabulate data=test;
class visits groups;
var adlscore;
table visit * adlscore*(N MEAN STD LCLM UCLM MEDIAN MIN MAX), groups;
run;

@Etoo12121 wrote:

Hi,

How can I get the below proc report output to show the statistics vertically? After every visit, I want to show all the statistics going down.

Here is the code I currently have:

proc report data=Test;
columns visit Groups, adlscore_: ;
define visit / 'Visit' group ;
define adlscore_N / ANALYSIS "N" Spacing=2;
define adlscore_Mean / analysis "Mean" format=6.2 Spacing=2;
define ADLSCORE_StdDev / analysis "SD" format=6.2 Spacing=2;
define ADLSCORE_LCLM / analysis "L95%CI" format=6.2 Spacing=2;
define ADLSCORE_UCLM / analysis "U95%CI" format=6.2 Spacing=2;
define ADLSCORE_Median /analysis "Median" format=6.2 Spacing=2;
define ADLSCORE_Min / analysis "Min" format=6.2 Spacing=2;
define ADLSCORE_Max / analysis "Max" format=6.2;
define groups / across ;

endcomp;

run;

Here is how the output should look

Re: Modifying Proc Report

Etoo12121 — Tue, 30 Nov 2021 00:24:05 GMT

Proc tabulate would be great but I have table shells I must follow. The final output has 4 weeks in the Visit column so the table bleeds out onto another page when I output into rtf using ODS. I must have the entire table on one page so using tabulate isn't my best option. Anyway I can calculate the same descriptive stats in proc report if I use the raw data?

Something like this:
proc report data=Test;
columns visit Groups, adlscore_: ;
define visit / 'Visit' group ;
define adlscore / ANALYSIS N Spacing=2;
define adlscore / analysis Mean format=6.2 Spacing=2;
define adlscore / analysis Std format=6.2 Spacing=2;
define adlscore / analysis CLM format=6.2 Spacing=2;
define adlscore / analysis Median format=6.2 Spacing=2;
define adlscore / analysis Min format=6.2 Spacing=2;
define adlscore / analysis Max format=6.2;
define groups / across ;

endcomp;
run;

Re: Modifying Proc Report

Etoo12121 — Tue, 30 Nov 2021 00:24:31 GMT

Not sure I follow