Descending Alphabetical Order in proc report

[devarayalu]

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?

[data_null__]

DESCENDING

[ScottBass]

define last / order descending noprint;

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473627.htm, scroll to ORDER option.

[devarayalu]

Thank you for the prompt answer.