Orion.customer table 3. Enhancing output with Multiple Techniques Create a repor

Question

Orion.customer table
3. Enhancing output with Multiple Techniques Create a report that displays Customer LD and the customer's name displayed as LastName, FirstName, and Gender, as well as the customer's age as of02FEB2013. Use the data contained in the orion customer table. Include only U.S. customers who were more than 50 years old on 02FEB2013. Present the data ordered by descending age and customer name. Give the report an appropriate title. Limit the space used to display the customer's name to a maximum of20 characters so that the report can be printed in portrait orientation. The Customer ID values must displayed with leading zeros as shown in this sample report. PROC SQL Output US Customers 60 Years old as of 02FEB013 Customer Last Name, ID First Name Gender Age 0000056 Siferd. Roy 76 0000089 Lewis nella 74 0000092 Celli. Lendon 0000023 Devereaux, Tulio M 59 0000018 Asmussen, Tonie 56 Jimmie 54

Explanation / Answer

proc sql;
select put(customer_id,z7.) as customer_id, lastname,gender, (02'FEB2013 -birthdate) as age format best32.
from orion.customer
ordered by descedning age, customer_name
having age>50;
quit;

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.