A research analyst has two datasets both containing a unique identifier “patient_number”: Survey which contains a patient’s initial interview responses as one row per patient and Demographics which contains information on all patients including date of birth, gender, address, etc. What is a SAS or SQL code you would use to create a new data set containing all of the patients and information in Survey but adding their gender from Demographics.
... View more