mconover, I also work in the health care industry (health insurance) and frequently have to run reports populated by summarized data similar to what you are trying to do here. However, I only use Enterprise Guide and the query builder tool as I am not yet very familiar with the SAS code syntax (I am a programmer at heart but haven't learned the SAS ropes yet). I think that the code Tom posted should work just fine, but if you are interested in building this utilizing the EG query builder consider using a case statement to populated a calculated column: CASE WHEN t1.surgindx LIKE '162' OR LIKE '2312' THEN 1 ELSE 0 END Once you create this calculated column drag it into the selected column area in the query builder and SUM the field. The output should be a count of every claim that is related to cancer. If you do not sum the calculated column then the output will just be a list of flags (also useful sometimes depending on your situation). I hope this helps!
... View more