SAS Programming

I need the solution for the following SAS Programming problem:

Lab 2.83: Exercises p": Create the Labz-B folder for saving the Lab les. Rotating a Data Set and Using a Lookup Table 1. If you restarted your 5A5 session since the last lab section, open and submit the libname program found in the data folder. 2. Before doing this exercise, clear the log and output windows. 3. The data set orion.travel_expense contains an observation for each employee business trip. It includes Trip_Il:i, EmployeeJD, and up to ve expenses, Expi-Exps, as shown below: Exp 1 Airfare Exp: Meals W WWM Exps M isoel Ia neous Exps M isoelia neous Partial orion.travel_expense (10 Total Observations) Epilogue; Oha Trip_ID ID 9.11:1 E1132 E1133 E1134 E1135 1 1044-1 121044 345.9'7I 550.54 235.00 320.00 . 2 0145-1 120145 255.00 575.90 343.25 125.00 57.50 3 0555-1 120555 312.25 . 235.90 325.00 45.00 4 1119-1 121119 597.00 790.99 345.0"!I 195.00 50.75 5 0012-1 120012 345.24 055.45 534.20 430.50 75.75 4. Create a new program p205f01.sas. This program should create a new data set, travel. The travel date set should rotate the orion.travel_expense data set. The new data set oontains one observation per non-missing travel expense. - The new data set should contain the variables Trip_ID, EmployeeJD, Expense_Type, and Amount. :- Use two arravs in vour solution: one to refer to each of the ve expenses in an observation and a second array to store the expense types as a iookup table. See the table above for the expense tvpe names. 5. Add a PRDC PRINT step to print the travel data set. Format Amount with dollar signs, oommas, and tvvo decimal places. 5. Submit the p205f01 program. View the output. Compare your results to the partial listing below. Your report should contain 44 observations. 7. Save the p205f01 program in the Labz-B folder. Partial PRDC PRINT Output [44 Total Observations) Employee_ Che Trip_ID ID Expenae_Typa amount 1 10441 121044 Airfare $345 . 97 2 1044-1 121044 Hotel $559 . 54 3 1044-1 121044 Heals $235 . 00 4 10441 121044 Transportation $320 . 00 5 0145-1 120145 airfare $256 . 00