data two;
input Name $20. Number $22-34;
Last=scan(name, -1);
cards;
Jeff W. Snoker (908)782-4382
Raymond Albert (732)235-4444
Alfred Edward Newman (800)123-4321
Steven J. Foster (201)567-9876
Jose Romerez (516)593-2377
;
proc report data=two nowd;
column name Number last;
define last / order noprint;
define number/ 'Phone Number' ;
run;
This is the code for report in Ascending order of last variable. But I want the Names and Phone Numbers in descending Alphabetical Order by Last Name.
Can any one help?
DESCENDING
define last / order descending noprint;
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473627.htm, scroll to ORDER option.
Thank you for the prompt answer.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.