Exercise_Week5

# Exercise_Week5 - MATH2871 DATA MANAGEMENT FOR STATISTICAL...

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

MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS SEMESTER 2, 2010 Lab exercise Week5 1. Reading a Comma-Delimited Raw Data File. a. Open p107e01. Add the appropriate LENGTH, INFILE and INPUT statements to read the comma-delimited raw data file named, newemps.csv . Partial Raw Data File b. The following variables should be read into the program data vector: Name Type Length First Character 12 Last Character 18 Title Character 25 Salary Numeric 8 c. Submit the program to create the following PROC PRINT report (First 5 of 71 observations) 2. Reading a Space-Delimited Raw Data File with Spaces in Data Values a. Write a DATA step to create a new data set named Work.us_customers by reading the space-delimited raw data file named, custus.dat. Partial Raw Data File Obs First Last Title Salary 1 Satyakam Denny Sales Rep. II 26780 2 Monica Kletschkus Sales Rep. IV 30890 3 Kevin Lyon Sales Rep. I 26955 4 Petrea Soltau Sales Rep. II 27440 Satyakam,Denny,Sales Rep. II,26780 Monica,Kletschkus,Sales Rep. IV,30890

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 06/12/2011 for the course ASB 1001,2522, taught by Professor Nicole during the One '09 term at University of New South Wales.

### Page1 / 4

Exercise_Week5 - MATH2871 DATA MANAGEMENT FOR STATISTICAL...

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

View Full Document
Ask a homework question - tutors are online