topic Re: sum multiple variables in SAS Programming

sum multiple variables

CathyVI — Mon, 13 Mar 2023 18:04:38 GMT

Hello,

I would like to sum my data set and use a proc tabulate to get sum for 1's and 0's.

For example:

data Have;
input A B C D;
datalines;
1 0 1 1
0 1 1 1
1 1 0 0;
run;

I used the code below but its only gives me value when total =1 or 0, not the value of all totals.

data want;
set have;
if a=1 | b=1 |c=1|d=1 then total=1; else total=0;
run;

I would like my output to have total of a,b,c,d when its 1, and when its 0.

For example

Output

Total	N	%
1	8	66.6
0	4	33.4
All	12	100

Re: sum multiple variables

PaigeMiller — Mon, 13 Mar 2023 18:23:51 GMT

Sum rows, or sum columns?

data want;
set have;
if a=1 | b=1 |c=1|d=1 then total=1; else total=0;
run;

This isn't a sum at all.

I shouldn't have to guess or ask. Do you want the total number of 1s and the total number of zeros? You don't say this at all.

Re: sum multiple variables

CathyVI — Mon, 13 Mar 2023 20:09:29 GMT

@PaigeMiller I want the total number of 1s and the total number of zeros. This is what I showed in my output table. The table shows total number of 1's and 0's. This is how I want my output to look like. Thanks

Re: sum multiple variables

Kurt_Bremser — Mon, 13 Mar 2023 20:27:15 GMT

data long;
set have;
array all {*} a--d;
do i 0 1 to dim(all);
  x = all{i};
  output;
end;
keep x;
run;

proc freq data=long;
tables x;
run;

Re: sum multiple variables

CathyVI — Mon, 13 Mar 2023 20:47:24 GMT

@Kurt_Bremser There was an error when i ran your code

61 data long;
62 set have;
63 array all {*} a--d;
64 do i 0 1 to dim(all);
-
73
200
ERROR 73-322: Expecting an =.

ERROR 200-322: The symbol is not recognized and will be ignored.

65 x = all{i};
66 output;
67 end;
68 keep x;
69 run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LONG may be incomplete. When this step was stopped there were 0
observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds

Re: sum multiple variables

Reeza — Mon, 13 Mar 2023 20:49:08 GMT

data Have;
input A B C D;
datalines;
1 0 1 1
0 1 1 1
1 1 0 0
;
run;

data long;
set have;

array vars(4) a b c d;

do i=1 to dim(vars);
   value = vars(i);
   var = vname(vars(i));
   output;
end;


keep var value;
run;

proc freq data=long;
table value;
run;

Transpose your data to a long format
Use PROC FREQ to summarize.

Another method may be to summarize and then collate the summary.

This seemed easier but both work.

@CathyVI wrote:

Hello,

I would like to sum my data set and use a proc tabulate to get sum for 1's and 0's.

For example:

data Have;
input A B C D;
datalines;
1 0 1 1
0 1 1 1
1 1 0 0;
run;

I used the code below but its only gives me value when total =1 or 0, not the value of all totals.

data want;
set have;
if a=1 | b=1 |c=1|d=1 then total=1; else total=0;
run;

I would like my output to have total of a,b,c,d when its 1, and when its 0.

For example

Output

Total N %

1 8 66.6

0 4 33.4

All 12 100

Re: sum multiple variables

Tom — Mon, 13 Mar 2023 21:55:13 GMT

Assuming you meant to read in all three lines of data and not just the two your posted code was reading:

data have;
  input total @@;
datalines;
1 0 1 1
0 1 1 1
1 1 0 0
;

proc freq ;
  tables total;
run;

Result

Re: sum multiple variables

Tom — Mon, 13 Mar 2023 22:13:31 GMT

If you are really stuck with data in that form then you can count them yourself.

data have;
  input v1-v4;
datalines;
1 0 1 1
0 1 1 1
1 1 0 0
;

data want;
  set have end=eof;
  array all _numeric_;
  ones+sum(of all[*]);
  zeros+dim(all)-sum(of all[*]);
  if eof then do;
    total=1; n=ones; p=ones/(ones+zeros); output;
    total=0; n=zeros;  p=zeros/(ones+zeros);output;
  end;
  keep total n p ;
run;

proc print;
 sum n;
run;

Re: sum multiple variables

Kurt_Bremser — Tue, 14 Mar 2023 06:22:26 GMT

That was a typical tablet-typo. The DO needs an equal sign (as the message says):

do i = 1 to dim(all);