I tested your code and I got the expected result, Thank you! So I have two questions. 1. Can I add another variable to the initial code you answered. I mean if I want to "Number and percent encounters with atleast One Med record by setting_id and source" 2. Can I used the same code to find another variable in the same dataset. See code below. Am looking for "Number and percentage of encounters by "medication_code" and "setting_id". I added medication_code to the code you created but I removed the "distinct" since am not looking for atleast one record. proc sql; create table tm.testrun as select source, setting_id, count(medication_code)as med_sumv, medication_code, encounter_id, count(encounter_id)as e_sum from Tm.med group by medication_code, setting_id having sum(Medication_code ne " ")>0 and sum(Medication_name ne " ")>0; quit; proc freq data= Tm.testrun; tables medication_code*setting_id/crosslist; run;
... View more