topic Re: How to quick check how many YES in the tables. in SAS Procedures

How to quick check how many YES in the tables.

lovedieer — Fri, 05 Dec 2014 20:32:55 GMT

I have a table with 20 column as flags, their value are Y or N, I want to check how many Y for each records, beside change all Y to 1 and N to 0 and then do the sum, is there any quick way to do sum or count how many Y for each record?

Thanks,

Re: How to quick check how many YES in the tables.

stat_sas — Fri, 05 Dec 2014 20:51:35 GMT

data want;

set have;

array q{*} q1-q20;

array q_num{20};

cnt_Y=0;

do i=1 to dim(q);

if q{i}='Y' then q_num{i}=1;

else q_num{i}=0;

end;

do i=1 to dim(q);

if q{i}='Y' then cnt_Y+1;

end;

run;

Re: How to quick check how many YES in the tables.

lovedieer — Fri, 05 Dec 2014 21:08:12 GMT

Thanks. that works well.

Re: How to quick check how many YES in the tables.

art297 — Fri, 05 Dec 2014 21:40:02 GMT

Here is a way that takes a bit less code:

data have;

input (x1-x7 y1-y7 z1-z6) ($);

cards;

Y N Y N Y N Y N Y N Y N Y N Y N Y N Y N

N N N Y Y N N N Y Y N N N N N N N N N N

;

data want;

set have;

total=countc(catt(of x1--z6),'Y');

run;

Re: How to quick check how many YES in the tables.

lovedieer — Fri, 05 Dec 2014 22:17:52 GMT

Cool!. that's easy.