topic Re: Proc Report How to combine multiple reports into one report in ODS and Base Reporting

Proc Report How to combine multiple reports into one report

Skyez — Thu, 29 Jun 2023 03:26:01 GMT

Hi.

I need to create with the report like this. And I used multiple proc report to generate different reports, but now I want to concentrate them together to get the following result. What should I do? I need to output the PDF file.

Here is my code:

ods pdf file='/home/u6341199/sasuser.v94/Program1/report.pdf' startpage=no;
proc report data=program1.summarydaat2 nofs split='*' headline headskip; ;
  title1 "Demographic and baseline summary";
  title2 'All Randomized subjects';
  column AGE  DRUGA PLACEBO_ row_sum ;
  define AGE / group width=6 '' order;
  define DRUGA / "DRUG A*&agestr" format=comma10.2;
  define PLACEBO_ / "PLACEBO*&htstr" format=comma10.2;
  define row_sum/ computed format=comma10.2 "Total*&wtstr";
  break after age / ol skip suppress;
  compute before ;
 line @1 'Age';
endcomp;
  compute row_sum;
  row_sum = sum(_C2_,_C3_);
  endcompute;
 run; 

proc report data=program1.race_4 nofs split='*' headline headskip;
column Category DRUGA PLACEBO_ row_sum ;
define Category / group width=15 '' order;
  define DRUGA / "" ;
  define PLACEBO_ / "" ;
  define row_sum/ computed  "" style(column)={cellwidth=1in just = center};
  break after Category / ol skip suppress;
  compute before ;
 line @1 'Race';
endcomp;
  compute row_sum / character length=70;
  row_sum = sum(&count,&count2)||'('||strip(sum(&count1,&count3))||')';
  endcompute;
 run; 
proc report data=program1.sex_4 nofs split='*' headline headskip;
column Category DRUGA PLACEBO_ row_sum ;
define Category / group width=15 '' order;
  define DRUGA / "" ;
  define PLACEBO_ / "" ;
  define row_sum/ computed  "" style(column)={cellwidth=1in just = center};
  break after Category / ol skip suppress;
  compute before ;
 line @1 'SEX';
endcomp;
  compute row_sum / character length=70;
  row_sum = sum(&count,&count2)||'('||strip(sum(&count1,&count3))||')';
  endcompute;
 run; 
 proc report data=program1.Country_4 nofs split='*' headline headskip;
column Category DRUGA PLACEBO_ row_sum ;
define Category / group width=15 '' order;
  define DRUGA / "" ;
  define PLACEBO_ / "" ;
  define row_sum/ computed  "" style(column)={cellwidth=1in just = center};
  break after Category / ol skip suppress;
  compute before ;
 line @1 'Country';
endcomp;
  compute row_sum / character length=70;
  row_sum = sum(&count,&count2)||'('||strip(sum(&count1,&count3))||')';
  endcompute;
 run;
proc report data=program1.Ethnic_4 nofs split='*' headline headskip;
column Category DRUGA PLACEBO_ row_sum ;
define Category / group width=15 '' order;
  define DRUGA / "" ;
  define PLACEBO_ / "" ;
  define row_sum/ computed  "" style(column)={cellwidth=1in just = center};
  break after Category / ol skip suppress;
  compute before ;
 line @1 'Ethnic';
endcomp;
  compute row_sum / character length=70;
  row_sum = sum(&count,&count2)||'('||strip(sum(&count1,&count3))||')';
  endcompute;
 run;
 *rbreak after / dol skip summarize;

proc report data=program1.summarydaat3 nofs split='*' headline headskip; ;
  column AGE DRUGA PLACEBO_ row_sum ;
define AGE / group width=15 '' order;
  define DRUGA / "" format=6.2;
  define PLACEBO_ / "" format=6.2;
  define row_sum/ computed  "" style(column)={cellwidth=1in just = center} format=6.2;
  break after AGE / ol skip suppress;
  compute before ;
 line @1 'PLATELET COUNT';
endcomp;
  compute row_sum;
  row_sum = sum(_C2_,_C3_);
  endcompute;
 run; 
ods pdf close;

What I got look like this:

Re: Proc Report How to combine multiple reports into one report

PaigeMiller — Thu, 29 Jun 2023 09:44:24 GMT

Since the variables in the COLUMN statement are always the same (e.g. AGE DRUGA PLACEBO_ row_sum) you should be able to combine all data sets into one, and then run one PROC REPORT. Since you also have this code

 line @1 'Age';

in each PROC REPORT, you'd need a variable in the combined data set indicating if the values are AGE or RACE or SEX or ...

There's also the %TABLEN macro which seems like it can create the output desired.

Re: Proc Report How to combine multiple reports into one report

Skyez — Thu, 29 Jun 2023 19:19:36 GMT

Hi, thanks for your explanation! Unfortunately, if I merge them together, I can't use line statement to set category. It always shows error message that

The BREAK variable row5 is not one of the GROUP or ORDER variables.

Here is my code:

proc report data=program1.summdata nofs split='*' headline headskip; ;
  title1 "Demographic and baseline summary";
  title2 'All Randomized subjects';
  column AGE  DRUGA PLACEBO_ row_sum ;
  define AGE / group width=6 '' order=data;
  define DRUGA / "DRUG A*&agestr" order=data;
  define PLACEBO_ / "PLACEBO*&htstr" order=data;
  *define row_sum/ computed format=comma10.2 "Total*&wtstr";
  *break after age / ol skip suppress;
   *rbreak after / dol skip summarize;
  compute before ;
 line @1 'Age';
endcomp;
compute after row5;
line @7 'Race';
endcomp;
run;

Thanks for your help!

Re: Proc Report How to combine multiple reports into one report

Cynthia_sas — Thu, 29 Jun 2023 21:16:18 GMT

Hi:
You don't have a variable named ROW5 in your COLUMN statement. So PROC REPORT is telling you the issue. Do you instead mean to test the value of your ROW_SUM variable or some variable from the data???
Cynthia

Re: Proc Report How to combine multiple reports into one report

PaigeMiller — Fri, 30 Jun 2023 09:56:06 GMT

that's right. If you merge the data sets together, you should NOT use the LINE command.

Re: Proc Report How to combine multiple reports into one report

Skyez — Fri, 30 Jun 2023 01:53:39 GMT

Hi, thanks for your help. I already fixed this by using %glue.