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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!