Use SAS code to answer the following prompt: 1) Import the file Data for Programming.xlsx into...

Transcribed Image Text:

Use SAS code to answer the following prompt: 1) Import the file "Data for Programming.xlsx" into SAS 2) Next, DISPLAY the first 10 observations for all variables (including new ones) in a .html body file with 'Statistical' style and meet these requirements: 1). Use the original column names for all original variables 2). Use the date format for original date variables as appeared in .xlsx file; 2). Calculate the 'Discharge_Date' based on Admission date and LOS and display the values with form like this: 09/30/23; 3). Calculate the patient's out of pocket payment 'Patient_pay' using 'Total cost' and 'Insurance pay' columns; 4). Use the dollar format to display values in 'Total cost', 'Insurance pay' and 'Patient_pay': Excel file content: Pt ID Date of birth COVID-19 test results Admission date LOS (Length of Stay, days) Total cost Insurance pay 210 367 9/21/73 10/30/90 Pos 2-Sep-20 4 $2,398.00 $2,000.00 Positive 30-Jan-20 6 $3,568.00 $3,210.00 271 3/21/00 Neg 21-Feb-20 12 $8,765.00 $8,300.00 897 4/6/11 pos 16-Apr-20 2 $1,870.00 $1,065.00 2134 3/3/86 negative 30-Mar-20 1 $564.00 $510.00 9801 9/21/99 NA 21-Sep-20 9 $7,890.00 $7,100.00 210 1/27/97 Pos 29-Apr-20 7651 8/1/96 Neg 1-Aug-20 30 $124,980.00 28 $34,598.00 $123,100.00 $30,678.00 361 8/1/90 Pos 1-Jul-20 12 $12,098.00 $10,876.00 2076 10/11/96 11-Jul-20 5 $3,678.00 $3,005.00 8710 1/1/99 NA 10-May-20 9 $8,765.00 21 5/1/02 Negative 30 4/11/03 Neg 1-May-20 17-Apr-20 1 $876.00 37 $35,678.00 912 7/17/03 Positive 19-Jul-20 16 $21,098.00 $8,000.00 $521.00 $30,567.00 $20,165.00 Use SAS code to answer the following prompt: 1) Import the file "Data for Programming.xlsx" into SAS 2) Next, DISPLAY the first 10 observations for all variables (including new ones) in a .html body file with 'Statistical' style and meet these requirements: 1). Use the original column names for all original variables 2). Use the date format for original date variables as appeared in .xlsx file; 2). Calculate the 'Discharge_Date' based on Admission date and LOS and display the values with form like this: 09/30/23; 3). Calculate the patient's out of pocket payment 'Patient_pay' using 'Total cost' and 'Insurance pay' columns; 4). Use the dollar format to display values in 'Total cost', 'Insurance pay' and 'Patient_pay': Excel file content: Pt ID Date of birth COVID-19 test results Admission date LOS (Length of Stay, days) Total cost Insurance pay 210 367 9/21/73 10/30/90 Pos 2-Sep-20 4 $2,398.00 $2,000.00 Positive 30-Jan-20 6 $3,568.00 $3,210.00 271 3/21/00 Neg 21-Feb-20 12 $8,765.00 $8,300.00 897 4/6/11 pos 16-Apr-20 2 $1,870.00 $1,065.00 2134 3/3/86 negative 30-Mar-20 1 $564.00 $510.00 9801 9/21/99 NA 21-Sep-20 9 $7,890.00 $7,100.00 210 1/27/97 Pos 29-Apr-20 7651 8/1/96 Neg 1-Aug-20 30 $124,980.00 28 $34,598.00 $123,100.00 $30,678.00 361 8/1/90 Pos 1-Jul-20 12 $12,098.00 $10,876.00 2076 10/11/96 11-Jul-20 5 $3,678.00 $3,005.00 8710 1/1/99 NA 10-May-20 9 $8,765.00 21 5/1/02 Negative 30 4/11/03 Neg 1-May-20 17-Apr-20 1 $876.00 37 $35,678.00 912 7/17/03 Positive 19-Jul-20 16 $21,098.00 $8,000.00 $521.00 $30,567.00 $20,165.00