hw4 - STAT 506Homework 4 For most problems you will still...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
STAT 506—Homework 4 For most problems you will still need to access the data in the PRG1 folder. Use the libname statement we learned to load this each time you work on your assignments calling the library ‘orion’. I tried to bold the parts where I expect you to actually show me something in your homework solutions if it is not obvious. Do the following problems. 1. Validating orion.shoes_tracker with the PRINT and FREQ Procedures a. Retrieve the starter program p108e01. b. The data in orion.shoes_tracker should meet the following requirements: Product_Category must not be missing. Supplier_Country must have a value of GB or US . Add a WHERE statement to the PROC PRINT step to find any observations that do not meet the above requirements. c. Add a VAR statement to create the following PROC PRINT report: Product_ Supplier_ Obs Category Supplier_Name Country Supplier_ID 1 Shoes 3Top Sports us . 2 3Top Sports US 2963 5 Shoes 3Top Sports UT 2963 10 Shoes Greenline Sports Ltd gB 14682 Give the #s for the observation(s) that have missing Product_Category ? ___________________________ Give the #s for the observation(s) that have invalid values of Supplier_Country ? ___________________ Show your completed proc print step. d. Add a PROC FREQ step with a TABLES statement to create frequency tables for Supplier_Name and Supplier_ID of orion.shoes_tracker . Include the NLEVELS option. The data in orion.shoes_tracker should meet the following requirements: Supplier_Name must be 3Top Sports or Greenline Sports Ltd . Supplier_ID must be 2963 or 14682 . What invalid data exist for Supplier_Name and Supplier_ID ? ______________________ Show your completed proc freq step. 2.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

hw4 - STAT 506Homework 4 For most problems you will still...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online