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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.3CP

See similar textbooks

Similar questions

The file london_weather.csv contains weather data for the years 1979 to 2020. The first five lines of this file are: date,cloud_cover,sunshine,global_radiation,max_temp,mean_temp,min_temp,precipitation,pressure,snow_depth19790101,2,7,52,2.3,-4.1,-7.5,0.4,101900,919790102,6,1.7,27,1.6,-2.6,-7.5,0,102530,819790103,5,0,13,1.3,-2.8,-7.2,0,102050,419790104,8,0,13,-0.3,-2.6,-6.5,0,100840,2 Note, in particular, that the dates are given as eight-digit integers in the format YYYYMMDD. There appears to be some inconsistencies in this data, as there are rows for which the column max_temp contains an entry that is smaller than the corresponding entry in min_temp. Write a Python function wrong_temperature(year) that returns the number of days in a given year for which the column max_temp contains an entry that is smaller than the corresponding entry in the column min_temp.
Create the following sample data file in SPSS and calculate the BMI(Body Mass Index) and show it in the next column as shown below: The formula to calculate BMI is BMI= Weight / ( Height * Height) * 703
General Output Find Results 6. Filename: TriangleProblem_FamilyName If a, b and e represcent the three sides of a triangle, then the arca of the triangle is: A = /s + (s – a) + (s – b) * (s – c where: s = “tb+c Also the radius of the largest inscribed circle is given by: r_insc = 4 and the radius of the smallest circumscribed circle is: r_circ =- 2.0 a•b•c 4*A circ _inse Inscribed Circle Circumscribed Circle
Create a function in your own database that takes two parameters: A year parameter A month parameter The function then calculates and returns the total sales of the requested period for each territory. Include the territory id, territory name, and total sales dollar amount in the returned data. Format the total sales as an integer. Hints: a) Use the TotalDue column of the Sales.SalesOrderHeader table in an AdventureWorks database for calculating the total sale. b) The year and month parameters should have the SMALLINT data type.
Create an Input File with the following information regarding to inventory: Item_Id Price Quantity Availability Add atleast 10 records in input file. Where item_id will be of type int , price will be of type double , quantity will be of type int and Availability will be of type char representing the status y for yes the product is available and n for not available.
Assume a file named “tiobeIndex” containing the ratings of programming languages as follows.There are six fields in each line separated by comma. The first filed is the ranking in Septemberthis year. The second filed is the ranking in September last year. The first row shows the meaningfor each field, the remained rows show the rating information for the top 10 programminglanguages. Write commandsto finish following tasks. Sep 2020, Sep 2019, Change, Programming Language, Ratings, Change 1, 1, , Java, 12.687%, -5.55% 1) Output only the two fields: ranking in September this year and name of programminglanguage using awk.Note: add text "Ranked" before the rank, and put a colon between the rank and the name.E.g. The info for Java should be displayed asRanked 1:Java 2) Change the plus sign in the third field to text "increase".E.g. Info for PHP should be changed to6, 7, increase, PHP, 2.210%, -0.64%
a. Write a Pandas program to read a dataset from automobiles DataFrame and modify the default columns values and print the first 10 rows. b. Write a Pandas program to select a series from automobilesDataFrame. Print the content of the series. c. Write a Pandas program to create a new Company - Price' Series (use bracket notation to define the Series name) of the automobiles DataFrame d. Write a Pandas program to remove body style, engine type, length columns at once of the automobiles Dataframe e. Write a Pandas program to sort the entire automobiles DataFrame by the price Series in ascending and descending order. f. Write a Pandas program to find average price and change from nan to average price according to other automobiles of same company. g. Write a Pandas program to find the automobiles that are either hatchback or wagon. h. Write a Pandas program to read rows 0, 5, 7 and all columns of automobiles DataFrame. i. Write a Pandas program to calculate the memory usage for each…
Tell the commands for python jupyter pandas manipulation required for these operations. 1* Import required module for reading file 2* Read the file 3* show info of all dataset There are columns of Apps Price Rating Type Review Genre 19* filter the data whose Genres is business and save the data 16* find the data from Apps columns whose name is BOX 17* find the sum of data from Apps columns whose name is BOX 20* find the total free Apps in dataset 21* filter the Apps whose rating is more the 4.2 22* convert the review columns into float datatype and sort the columns 23* find the unique values in Type columns 24* seprate the Free type apps in dataset¶ 25* seprate the paid type apps in dataset 26* save the data filter in question 24 into new excel file 27* find the shape of both seprate dataset in question 24,25 28* apply for loop in Category columns and append the data in new list whose Category is SOCIAL,GAME
Create a data file in Python using open, write and close functions. Your data file should contain your personal information: Complete name, student number, date of birth, and complete address help me here complete name: cloe jake gonzales student number: 12-1485 date of birth: january 12 1982 complete add: anastasia,1485 sokor, UAE
Two data files are required to evaluate a multiple-choice examination. The first file (booklet.dat) (memo) contains the correct answers. The total number of questions is 50. A sample file is given below: ACBAADDBCBDDAACDBACCABDCABCCBDDABCACABABABCBDBAABD The second file (answer.dat) contains the students’ answers. Each line has one student record that contains the following information: The student’s answers (a total of 50 answers): each answer can be A, B, C, D or * (to represent no answer). There are no blanks between answers. Student ID Student name A sample file is given below: AACCBDBC*DBCBDAAABDBCBDBAA*BCBDD*BABDBCDAABDCBDBDA 6555 MAHMUT CBBDBC*BDBDBDBABABABBBBBABBABBBBD*BBBCBBDBABBBDC** 6448 SINAN ACB*ADDBCBDDAACDBACCABDCABCCBDDABCACABABABCBDBAABD 6559 CAGIL Write a C++ program that counts the total number of correct answers by each student and outputs this information to another file called report.dat. In this file, the student’s IDs, names and the scores must be given. Each…
HW7_3 Ball bearings are hardened through a process known as quenching-submersion of the heated ball bearing in oil or water in order to cool it rapidly. The data below represent the temperature of the ball at various points in the cooling process time (sec) 0 30 Temp (C) 800 457 269 79 46 60 150 240 Plot the data (as discrete points). In the same figure window, also plot a) interpolating polynomial, (use polyfit and polyval) b) piecewise cubic interpolation (not-a-knot) and c) piecewise cubic interpolation (shape-preserving) Include a legend for the three methods used: polynomial interpolation, not-a-knot, shape-preserving. Then looking at the plot, choose the method you believe to be the best and smoothest fit of all these to predict the temperature after 3 minutes of cooling. Print the result using fprintf.
Using Python with File Manipulation file name reservation.txt Use Python Programming - restaurant reservation program. The application offers different reservation rate for adults and children. (see sample below) RESTAURANT RESERVATION SYSTEMSystem Menua. View all Reservationsb. Make Reservationc. Delete Reservationd. Generate Reporte. Exit 2. When the VIEW RESERVATIONS is clicked, this will display all the reservations made: # Date Time Name Adults Children 1 Nov 10, 2020 10:00 am John Doe 1 1 2 Nov 25, 202011:00 am Michelle Franks 2 1 3 Dec 10, 2020 9:00 am Ella Flich 1 1 4 Dec 21, 2020 12:00 pmDylan Cloze 2 1 3. If the user selects MAKE RESERVATION, the user needs to input the following: a. Name (String)b. Date (String)c. Time (String)d. No of Adults (Integer)e. No of Children (Integer) Note: Adult is 500 per head and Kids is 300 per head reservation, save the data in a text file. 4. If DELETE RESERVATION is selected, the user needs to input the reservation number to remove the…