topic Re: variable= sum down a column in SAS Programming

variable= sum down a column

jmmedina25 — Thu, 01 Aug 2019 19:47:14 GMT

Hi! I'd like a variable that is just the sum of all 1's in a given column.

both are numeric variables

example:

given want

1 4

0 4

1 4

0 4

Re: variable= sum down a column

Reeza — Thu, 01 Aug 2019 19:49:01 GMT

PROC MEANS

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas

There are lots of ways, choose of which to use, usually depends on what you plan to do next.

@jmmedina25 wrote:

Hi! I'd like a variable that is just the sum of all 1's in a given column.

both are numeric variables

example:

given want

1 4

0 4

1 4

1 4

1 4

0 4

0 4

Re: variable= sum down a column

novinosrin — Thu, 01 Aug 2019 21:15:11 GMT

Hello @jmmedina25 Enjoy remerge


data have;
input given ;*  want;
cards;
1          4
0          4
1          4
1          4
1          4
0          4
0          4
;

proc sql;
create table want as 
select *,sum(given) as want
from have;
quit;

proc sql;
create table want as
select *,sum(given=1) as want
from have;
quit;

Re: variable= sum down a column

novinosrin — Thu, 01 Aug 2019 21:12:05 GMT

The above is the same as

proc sql;
create table want as
select *
from have a,(select sum(given) as want from have);
quit;

data want;
do until(lr);
set have end=lr;
sum+given;
end;
lr=0;
do until(lr);
set have end=lr;
output;
end;
run;