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.

Topics about : Reading Raw Data Files; Data Transformaton Part Isee the file for detail.Part I: Reading Raw Data Files1. Using Formatted Input and the Subsetting IF StatementThe 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 Type Employee ID16NumericFirst Name812CharacterLast Name2118CharacterGender401CharacterJob Title4320CharacterSalary648Numeric$100,000Country732Character’AU’ or ‘US’Birth Date7610Numericmm/dd/yyyyHire Date8710Numericmm/dd/yyyya. Create two SAS data sets from the raw data file, and base them on the country of the trainee. Name the data sets US_trainees and AU_trainees. For this exercise, a trainee is anyone that has the job title of Sales Rep. IEach data set should contain the fields indicated by arrows in the layout table.Write only U.S. trainees to the US_trainees data set and only Australian trainees to the AU_trainees data set. Do not keep the Country variable in the output data sets.b. Print both of the data sets with appropriate titles.Partial work.AU_trainees (21 Total Observations) Australian Trainees Employee_ Hire_ ID Last_Name Job_Title Salary Date 120123 Hotstone Sales Rep. I 26190 18901 120124 Daymond Sales Rep. I 26480 18687 120130 Lyon Sales Rep. I 26955 18748 120131 Surawski Sales Rep. I 26910 18628 120136 Leyden Sales Rep. I 26605 18659Partial work.US_trainees (42 Total Observations)US Trainees Employee_ Hire_ ID Last_Name Job_Title Salary Date 121023 Fuller Sales Rep. I 26010 18748 121028 Smades Sales Rep. I 26585 18932 121029 Mcelwee Sales Rep. I 27225 18962 121030 Areu Sales Rep. I 26745 18659 121036 Mesley Sales Rep. I 25965 189012. Working with Mixed Record TypesThe raw data file sales3.dat has employee information for the Australian and U.S. sales staff.Information for each employee is in two lines of raw data.The record layouts are shown below.Line 1 layoutFieldDescriptionStartingColumnLength ofFieldData Type Employee ID16NumericFirst Name812CharacterLast Name2118CharacterGender401CharacterJob Title4320CharacterLine 2 layout for Australian employeesFieldDescriptionStartingColumnLength ofFieldData Type Salary18Numeric$100.000Country102CharacterBirth Date1310Numericdd/mm/yyyyHire Date2410Numericdd/mm/yyyyLine 2 layout for U.S. employeesFieldDescriptionStarting ColumnLength ofFieldData Type Salary18Numeric$100,000Country102CharacterBirth Date1310Numericmm/dd/yyyyHire Date2410Numericmm/dd/yyyya. Create two new SAS data sets, US_sales and AU_sales, that contain the fields indicatedby arrows in the layout table. Write only U.S. employees to the US_sales data set and only Australian employees to the AU_sales data set. Do not include the Country variable inthe output data sets. The salary and hire date values are different for Australian and U.S. employees.Be sure to use the correct informats in each INPUT statement.b. Print both of the data sets with appropriate titles.Partial work. AU_sales (63 Total Observations) Australian 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 18901 120124 Daymond Sales Rep. I 26480 18687 120125 Hofmeister Sales Rep. IV 32040 8460Partial work. US_sales (102 Total Observations)US Sales Staff Employee_ Hire_ ID Last_Name Job_Title Salary Date 120261 Highpoint Chief Sales Officer 243190 11535 121018 Magolan Sales Rep. II 27560 6575 121019 Desanctis Sales Rep. IV 31320 17684 121020 Ridley Sales Rep. IV 31750 16922 121021 Farren Sales Rep. IV 32985 13939 121022 Stevens Sales Rep. IV 32210 16833 121023 Fuller Sales Rep. I 26010 18748 121024 Westlund Sales Rep. II 26600 17653

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®