BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11

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

1 REPLY 1
Jagadishkatam
Amethyst | Level 16
try the proc sql

proc sql;
create table test as select a.*, b.ns,c.ns2 from have as a left join (select distinct count(distinct id) as ns,flag from have where flag ne '' group by flag) as b on a.flag=b.flag left join
(select distinct count(distinct id) as ns2,aflag from have where aflag ne '' group by aflag) as c on a.aflag=c.aflag order by a.id;
quit;
Thanks,
Jag

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 716 views
  • 0 likes
  • 2 in conversation