2. Calculating a Column Write a query that generates the report below. The repor
ID: 3876006 • Letter: 2
Question
2. Calculating a Column Write a query that generates the report below. The report should do the following: • display Employee_ID, Employee_Gender, Marital status, Salary, and a new column (Tax) that is one-third of the employee's salary • use the orion.Employee Payroll table Partial PROC SQL Output The SAS System Employee_ Marital Employee_ID Gender Status Salary Tax fffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 128181 M 163848 54346.67 128182 M 188255 36885 128183 M 87975.29325 128184 F 46230 X 15418 1281e5 F 27110 9836.667 128186 M 26966 8986.667 128187 F 394751858.33 128188 F 9228 120189 F 26495 8831.667 1201 18 M 2865 9538.333 128111 M 26895 8965 128112 F 26550 8858 128113F 26870 8956.667 128114 F 31285 18428.33 128115 M 26580 8833.333 . DomètredistribuiExplanation / Answer
TTITLE CENTER - 'Donations Exceeding $90.00 in 2007' SQL.PNO --TTITLE center helps to set at center of page
COLUMN Employee_ID HEADING 'Employee ID'--column Headings
COLUMN Recipients HEADING 'Recipients'--columns Headings
COLUMN Total HEADING 'Total'--columns Headings
SET UNDERLINE 'f'
SELECT z.Employee_ID, z.Recipients, z.Total
FROM
(SELECT Employee_ID, Recipients, (Qtr1+Qtr2+Qtr3+Qtr4) AS Total
FROM orion.Employee_Donations ) AS z
WHERE z.Total>90;
--Calculation a column
TTITLE CENTER - 'The SAS System' SQL.PNO
SET UNDERLINE 'f'
COLUMN Employee_ID HEADING 'Employee ID'--column Headings
COLUMN Employee_Gender HEADING 'Employee_|Gender'--column Headings
COLUMN Marital_Status HEADING 'Marital_|Status'--column Headings
COLUMN Salary HEADING 'Salary'--column Headings
COLUMN TAX HEADING 'Tax'--column Headings
SELECT z.Employee_ID, z.Employee_Gender, z.Marital_Status,z.Salary,z.TAX
FROM
(SELECT Employee_ID, Employee_Gender,Marital_Status,Salary,(decimal(decimal,Salary)/3) AS TAX
FROM orion.Employee_Payroll ) AS z
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.