Counting the number of occurrence of a variable in an observation

[jsheu]

I'm on SAS University Edition - I have a data set with 792 rows and 29 columns; each column is a variable with value "0" or "1".  I would like to make a table with 792 rows and a single column, with the value of the single column being the number of "1"s in the corresponding observation.

For example:

varA     varB     varC     varD

1          1           0          1

0          0           0          1

1          1           1          0

1          1           1          1

0          0           0          0

1          0           1          0

output:

3

1

3

4

0

2

Sorry if this is a basic question - I've new to SAS, and have looked around the forums and the internet without finding anything that has worked for me.  Much thanks!!

[art297]

data want (keep=sum);
  set have;
  array vars(*) varA--VarD;
  sum=sum(of vars(*));
run;

Art, CEO, AnalystFinder.com

[kiranv_]

this should work

data want(drop=var:);
 set have;
 finalvar=sum(of var:);
 run;

[Astounding · Accepted solution]

I'm thinking that your real variable names don't all begin with "var".  If you want the sum of all numeric variables, you could use:

data want;

set have;

new_column = sum(of _numeric_);

run;

There's not much point in putting this new column into a separate data set.  Once you do that, if you were to ever sort your data you couldn't match the new column back to the row that it came from.

[jsheu]

Thanks, all! Looks like there a couple of ways to do this - I appreciate the help.