Question: three datasets are provided containing sample patient data. The first dataset contains, by record/row, the information of each patient encounters of interests; the second dataset

three datasets are provided containing sample patient data. The first dataset contains, by record/row, the information of each patient encounters of interests; the second dataset contains the diagnoses by encounter of each patient; and the third dataset contains the procedures by encounter of each patient. Please write out (either in SQL or SAS) a program using these tables to create a new dataset that only contains patient encounters with discharge dates in July 2019 and having a coded diagnosis code of K50.0. Please only include the following fields in your final output MRN ENCOUNTER_NUMBER ADMIT_DATE DISCHARGE_DATE ICD_PROC_CODE (rename from PROCEDURES.ICD_CODE) ICD_PROC_SEQ (rename from PROCEDURES.ICD_LINE) NPI SURGEON_NAME (rename from PROCEDURES.PROV_NAME)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
