topic Re: Descending Alphabetical Order in proc report in SAS Data Science

Descending Alphabetical Order in proc report

devarayalu — Mon, 16 Jul 2012 11:25:15 GMT

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?

Re: Descending Alphabetical Order in proc report

data_null__ — Mon, 16 Jul 2012 11:37:18 GMT

DESCENDING

Re: Descending Alphabetical Order in proc report

ScottBass — Mon, 16 Jul 2012 11:37:30 GMT

define last / order descending noprint;

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

Re: Descending Alphabetical Order in proc report

devarayalu — Mon, 16 Jul 2012 11:42:01 GMT

Thank you for the prompt answer.