topic Re: Sum of numeric fields along row in SAS Programming

Sum of numeric fields along row

Ronein — Tue, 31 Jul 2018 21:12:43 GMT

Hello
I want to calculate all numeric vars along a row.
Is there a way to tell sas to calculate in each row(observation)
Sum of all numeric values?

Re: Sum of numeric fields along row

Ronein — Tue, 31 Jul 2018 21:16:03 GMT

The issue is that I have a dynamic program that run every month.
Number of fields are increasing every month.
So actually i want to calculate sum along row with non fix number of fields.

Re: Sum of numeric fields along row

novinosrin — Tue, 31 Jul 2018 21:20:06 GMT

data have;
input var1 var2 var3;
cards;
1 2 3
4 5 6
7 8 9
;
data want;
set have;
sum=sum(of _numeric_);
run;

you mean this?

data want;

set have;

sum=sum(of _numeric_);

run;

Re: Sum of numeric fields along row

ballardw — Tue, 31 Jul 2018 21:38:47 GMT

@Ronein wrote:
The issue is that I have a dynamic program that run every month.
Number of fields are increasing every month.
So actually i want to calculate sum along row with non fix number of fields.

That means your data model is wrong. As I believe has been mentioned a time or two.

Re: Sum of numeric fields along row

andreas_lds — Wed, 01 Aug 2018 05:52:20 GMT

If you can't use _numeric_ as suggested by @novinosrin - because you have numeric vars that should not be part of the calculation - then all variables need a common prefix, so that you can use

sum = sum(of prefix:)

But fixing the data-structure as recommended by @ballardw is the best way to solve the issue.

Re: Sum of numeric fields along row

ballardw — Wed, 01 Aug 2018 15:25:02 GMT

@andreas_lds wrote:

If you can't use _numeric_ as suggested by @novinosrin - because you have numeric vars that should not be part of the calculation - then all variables need a common prefix, so that you can use
sum = sum(of prefix:)
.

But fixing the data-structure as recommended by @ballardw is the best way to solve the issue.

or if you have several "prefixes"

sum = sum( of prefix: , of other: , of different: );

or if all of the variables of interest are sequential in column order

sum = sum( firstvar -- lastvar); There are two - in case your browser makes it hard to read.

But for stuff like this providing an example layout of your data and indicating which variables you wanted to sum does not seem unrealistic to ask.