Sum of numeric fields along row

[Ronein]

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?

[Ronein]

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.

[novinosrin · Accepted solution]

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;

[ballardw]

---

@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.

[andreas_lds]

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.

[ballardw]

---

@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.