How to compute a Cell for Excel output using the PROC REPORT

SASuserlot — Tue, 27 Jun 2023 21:11:35 GMT

I have the data that need to be output in Excel format, I am having difficulty how I can create a spanning extra cell like shown in the image. Thank you

data have;
input student age math1 math2 sci1 sci2;
cards;
01 10 36 34 54 45
02 12 34 43 45 56 
03 12 34 43 45 56 
04 16 34 43 15 46 
05 15 34 47 75 56 
06 12 34 43 35 76 
07 15 33 43 25 66 
08 14 34 43 55 56 
09 12 38 41 45 54 

;
run; 

ods listing close;
ods ESCAPECHAR = '^';
ods excel file="\desktop\est1.xlsx" 
options(sheet_name='LIFE Version'
  autofilter='all' ) style= SeasidePrinter   ;

/*BASELINE VERSION -LIFETIME*/

PROC REPORT data=have nowindows
					      style(report)=[font=("Times New Roman", 10pt) protectspecialchars=on]
					      style(header)=[font=("Times New Roman", 10pt, bold) backgroundcolor= yellow just=center protectspecialchars=on]
					      style(column)=[font=("Times New Roman", 10pt) protectspecialchars=on];
 *where cond2='Y';

      COLUMN    student age math1 math2 sci1 sci2;

      DEFINE student	/ "student" display style=[just=c vjust=t cellwidth=2.882cm /*tagattr='type:num format:Text'*/];
      DEFINE age 		/"Age" display style=[just=c vjust=t cellwidth=1.5cm /*tagattr='type:num format:Text'*/];
	  DEFINE math1		/ "Maths 1" display style=[just=c vjust=t cellwidth=1.882cm tagattr='type:num '];
      DEFINE math2 		/"Maths 2" display style=[just=c vjust=t cellwidth=2.5cm /*tagattr='type:num format:Text'*/];
      DEFINE sci1 		/"Science 1" display style=[just=c vjust=t cellwidth= 2 cm /*tagattr='type:num format:Text'*/];
      DEFINE sci2 		/"Science 2" display style=[just=c vjust=t cellwidth= 2 cm /*tagattr='type:num format:Text'*/];

run;

ods excel close;
ods listing close;

How I have

How I want

Re: How to compute a Cell for Excel output using the PROC REPORT

Reeza — Tue, 27 Jun 2023 22:00:44 GMT

This gets you closer:

  COLUMN    student age ('Maths Total' math1 math2) ('Science Total' sci1 sci2);

Re: How to compute a Cell for Excel output using the PROC REPORT

SASuserlot — Fri, 30 Jun 2023 13:57:09 GMT

It worked, Thanks

topic Re: How to compute a Cell for Excel output using the PROC REPORT in SAS Programming

How to compute a Cell for Excel output using the PROC REPORT

Re: How to compute a Cell for Excel output using the PROC REPORT

Re: How to compute a Cell for Excel output using the PROC REPORT