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

Write a SQL statement that will add the below row to the Task table.TaskID Description Duration StartDate TeamMemberID4 Implementemailnotifications2
How are missing character and numeric values represented in the data?
True or False The DBMS works directly with the data and sends the results of operations back to the application.
Required information id fname lname company address city ST zip 103 Art Venere 8 W Cerritos Ave #54 Bridgeport NJ 8014 104 Lenna Paprocki Feltz Printing 639 Main St Anchorage AK 99501
Which of the following will cause a deletion anomaly in the following table? Deleting surgery with surgeryNo S10. Deleting all appointments of Jill Bell. Deleting all appointments of Ian MacKay A) 1 and 2 B) 1 and 3 C) 2 and 3 D) All three
Create a C++ program that will perform record management of students. The code must involve implementation of control structures / array / struct/user-defined functions/class. INSTRUCTION: 1. Create a User's Menu for your program. An example is given below: Record Management [1] Add Record [2] Display Record Input your Choice: __ 2. If 1 is chosen, the user will be allowed to create 2 unique student records using the ADD_RECORD user-defined function. 3. After creating 2 records, the user may choose 2 to display existing and non-existing records. Use DISPLAY_RECORD user-defined function. 4. Perform the following 4 Test Cases below. 5. Submit the following through our Summative Assessment submission link on our Course Site on or before the deadline: a. C++ Code (.cpp) file b. Screenshot of Outputs using 4 Test Cases
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> credits
Normalize the following table to the 3rd Normal form: Student Student Phone Course Term Grade Instructor Instructor Phone Lauren Fernell 555-7771 MIS 350 F12 A Hess 555-2222 Lauren Fernell 555-7771 MIS 372 F12 B Sarker 555-2224 Lauren Fernell 555-7771 MIS 426 F12 A Fuller 555-2227 Lauren Fernell 555-7771 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 350 F12 A Hess 555-2222 Brigit Schnieder 555-2215 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 372 F12 A Sarker 555-2224 Brigit Schnieder 555-2215 MIS 374 F12 B Clay 555-2221 Jackie Judson 555-1245 MIS 350 F12 A Hess 555-2222 Jackie Judson 555-1245 MIS 372 F12 B+ Sarker 555-2224 How many tables did you create after normalizing the table? List each of…
Attribute Name Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 PROD NUM SALE DATE PROD LABEL VEND_CODE VEND_NAME QUANT SOLD PROD_PRICE AA-E3422QW 15-Jan-2018 Rotary sander 211 QD-300932X 15-Jan-2018 0.25-in. drill Band saw 211 309 NeverFail, Inc. NeverFail, Inc. BeGood, Inc. 1 $49.95 8 RU-995748G 15-Jan-2018 $3.45 1 $39.99 Sample Value Sample Value 211348 211349 AA-E3422QW 15-Jan-2018 Rotary sander 211 Power drill 157 NeverFail, Inc. ToughGo, Inc. 2 GH-778345P 16-Jan-2018 $49.95 1 $87.75 c) Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created.
Budget Quotation College Id College Name Quotation Amount Quotation Date 133 Higher College 5000.00 DEC-2020 233 Salalah College 3000.00 FEB-2021 433 Nizwa College 2000.00 MAR-2021