topic Re: proc report in SAS Enterprise Guide

proc report

Daily1 — Tue, 20 Sep 2022 11:16:05 GMT

it's possible to create proc report ?

data three;
	infile datalines;
	input a $ b $ x $ y $ z $ m $;
return;
datalines;
AA 21 22 23 24 25
AB 26 27 28 29 30
;
run;

First is output on my query and second table i want .

Re: proc report

PaigeMiller — Tue, 20 Sep 2022 11:18:06 GMT

Explain how the original data is converted to this report. Don't make us guess. You know the logic used, tell us.

Re: proc report

Daily1 — Tue, 20 Sep 2022 11:33:30 GMT

i want append two proc report

data three;
	infile datalines;
	input a $ b $ x $ y $ z $ m $;
return;
datalines;
AA 21 22 23 24 25
AB 26 27 28 29 30
;
run;

data have;
 set three;
 group='color1';
 group1='color2';
run;

proc report data=have ;
column group ('red' a) ('blue' b) ('green' x) ('black' y);
define group /group noprint;
Compute before group;
Line @1 group $50.;
endcomp;
run;

proc report data=have ;
column group1 ('red' a) ('blue' b) ('green' z) ('black' m);
define group1 /group noprint;
Compute before group1;
Line @1 group1 $50.;
endcomp;
run;

Re: proc report

PaigeMiller — Tue, 20 Sep 2022 11:59:28 GMT

ods excel file='test.xlsx' options(sheet_interval='NONE');
proc report data=have ;
column group ('red' a) ('blue' b) ('green' x) ('black' y);
define group /group noprint;
Compute before group;
Line @1 group $50.;
endcomp;
run;

proc report data=have ;
column group1 ('red' a) ('blue' b) ('green' z) ('black' m);
define group1 /group noprint;
Compute before group1;
Line @1 group1 $50.;
endcomp;
run;
ods excel close;

Re: proc report

Ksharp — Tue, 20 Sep 2022 11:59:29 GMT

I think you need re-organize your data .

It is impossible to get job done in one report.

Maybe @Cynthia_sas know something.

data three;
	infile datalines;
	input a $ b $ x $ y $ z $ m $;
return;
datalines;
AA 21 22 23 24 25
AB 26 27 28 29 30
;
run;

ods excel file='c:\temp\temp.xlsx' options(sheet_interval='none');
proc report data=three nowd;
define a/display;
define b/display id;
define z/display page;
run;
ods excel close;

Re: proc report

Cynthia_sas — Tue, 20 Sep 2022 22:32:46 GMT

Hi:

Rather than running 2 PROC REPORTS, my tendency would be to create 1 table from the original WORK.THREE dataset, as shown below:

Of course I'm not sure I understand the original data anyway or why red and blue are the same for both sections but green and black are different. But anyway, this is my take on it.

cynthia