skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

using SAS,using SAS,using SAS,2 parts, using SAS,1. Using Formatted InputThe raw data file sales1.dat has employee information for the Australian and U.S. sales staff.The record layout is shown in the table below.Layout for sales1.datFieldDescriptionStartingColumnLength ofFieldData TypeEmployee ID16NumericFirst Name812CharacterLast Name2118CharacterGender401CharacterJob Title4320CharacterSalary648Numeric$100,000Country732Character’AU’ or ‘US’Birth Date7610Numericmm/dd/yyyyHire Date8710Numericmm/dd/yyyya. Create a new SAS data set named sales_staff that contains the fields indicated by arrows in thelayout table.b. Print sales_staff and add an appropriate title.Partial PROC PRINT Output (165 Total Observations)Australian and US Sales Staff Employee_ Hire_ ID Last_Name Job_Title Salary Date 120102 Zhou Sales Manager 108255 12205 120103 Dawes Sales Manager 87975 6575 120121 Elvish Sales Rep. II 26600 6575 120122 Ngan Sales Rep. II 27475 8217 120123 Hotstone Sales Rep. I 26190 189012. Reading Multiple Input Records per ObservationThe raw data file sales2.dat has employee information for the Australian and U.S. sales staff.Information for each employee is in three lines of raw data.The record layouts are shown below.Line 1 layoutFieldDescriptionStartingColumnLength ofFieldData Type Employee ID16NumericFirst Name812CharacterLast Name2118CharacterLine 2 layoutFieldDescriptionStartingColumnLength ofFieldData Type Job Title120CharacterHire Date2210Numericmm/dd/yyyySalary338Numericfor example, $100,000Line 3 layoutFieldDescriptionStartingColumnLength ofFieldData Type Gender11CharacterBirth Date310Numericmm/dd/yyyyCountry142Charactera. 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.Partial PROC PRINT Output (165 Total Observations) Australian and US Sales Staff Employee_ Hire_ ID Last_Name Job_Title Date Salary 120102 Zhou Sales Manager 12205 108255 120103 Dawes Sales Manager 6575 87975 120121 Elvish Sales Rep. II 6575 26600 120122 Ngan Sales Rep. II 8217 27475 120123 Hotstone Sales Rep. I 18901 26190

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don't hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®

Back To Top