Exercise_Week5

Exercise_Week5 - MATH2871 DATA MANAGEMENT FOR STATISTICAL...

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

View Full Document Right Arrow Icon
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
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

Exercise_Week5 - MATH2871 DATA MANAGEMENT FOR STATISTICAL...

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