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

Related questions

Q: Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

Q: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: Document store NoSQL c

A: Dear Student, The answer to your question is given below -

Q: Create a list manager names and also his supervise names if the manager has any one

A: you can try this query to get the result

Q: Name the button/icon of MS Access. * O Preview O Datasheet View O Design View

A: Given: Given an icon and we need to write the name of the icon.

Q: With the following information format the data into 1st, 2nd, and 3rd normal form. Case ID Test…

A: 1st Normal Form The table in question has a composite attribute (Patient_Name) and repeated groups…

Q: Name the candidate keys in the following table: Student L number Student_Name Student SS Number…

A: a candidate key is a super key which has no redundant attribute.

Q: Where is part C? Please answer part C

A: Que) Imagine that the vertical arrows below the devices are timelines and that the clocks of all…

Q: View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file…

A: Actually, the answer has given below:

Q: The file that contains information about the tables, fields, records, and properties included in the…

A: The full form of XSD is an extended schema description. The XSD extension file format file is used…

Q: Enter ID: Add ID ID 123 abc 123abc abc123 54321 Remove All Item Name Price Number of Rows: 5

A: The HTML CSS JS code is given below with output screenshot

Q: SALES Customer ID (primary key) Date of purchase Item code(foreign key) 001 2/05/2021 A-1 002…

A: Logical view : represents the functionality of the particular database to users.

Q: , Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe…

A: The question asks to identify functional dependencies in a dataset of pet records and consider…

Q: Insert two maintenance in batch to the MAINTENANCES table. 523922 S O (D S Suspenen C (NG C WO Den O…

A: Since there are multiple questions, the first full question is answered for you. Please post the…

Q: Task 15: List the invoice number and invoice date for each invoice that either was created for James…

A: The solution is given below for the above given question:

Question

Content from Data.xlsx file
PatientID First Name LastName Gender DOB
PATO01 Emily
Harris
Female
PATO02 Emily
Lee
Female
PATO03
Michael
Clark
Male
PATO04
Jane
Male
PATO05 Emily
Male
PAT006
Male
Brown
Smith
Michael Smith
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

Write SAS code for the following task:
1) Read in the excel file "Data.xlsx" to create a temporary SAS dataset
2) Based on the DOB column, create a new column called Age
3) Based on Admission Date and LengthOfStay, create a new column called DischargeDate
4) Based on BaseCharge and DiscountRate, create a new column called DiscountAmount
5) Based on DiscountAmount and BaseCharge, create a new column called TotalCharge
6) Remove the LengthOfStay and DiscountRate columns and ensure all columns, including
the original and new, are in the correct format to represent the data, i.e., date, money
7) Checking the data type and displaying the final data table with PROC CONTENTS and
PROC PRINT
8) The final dataset should be exported as a csv file named "Output Data.csv"

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Overview

VIEW

Step 2: Explanation

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

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
Create Owner Table Insert Data
USE MICROSOFT SQL SERVER
So if I have this table: staffNo dentistName patientNo patientName appointment_date appointment_time surgery_no S1011 Tony Smith P100 Gillian White 12-Aug-03 10:00 S10 S1011 Tony Smith P105 Jill Bell 13-Aug-03 12:00 S15 S1024 Helen Pearson P108 Ian MacKay 12-Sep-03 10:00 S10 S1024 Helen Pearson P108 Ian MacKay 14-Sep-03 10:00 S10 S1032 Robin Plevin P105 Jill Bell 14-Oct-03 16:30 S15 S1032 Robin Plevin P110 John Walker 15-Oct-03 18:00 S13 Here the non-trivial functional relations include at least the following: staffNo --> dentistName patientNo -->patientName partientNo, appointment_date, appointment_time --> surgery_no Do you believe there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed.How do I draw this out?
IF POSSIBLE PLEASE TYPE OR WRITE ELIGIBLY illustrate the process of normalizing the data shown in this table to third normal form (3NF). officeNo officeAddress telNo mgrStaffNo name B001 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern Primary key: officeNo Why the above table is not in 3NF? Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.
Database course
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?
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.
Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS SECTION Section_ID Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name. Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson". Insert a tuple for a new COURSE with the following information: 4.The course name is Computer networks, and the course number is CS3480. It belongs to the CS…