Dear,
I am trying to calculate number of subjects based on different conditions.
Some one helped me with code with one condition. I need to count number of subjects by several variables eg: where (aflag='Y'). How to code to get the output which includes all OBS in one proc statement . Thank you
Code:
proc sql;
create table one as
select *, (select count(distinct id) from data1 where flag="Y") as NS
from data1;
quit;
Data1
id flag AFlag
1 Y
1 Y
1 Y
2 Y Y
2 Y
3
4
5 Y
6 Y
7 Y Y
output expected:
Data2
id flag NS NS2
1 Y 4
1 Y 4
1 Y 4
2 Y 4 3
2 Y 4 3
3
4
5 Y 4
6 3
7 Y 4 3
output getting
Data1
id flag NS
1 Y 4
1 Y 4
1 Y 4
2 Y 4
2 Y 4
5 Y 4
7 Y 4
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.