topic Re: Counting the number of occurrence of a variable in an observation in SAS Studio

Counting the number of occurrence of a variable in an observation

jsheu — Wed, 19 Jul 2017 19:09:34 GMT

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:

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!!

Re: Counting the number of occurrence of a variable in an observation

art297 — Wed, 19 Jul 2017 19:14:08 GMT

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

Art, CEO, AnalystFinder.com

Re: Counting the number of occurrence of a variable in an observation

kiranv_ — Wed, 19 Jul 2017 19:20:46 GMT

this should work

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

Re: Counting the number of occurrence of a variable in an observation

Astounding — Wed, 19 Jul 2017 20:26:49 GMT

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.

Re: Counting the number of occurrence of a variable in an observation

jsheu — Sun, 23 Jul 2017 23:47:47 GMT

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