topic Re: Summarizing Data in Multiple Columns in SAS Programming

Summarizing Data in Multiple Columns

dali74 — Wed, 15 Nov 2017 13:21:23 GMT

is it possible to create a dataset with sum in multiple columns?

With datat statement

Var1 var2 ..................... varn

1 10 20

4 10 20

6 10 20

10 10 20

totalvar1=21

totalvar2=40

totalvar2=80

Re: Summarizing Data in Multiple Columns

Reeza — Tue, 14 Nov 2017 23:27:59 GMT

@dali74 wrote:

is it possible to create a dataset with sum in multiple columns?

Yes. Your math appears incorrect or is it bad sample data?

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic

Re: Summarizing Data in Multiple Columns

ballardw — Tue, 14 Nov 2017 23:29:52 GMT

Do you want the total to manipulate in another procedure for some reason? Or do you want to create a report with a sum total row?

Generally putting a total in the data leads to a number of potential problems if the data is used for input into other procedures.

Re: Summarizing Data in Multiple Columns

novinosrin — Tue, 14 Nov 2017 23:34:07 GMT

data have;
input v1-v3;
datalines;
1          10                        20
 4          10                        20
6          10                        20
 10          10                        20
 ;
 
 
proc means data= have;
var v1-v3 ;
output out=want(drop=_: ) sum=;
run;

Note: Edited by @Reeza to remove emojis from code.

Re: Summarizing Data in Multiple Columns

dali74 — Wed, 15 Nov 2017 13:27:16 GMT

Sorry! but i put with data statement. I know i can do it with proc means.