Question: The raw data file sales2.dat has employee information for the Australian and U.S. sales staff. First create code that correctly reads and provides permanent formats
The raw data file sales2.dat has employee information for the Australian and U.S. sales staff. First create code that correctly reads and provides permanent formats for this data. Then create code that make the following edits to this data:
Create the variable Name that is in the form Last Name, First Name.
Create a variable called Service that contains the number of years of service (rounded down or truncated to an integer) as of Jan 1, 2017.
Job_Titles are changing. Any incidence of Rep. should be replaced by Crew. (e.g. Sales Rep. IV will become Sales Crew IV).
For any U.S. employee on any Sales Crew, increase salary by 3% for the new salary. Australian Sales Crew employees should receive a 2% increase. Managers and higher levels of administration should receive no increase.
Finally, print a list of employees and their information, summing over salaries within Job Title. This may require a sort. Be sure to display Name, Job Title, Service Years, and Salary (formatted in dollars) for each employee. Also include an appropriate title for your printout which uses macros to display the current date and time the information was created.

Below's sales2 datas:
| 120102 Tom Zhou | |
| Sales Manager 06/01/1989 $108,255 | |
| M 08/11/1969 AU | |
| 120103 Wilson Dawes | |
| Sales Manager 01/01/1974 $87,975 | |
| M 01/22/1949 AU | |
| 120121 Irenie Elvish | |
| Sales Rep. II 01/01/1974 $26,600 | |
| F 08/02/1944 AU | |
| 120122 Christina Ngan | |
| Sales Rep. II 07/01/1978 $27,475 | |
| F 07/27/1954 AU | |
| 120123 Kimiko Hotstone | |
| Sales Rep. I 10/01/2007 $26,190 | |
| F 09/28/1964 AU | |
| 120124 Lucian Daymond | |
| Sales Rep. I 03/01/2007 $26,480 | |
| M 05/13/1959 AU | |
| 120125 Fong Hofmeister | |
| Sales Rep. IV 03/01/1979 $32,040 | |
| M 12/06/1954 AU | |
| 120126 Satyakam Denny | |
| Sales Rep. II 08/01/2006 $26,780 | |
| M 09/20/1988 AU | |
| 120127 Sharryn Clarkson | |
| Sales Rep. II 11/01/1998 $28,100 | |
| F 01/04/1979 AU | |
| 120128 Monica Kletschkus | |
| Sales Rep. IV 11/01/2006 $30,890 | |
| F 07/14/1986 AU | |
| 120129 Alvin Roebuck | |
| Sales Rep. III 10/01/1985 $30,070 | |
| M 11/22/1964 AU | |
| 120130 Kevin Lyon | |
| Sales Rep. I 05/01/2007 $26,955 | |
| M 12/14/1984 AU | |
| 120131 Marinus Surawski | |
| Sales Rep. I 01/01/2007 $26,910 | |
| M 09/25/1979 AU | |
| 120132 Fancine Kaiser | |
| Sales Rep. III 10/01/1978 $28,525 | |
| F 04/05/1949 AU | |
| 120133 Petrea Soltau | |
| Sales Rep. II 10/01/2006 $27,440 | |
| F 04/22/1986 AU | |
| 120134 Sian Shannan | |
| Sales Rep. II 01/01/1974 $28,015 | |
| M 06/06/1949 AU | |
| 120135 Alexei Platts | |
| Sales Rep. IV 10/01/1997 $32,490 | |
| M 01/26/1969 AU | |
| 120136 Atul Leyden | |
| Sales Rep. I 02/01/2007 $26,605 | |
| M 09/16/1979 AU | |
| 120137 Marina Iyengar | |
| Sales Rep. III 03/01/2006 $29,715 | |
| F 03/12/1979 AU | |
| 120138 Shani Duckett | |
| Sales Rep. I 07/01/2007 $25,795 | |
| F 07/11/1979 AU | |
| 120139 Fang Wilson | |
| Sales Rep. II 09/01/2006 $26,810 | |
| F 08/18/1986 AU | |
| 120140 Michael Minas | |
| Sales Rep. I 10/01/2007 $26,970 | |
| M 08/03/1988 AU | |
| 120141 Amanda Liebman | |
| Sales Rep. II 05/01/2006 $27,465 | |
| F 03/12/1988 AU | |
| 120142 Vincent Eastley | |
| Sales Rep. III 07/01/2006 $29,695 | |
| M 06/14/1986 AU | |
| 120143 Phu Sloey | |
| Sales Rep. II 10/01/1982 $26,790 | |
| M 05/17/1959 AU | |
| 120144 Viney Barbis | |
| Sales Rep. III 10/01/2006 $30,265 | |
| M 03/07/1986 AU | |
| 120145 Sandy Aisbitt | |
| Sales Rep. II 06/01/1985 $26,060 | |
| M 01/22/1964 AU | |
| 120146 Wendall Cederlund | |
| Sales Rep. I 08/01/2007 $25,985 | |
| M 10/02/1959 AU | |
| 120147 Skev Rusli | |
| Sales Rep. II 10/01/2006 $26,580 | |
| F 01/19/1988 AU | |
| 120148 Michael Zubak | |
| Sales Rep. III 06/01/1978 $28,480 | |
| M 09/13/1949 AU | |
| 120149 Judy Chantharasy | |
| Sales Rep. I 01/01/2007 $26,390 | |
| F 11/21/1974 AU | |
| 120150 John Filo | |
| Sales Rep. III 08/01/1982 $29,965 | |
| M 07/09/1954 AU | |
| 120151 Julianna Phaiyakounh | |
| Sales Rep. II 01/01/1974 $26,520 | |
| F 11/21/1944 AU | |
| 120152 Sean Dives | |
| Sales Rep. I 04/01/2007 $26,515 | |
| M 05/01/1979 AU | |
| 120153 Samantha Waal | |
| Sales Rep. I 01/01/2007 $27,260 | |
| F 05/07/1979 AU | |
| 120154 Caterina Hayawardhana | |
| Sales Rep. III 01/01/1974 $30,490 | |
| F 07/20/1944 AU | |
| 120155 Narelle James | |
| Sales Rep. III 04/01/2006 $29,990 | |
| F 04/22/1984 AU | |
| 120156 Gerry Snellings | |
| Sales Rep. I 03/01/2007 $26,445 | |
| F 09/01/1988 AU | |
| 120157 Leonid Karavdic | |
| Sales Rep. II 12/01/2006 $27,860 | |
| M 02/21/1986 AU | |
| 120158 Daniel Pilgrim | |
| Sales Rep. III 07/01/1987 $36,605 | |
| M 07/14/1964 AU | |
| 120159 Lynelle Phoumirath | |
| Sales Rep. IV 07/01/1986 $30,765 | |
| F 02/24/1964 AU | |
| 120160 Chuck Segrave | |
| Sales Rep. I 10/01/2007 $27,115 | |
| M 09/09/1954 AU | |
| 120161 Rosette Martines | |
| Sales Rep. III 10/01/2006 $30,785 | |
| F 03/07/1988 AU | |
| 120162 Randal Scordia | |
| Sales Rep. I 02/01/2007 $27,215 | |
| M 09/05/1988 AU | |
| 120163 Brett Magrath | |
| Sales Rep. II 01/01/1991 $26,735 | |
| M 05/22/1964 AU | |
| 120164 Ranj Stamalis | |
| Sales Rep. II 02/01/1982 $27,450 | |
| F 11/26/1959 AU | |
| 120165 Tadashi Pretorius | |
| Sales Rep. I 03/01/2007 $27,050 | |
| M 03/19/1984 AU | |
| 120166 Fadi Nowd | |
| Sales Rep. IV 01/01/1974 $30,660 | |
| M 06/14/1944 AU | |
| 120167 Kimiko Tilley | |
| Sales Rep. I 02/01/2007 $25,185 | |
| F 05/04/1954 AU | |
| 120168 Selina Barcoe | |
| Sales Rep. I 11/01/2007 $25,275 | |
| F 03/24/1984 AU | |
| 120169 Cos Tannous | |
| Sales Rep. III 05/01/2006 $28,135 | |
| M 01/02/1984 AU | |
| 120170 Alban Kingston | |
| Sales Rep. III 10/01/1992 $28,830 | |
| M 02/25/1974 AU | |
| 120171 Alena Moody | |
| Sales Rep. II 09/01/2006 $26,205 | |
| F 07/19/1984 AU | |
| 120172 Edwin Comber | |
| Sales Rep. III 01/01/1974 $28,345 | |
| M 04/01/1944 AU | |
| 120173 Hernani Osborn | |
| Sales Rep. I 06/01/2007 $26,715 | |
| M 02/23/1954 AU | |
| 120174 Doungkamol Simms | |
| Sales Rep. I 01/01/2007 $26,850 | |
| F 01/10/1944 AU | |
| 120175 Andrew Conolly | |
| Sales Rep. I 10/01/2007 $25,745 | |
| M 08/18/1988 AU | |
| 120176 Koavea Pa | |
| Sales Rep. I 11/01/2007 $26,095 | |
| M 11/09/1986 AU | |
| 120177 Franca Kierce | |
| Sales Rep. III 02/01/1998 $28,745 | |
| F 04/05/1979 AU | |
| 120178 Billy Plested | |
| Sales Rep. II 04/01/1974 $26,165 | |
| M 11/23/1954 AU | |
| 120179 Matsuoka Wills | |
| Sales Rep. III 01/01/2004 $28,510 | |
| M 03/15/1974 AU | |
| 120180 Vino George | |
| Sales Rep. II 12/01/1978 $26,970 | |
| M 06/27/1954 AU | |
| 120198 Meera Body | |
| Sales Rep. III 12/01/2006 $28,025 | |
| F 01/21/1988 AU | |
| 120261 Harry Highpoint | |
| Chief Sales Officer 08/01/1987 $243,190 | |
| M 02/21/1969 US | |
| 121018 Julienne Magolan | |
| Sales Rep. II 01/01/1974 $27,560 | |
| F 01/03/1944 US | |
| 121019 Scott Desanctis | |
| Sales Rep. IV 06/01/2004 $31,320 | |
| M 06/25/1986 US | |
| 121020 Cherda Ridley | |
| Sales Rep. IV 05/01/2002 $31,750 | |
| F 02/23/1984 US | |
| 121021 Priscilla Farren | |
| Sales Rep. IV 03/01/1994 $32,985 | |
| F 12/10/1974 US | |
| 121022 Robert Stevens | |
| Sales Rep. IV 02/01/2002 $32,210 | |
| M 10/28/1979 US | |
| 121023 Shawn Fuller | |
| Sales Rep. I 05/01/2007 $26,010 | |
| M 03/13/1964 US | |
| 121024 Michael Westlund | |
| Sales Rep. II 05/01/2004 $26,600 | |
| M 09/21/1984 US | |
| 121025 Barnaby Cassey | |
| Sales Rep. II 09/01/1975 $28,295 | |
| M 10/10/1949 US | |
| 121026 Terrill Jaime | |
| Sales Rep. IV 04/01/2006 $31,515 | |
| M 11/08/1986 US | |
| 121027 Allan Rudder | |
| Sales Rep. II 12/01/1989 $26,165 | |
| M 05/05/1964 US | |
| 121028 William Smades | |
| Sales Rep. I 11/01/2007 $26,585 | |
| M 04/27/1988 US | |
| 121029 Kuo-Chung Mcelwee | |
| Sales Rep. I 12/01/2007 $27,225 | |
| M 12/22/1964 US | |
| 121030 Jeryl Areu | |
| Sales Rep. I 02/01/2007 $26,745 | |
| M 11/12/1979 US | |
| 121031 Scott Filan | |
| Sales Rep. III 08/01/1985 $28,060 | |
| M 07/09/1964 US | |
| 121032 Nasim Smith | |
| Sales Rep. IV 03/01/2006 $31,335 | |
| M 02/24/1988 US | |
| 121033 Kristie Snitzer | |
| Sales Rep. III 06/01/2004 $29,775 | |
| F 11/06/1986 US | |
| 121034 John Kirkman | |
| Sales Rep. II 01/01/2007 $27,110 | |
| M 08/23/1988 US | |
| 121035 James Blackley | |
| Sales Rep. II 01/01/1974 $26,460 | |
| M 03/25/1944 US | |
| 121036 Teresa Mesley | |
| Sales Rep. I 10/01/2007 $25,965 | |
| F 07/18/1988 US | |
| 121037 Muthukumar Miketa | |
| Sales Rep. III 03/01/2002 $28,310 | |
| M 06/12/1974 US | |
| 121038 David Anstey | |
| Sales Rep. I 08/01/2007 $25,285 | |
| M 02/13/1988 US | |
| 121039 Donald Washington | |
| Sales Rep. II 05/01/1980 $27,460 | |
| M 06/03/1954 US |
Starting Length of Line Number Field Data Type DescriptionColumn Employee ID First Name Field 12 18 20 Numeric Character Character Character Last Name 21 Job Title Numeric Hire Date 10 mm/dd/xy. Numeric e.g. $100,000 Character Salary Gender Numeric Birth Date 10 Country 14 Character Starting Length of Line Number Field Data Type DescriptionColumn Employee ID First Name Field 12 18 20 Numeric Character Character Character Last Name 21 Job Title Numeric Hire Date 10 mm/dd/xy. Numeric e.g. $100,000 Character Salary Gender Numeric Birth Date 10 Country 14 Character
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
