topic Re: Count Values in SAS Programming

Count Values

AP101 — Fri, 12 Oct 2018 18:55:27 GMT

How do I count the number of times the value A or T appears for each record. I want to enter the count into either column TSA_Count_A or TSA_Count_T as applicable?

ID	TSA_1	TSA_2	TSA_3	TSA_4	TSA_COUNT_ A	TSA_COUNT_T
123	A	T	A	T
456	T	T	N	A
789	T	N	A	T

Re: Count Values

novinosrin — Fri, 12 Oct 2018 19:02:18 GMT

data have;
infile cards truncover;
input (ID	T1-T4) ($);
cards;
123	A	T	A	T
456	T	T	N	A
789	T	N	A	T
;

data want;
set have;
TSA_COUNT_A=countc(cats(of t1-t4),'A');
TSA_COUNT_T=countc(cats(of t1-t4),'T');
run;

Re: Count Values

AP101 — Fri, 12 Oct 2018 19:23:53 GMT

Thank you!

I created an array and it worked.

ARRAY TSA_RESULT {4} TSA_1-TSA_4;

TSA_COUNT_A = COUNTC(CATS(OF TSA_1-TSA_4), 'A');

TSA_COUNT_T = COUNTC(CATS(OF TSA_1-TSA_4), 'T');

Re: Count Values

Tom — Fri, 12 Oct 2018 20:18:35 GMT

@AP101 wrote:

Thank you!

I created an array and it worked.

ARRAY TSA_RESULT {4} TSA_1-TSA_4;

TSA_COUNT_A = COUNTC(CATS(OF TSA_1-TSA_4), 'A');

TSA_COUNT_T = COUNTC(CATS(OF TSA_1-TSA_4), 'T');

Adding the array statement shouldn't have made any difference.

The only case I think were is would make a difference is if the input dataset had only some of the variables.

Then the ARRAY statement will insure that the added variables are of the same type as those that were present.

Re: Count Values

AP101 — Fri, 12 Oct 2018 20:26:01 GMT

That's good to know. I thought I had to add it for the 1-4. I ran it without and still the same. Thanks!