topic Re: alternative to "sum" function e.g. arrays?? in SAS Programming

alternative to "sum" function e.g. arrays??

progster — Thu, 10 Oct 2013 16:48:32 GMT

hi all!

i have to sum 100 variables, i would like to do it without writing all the names sum(var1,var2,var3, etc)

any good code, may be arrays?

Reeza — Thu, 10 Oct 2013 16:51:07 GMT

More details.

Are you summing across a row, or column totals? Do the variables have any naming conventions? Are they side by side at least?

progster — Thu, 10 Oct 2013 16:57:55 GMT

I sum columns totals. I previously rename them var1, var2, var3 and they are side by side, thanks!

Reeza — Thu, 10 Oct 2013 17:04:19 GMT

If you need column totals look into proc means and proc summary. Arrays in SAS operate across columns (So sum(var1-var100) would be for each row).

Note the colon after var, then semicolon.

proc means data=have;

var var:;

output out=want1 sum=/autoname;

run;

Or proc means data=have;

var var1-var100;

output out=want2 sum= /autoname;

run;

ballardw — Thu, 10 Oct 2013 21:47:58 GMT

You can use variable lists in sum you name variables with a common stem such as:

total = sum (of var:); to get the total of all variables whose names start with VAR.

If using a numeric suffix as in your example you specify a range:

total = sum (of var1-var100);

You can also mix lists and variable names.