Hi,
I have the following table:
col1 | dis1 | dis2 | dis3 | DIS | VisCode | Vis | InCode | In |
1 | ||||||||
2 | 3 | Y | 2 | Y | ||||
3 | 6 | Y | ||||||
4 | 5 | Y | ||||||
5 | 5 | Y | ||||||
6 | ||||||||
7 | 7 | Y |
I want to write a code to return number of "Y"s for each column.
For example the output should be something like this:
DIS:3
Vis:1
In:2
I would appreciate your help.
best regards,
Nazanin
Proc sql;
create table want as
select sum(DIS='Y') as dis_y, sum(vis='Y') as vis_y, sum(in='Y') as in_y
from have;
quit;
Proc sql;
create table want as
select sum(DIS='Y') as dis_y, sum(vis='Y') as vis_y, sum(in='Y') as in_y
from have;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.