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)

Background

The practice of pharmacists is heavily regulated in Ontario.

​Each year, independent inspection is performed on each of the pharmacists to ensure full compliance to the pharmacists standard.

There are 4 levels of inspection and 5 conclusions that can be made from each inspection.  

Levels 
  • Level 0
    Opening inspection

  • Level I
    Call back, regular practice review, acquisition or relocation

  • Level II
    Re-inspection ordered by inspector
    ​
  • Level III (and above)
    Inspections ordered by the Accreditation Committee 

Conclusions 
  • Satisfactory
    Inspection concluded

  • Issues identified
    Action plan required, inspection not concluded

  • Re-inspection ordered
    Action plan required, inspection not concluded

  • Referral to Accreditation Committee
    Action plan required, Committee decision

  • Report to Accreditation Committee
    Action plan required, Committee decision 

For more details about the inspection, visit the link below: 

http://www.ocpinfo.com/protecting-the-public/inspections/  

​
Task I: Reading in the data

You are given 4 data sets that contain the information about:
  • The pharmacists being inspected
  • The date of inspection
  • The level of inspection and
  • The inspection conclusions. 

Download the four data sets and read them into your SAS Studio.​
ny.sas7bdat
File Size: 655 kb
File Type: sas7bdat
Download File

rh.sas7bdat
File Size: 1245 kb
File Type: sas7bdat
Download File

sc.sas7bdat
File Size: 655 kb
File Type: sas7bdat
Download File

to.sas7bdat
File Size: 1835 kb
File Type: sas7bdat
Download File

​Alternatively, download and copy the code from the text file below and run it on SAS Studio.
data_manipulation_creation_1.txt
File Size: 2992 kb
File Type: txt
Download File

Note: the code is fairly long and the code does take more than a few seconds to run.

Ensure you have the four data sets below in your SAS Studio:
  • NY
  • TO
  • SC
  • RH

(Yes, they are fairly large)
Next
Already a member? Go to member's area.