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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.