Count function in dataset

NazaninSAS — Fri, 03 Aug 2018 15:18:33 GMT

Hi,

I have the following table:

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

Re: Count function in dataset

novinosrin — Fri, 03 Aug 2018 15:28:17 GMT

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;