How many have each kind of test?

[irinnew]

Hi everybody,

I have a file of patients who had many lab tests. However I am just interested in tests “A”, “B”, “C”, “D” and “E”

I need to know how many patients have each kind of test. How can I do it?

Thank you in advance!

Irin

 

[ChrisW75]

proc freq data=mytest(where=(test_type in('A','B','C','D','E')));
  table test_type /missing;
run;

That what you're after?

 

[nirmalraj]

try this just for checking.just a 2 way freq.
proc freq data = mytest; tables patient*test_type /missing ;
where test_type in ('A','B','C','D','E');run;

 

[ChrisW75]

It's more efficient to put the where clause as a datset option than as a statement, it prevents the whole record being read in before the where clause is tested.