Not applicable
Posts: 0

# Sum

i have a dataset

data x;
input id tot;
cards;
5 1
6 2
7 .
5 1
6 2
9 .

Now i want a new variable i want the sum of id having 1 and 2
Super Contributor
Posts: 273

## Re: Sum

This kind of problem looks like homework.

about the "retain" statement to understand the first step which is calculating your results

http://support.sas.com/onlinedoc/913/getDoc/fr/lrdict.hlp/a000214163.htm

the second datastep is showing you that the result are in the table on the last observation
but understanding this step is not trivial and need a 'sum' of practice.

Andre

[pre]
data x;
infile cards ;
input id tot; retain one two 0;
if tot=1 then one+id;
if tot=2 then two+id;
cards;
5 1
6 2
7 .
5 1
6 2
9 .
run;
data _null_;
set x nobs=l point=l;
put one= two= ;
stop;
run;
[/pre]
Not applicable
Posts: 0

## Re: Sum

PROC SQL;
create table y as
select sum(id) as sum_id
from x
where tot =1 or tot = 2;
QUIT;

OR

PROC SQL;
create table y as
select sum(id) as sum_id, tot
from x
where tot =1 or tot = 2
group by tot;
QUIT;
Discussion stats
• 2 replies
• 140 views
• 0 likes
• 2 in conversation