Exercise_Week10_Answer - MATH2871 DATA MANAGEMENT FOR...

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

View Full Document Right Arrow Icon
SEMESTER 2, 2010 Lab exercise Week 10 1. Reading Multiple Input Records per Observations The raw data set sales2.dat has employee information for Australian and US sales staff. Information for each employee is in three lines of raw data. The record layouts are shown below. Line 1 layout Field Description Starting Column Length of Field Data Type Employee ID 1 6 Numeric First Name 8 12 Character Last Name 21 18 Character Line 2 layout Field Description Starting Column Length of Field Data Type Job Title 1 20 Character Hire Date 22 10 Numeric mm/dd/yyyy Salary 33 8 Numeric for example, $100,000 Line 3 layout Field Description Starting Column Length of Field Data Type Gender 1 1 Character Birth Date 3 10 Numeric mm/dd/yyyy Country 14 2 Character a. Create a new SAS data set named sales_staff2 that contains the fields indicated by arrows in the layout table. b. Print sales_staff2 and add an appropriate title. PROC PRINT output: Australia and US Sales Staff Employee_ Hire_ ID Last_Name Job_Title Date Salary 120102 Zhou Sales Manager 10744 108255 120103 Dawes Sales Manager 5114 87975 120121 Elvish Sales Rep. II 5114 26600 120122 Ngan Sales Rep. II
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.

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_Week10_Answer - MATH2871 DATA MANAGEMENT FOR...

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