topic Re: Sum a all the 1 in a variable according to the ID separated with different numbers in SAS Programming

Sum all the 1 in a variable which are separated with different numbers by ID

tSAS1 — Tue, 02 Mar 2021 19:03:59 GMT

Hello everyone,
 
I have a database like that :
ID
flag
A
1
A
1
A
1
A
1
A
21
A
1
A
1
B
1
B
1
B
7
B
1
B
1
B
1
B
30
B
1
B
1
B
1
B
1
B
1
 
 and I want to sum all the 1 values of flag variable separated with different numbers it to this form:
 

Re: Sum a all the 1 in a variable according to the ID separated with different numbers

data_null__ — Tue, 02 Mar 2021 14:41:52 GMT

Your data is a picture. Make it TEXT.

data test;
   input id y;
   cards;
1 1
1 1
1 2
1 1
1 1
1 1
1 3
1 1
2 1
2 2
2 1
2 1
2 1
2 3
2 1
;;;;
proc summary data=test nway missing;
   by id y notsorted;
   output out=test2(where=(y eq 1)) sum(y)=sumY;
   run;
proc print;
   run;

Re: Sum a all the 1 in a variable according to the ID separated with different numbers

tSAS1 — Tue, 02 Mar 2021 15:48:03 GMT

Thank you
The code works successfully