I am trying to find the “number and percentage of distribution of encounter with at least one medication record by data source”. This is my sample data and my sql code but I am not convinced, any help/suggestion please, Thanks. Source Hosp_id Encounter_id Medication_code Medication_name ccd 1123 3014759650x 1234 aspirin ccd 1123 3014759650x 5678 ibuprofen ehr 1123 3014751234x 9876 Tylenol ehr 1222 3014751234x 1234 aspirin ehr 1222 3014751234x 9876 Tylenol For my code, I said medi_name =1, when medication_name is present, else medi_name=0 medi_code =1, when medication_code is present, else medi_code=0. proc sql; create table tm.testrun as select source, count(source)as s_sum, encounter_id, count(encounter_id)as e_sum from Tm.med where medi_name = 1 and medi_code =1; quit; proc freq data= Tm.testrun; tables source; run;
... View more