Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Sentry Page Protection
Please Wait...
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:
  • 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: 
  1. There should be only 8 variables in the data set. 
  2. Sufficient length is assigned to each variable so that no truncation is found from the data set 
  3. 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.
Already a member? Go to member's area.