Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the given table below and SAS SQL: Example of output: Employee ID Qtr1 Qtr2 Qtr3 Qtr4 Recipients 120265 120267 15 120269 20 120270 20

Using the given table below and SAS SQL:

image text in transcribed

image text in transcribed

Example of output:

image text in transcribed

Employee ID Qtr1 Qtr2 Qtr3 Qtr4 Recipients 120265 120267 15 120269 20 120270 20 120271 20 120272 10 120275 15 120660 25 20662 10 120663 120668 10 Paid_By Cash or Check Payroll Deduction Payroll Deduction Cash or Check Payroll Deduction Payroll Deduction Credit Card Credit Card Cash or Check Cash or Check Credit Card 25 Mitleid international 90%, Save the Baby Animals 10% 15 Disaster Assist, Inc. 80%, Cancer Cures, Inc. 20% 20 Cancer Cures, Inc. 10%, Cuidadores Ltd. 90% 15 20 10 20 10 15 25 15 20 5 20 10 15 25 5 5 10 . AquaMissions International 10%, Child Survivors 9090 20 Cuidadores Ltd. 8096, Mitleid International 20% 10 AquaMissions International 10%, Child Survivors 90% 15 AquaMissions International 60%, Child Survivors 40% 25 Disaster Assist, Inc. 5 Cancer Cures, Inc. EarthSalvors 30%, Vox Vctimas 70% 10 AquaMissions International 80%, Child 10 Survivors 20% Create a report that displays the Employee JD, the Recipients, and the number of quarterly contributions for each employee, who contributed to more than one company and who made a contribution in only one or two quarters. PROC SQL Output No.of.Contribs 1 1 Employee ID Recipients 120265 Mitleid International 90%, Save the Baby Animals 10% 120663 | EarthSalvos 30%, Vox Victimas 70% 1206781 Disaster Assist, Inc. 50% , Cancer Cures, Inc. 50%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

3. Identify challenges to good listening and their remedies

Answered: 1 week ago

Question

4. Identify ethical factors in the listening process

Answered: 1 week ago