Sentry Page Protection
Coding Project I (2 hours)
Cont.
Task II: Data Set Reconciliation
The four data sets are provided by the four pharmacist inspectors in different geographic areas:
Although each data set captures the essential information about the inspection results, the data sets are in vastly different formats.
In order for you to analyze the inspection results, you must first perform data set reconciliation and combine them into one data set.
Combine the data sets. The Final data set should contain the following variables:
Please make sure:
Purpose of the project
In practice, data generally come from many different sources. The abilities to read in, transform and combine data sets are crucial in handling the day-to-day SAS programming tasks.
Cont.
Task II: Data Set Reconciliation
The four data sets are provided by the four pharmacist inspectors in different geographic areas:
- NY: North York
- TO: Toronto
- RH: Richmond Hill
- SC: Scarborough
Although each data set captures the essential information about the inspection results, the data sets are in vastly different formats.
In order for you to analyze the inspection results, you must first perform data set reconciliation and combine them into one data set.
Combine the data sets. The Final data set should contain the following variables:
- Form
- Compliance
- Year
- Pharno
- City
- Visitdate
- Level
- Concl
Please make sure:
- There should be only 8 variables in the data set.
- Sufficient length is assigned to each variable so that no truncation is found from the data set
- Proper formatting should be done on the following variables: Visitdate, Level, and Concl.
Purpose of the project
In practice, data generally come from many different sources. The abilities to read in, transform and combine data sets are crucial in handling the day-to-day SAS programming tasks.
Submit your program below:
Fill out my online form.