Enhancing Output with Multiple Techniques

Create a report that displays Customer$\_$ID and the customer$$s name displayed as LastName, FirstName,

and Gender, as well as the customer$$s age as of $02$FEB$2013.$ Use the data contained

in the orion.customer table. Include only U$.$S$.$ customers who were more than $50$ years old

on $02$FEB$2013.$ 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 of $20$ characters so

that the report can be printed in portrait orientation. The Customer$\_$ID values must

be displayed with leading zeros as shown in this sample report.

PROC SQL Output