topic Re: proc report summary of columns in SAS Procedures

proc report summary of columns

Rakeon — Sat, 25 Oct 2014 09:54:09 GMT

Hi everyone,

I'm not able to make a summary of columns with proc report (or I can't find the sintax of code sas to make a summry of colomuns) .

for example, I have this data set:

SEX COD VAL1 VAL2

M 1 12 2

F 3 14 2

M 2 12 3

and I would like to create a report like this:

SEX COD VAL1 VAL2 VAL1+VAL2

M 1 12 2 14

2 12 3 15

F 3 14 2 16

is there one way in proc report to summarize the column?

Re: proc report summary of columns

mohamed_zaki — Sat, 25 Oct 2014 10:20:07 GMT

Look to me just restructure not summary

data have;

input SEX $ COD VAL1 VAL2;

cards;

M 1 12 2

F 3 14 2

M 2 12 3

;

run;

proc sort data=have;

by descending sex Cod;

run;

data want ;

set have;

by descending Sex;

if ~(first.Sex) then Sex="";

TOT=VAL1+VAL2;

run;

Re: proc report summary of columns

Ksharp — Sat, 25 Oct 2014 12:39:34 GMT

Sure . Easy for proc report.

data have;
input SEX $ COD  VAL1  VAL2     ;
cards;
M     1          12         2
F     3           14         2
M     2          12         3
;
run;
proc report data=have nowd out=x;
column sex cod VAL1 VAL2 var1_var2;
define sex/group;
define cod/display;
define VAL1/display;
define VAL2/display;

compute var1_var2;
var1_var2=sum(VAL1,VAL2);
endcomp;
run;

Xia Keshan

Re: proc report summary of columns

Rakeon — Sat, 25 Oct 2014 13:04:31 GMT

Thank you!!