Content from Data.xlsx filePatientID First Name LastName Gender DOBPATO01 EmilyHarrisFemalePATO02 EmilyLeeFemalePATO03MichaelClarkMalePATO04JaneMalePATO05 EmilyMalePAT006MaleBrownSmithMichael Smith1/9/821/10/671/8/591/7/801/3/631/9/65Admission Date11/15/227/12/236/30/233/22/235/4/237/7/23Length OfStay204539227BaseCharge521.98544.13430.21445.09910.19695.5DiscountRate0.270.030.460.130.180.35 Write SAS code for the following task:1) Read in the excel file "Data.xlsx" to create a temporary SAS dataset2) Based on the DOB column, create a new column called Age3) Based on Admission Date and LengthOfStay, create a new column called DischargeDate4) Based on BaseCharge and DiscountRate, create a new column called DiscountAmount5) Based on DiscountAmount and BaseCharge, create a new column called TotalCharge6) Remove the LengthOfStay and DiscountRate columns and ensure all columns, includingthe original and new, are in the correct format to represent the data, i.e., date, money7) Checking the data type and displaying the final data table with PROC CONTENTS andPROC PRINT8) The final dataset should be exported as a csv file named "Output Data.csv"

In this question we have to provide the SAS code for the following task.No output as it is a…

Content from Data.xlsx file PatientID First Name Last Name PATO01 Emily Harris PATO02 Emily Lee PAT003 Clark PATO04 Jane Brown PATO05 Emily Smith PATO06 Michael Smith Michael Gender DOB Female Female Male Male Male Male 1/9/82 1/10/67 1/8/59 1/7/80 1/3/63 1/9/65 Admission Date 11/15/22 7/12/23 6/30/23 3/22/23 5/4/23 7/7/23 Length OfStay 20 45 3 9 22 7 BaseCharge 521.98 544.13 430.21 445.09 910.19 695.5 DiscountRate 0.27 0.03 0.46 0.13 0.18 0.35

Content from Data.xlsx file PatientID First Name Last Name PATO01 Emily Harris PATO02 Emily Lee PAT003 Clark PATO04 Jane Brown PATO05 Emily Smith PATO06 Michael Smith Michael Gender DOB Female Female Male Male Male Male 1/9/82 1/10/67 1/8/59 1/7/80 1/3/63 1/9/65 Admission Date 11/15/22 7/12/23 6/30/23 3/22/23 5/4/23 7/7/23 Length OfStay 20 45 3 9 22 7 BaseCharge 521.98 544.13 430.21 445.09 910.19 695.5 DiscountRate 0.27 0.03 0.46 0.13 0.18 0.35

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

# Create College Database: # input choice using integer # create if-else conditions: # if you entered number 1 # enter student id, # enter student name # enter student major # enter students grade1 # enter students grade2 # calculate total grades # calculate average of grades # create if else condition where based on average will display their grade too # display all variables # if you entered number 2 # enter faculty id, # enter faculty name # enter faculty department # enter faculty monthly salary # show yearly salary by calculating monthly salary with 12 # display all variables
R language Show Which department has the highest admission on UCB admission dataset available in R, please answer it with code
CSC1100 ProductID ProdName 614 Sprinkler G15 Humming bird feeder 620 Garden hose 625 Shovel JG29 Tab connector G43 Leaf roke G46 Pruning Shears 656 Bird House 35 G57 Planter box 130 Answer the following questions about the Products table in this image 1. What are the field names? Products InStock Database Review 78 40 60 30 65 89 8
INVOICE VEND_ QUANT_ PROD_ INV_NUM PROD_NUM SALE_DATE PROD_LABEL VEND_NAME CODE SOLD PRICE 211347 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. 1 $49.95 211347 QD-300932X 15-JAN-2016 0.25-in. drill bit 211 Neverfail, Inc. 8 $3.45 211347 RU-995748G 15-JAN-2016 Band saw 309 BeGood, Inc. 1 $39.99 211348 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. $49.95 211349 GH-778345P 16-JAN-2016 Power drill 157 ToughGo, Inc. 1 $87.75
Add the provided information to a new record in the REP table. SELECT * FROM REP Expected Results REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL_PHONE COMMISSION RATE 35 Fred Kiser 427 Billings Dr. Cody WY 82414 307-555-6309 0.00 0.05
Table EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.
Use excel XVOOKUP FIND THE INFO ABOUT SALE MADE BY LAURA
Create Owner Table Insert Data
DEPENDENT FNAME DOB Relationship ЕMPID 111 MAI 29/1/2001 Mother 012 222 SALEH 7/4/2001 Single 033 333 AHMED 23/2/1980 Father 087 NORMALIZE THIS TABLE THIS 3NF
USE MICROSOFT SQL SERVER
Please don't copy
STUDENT Name Student number Smith Brown COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION 17 8 102 112 119 135 Class 1 2 Course_number CS1310 CS3320 MATH2410 CS3380 Section_identifier Course_number 85 MATH2410 92 CS1310 CS3320 MATH2410 CS1310 CS3380 Major CS CS Credit_hours 4 4 3 3 Semester Fall Fall Spring Fall Fall Fall Year 07 07 08 08 08 08 Department CS CS MATH CS Instructor King Anderson Knuth Chang Anderson Stone