LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 26 Nov 2003 11:02:07 -0800
Reply-To:   "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:   Re: sorting fields in output table
Comments:   To: "Bezares, Raul" <raul.bezares@CITIGROUP.COM>

Raul -

If you mean to order the fields on the data vector you can use a retain statement before the set statement...

Data stuff; Retain Field1 Field2 Field3 Field4 Field5 Field6 Field7; Set stuff;

If you mean to sort data within the fields then you want Proc sort-

Proc sort data=stuff out=stuff; By Field1 Field2 Field3 Field4 Field5 Field6 Field7;

Hth

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: Bezares, Raul [mailto:raul.bezares@CITIGROUP.COM] Sent: Wednesday, November 26, 2003 10:23 AM To: SAS-L@LISTSERV.UGA.EDU Subject: sorting fields in output table

Hello all,

I would like to know how to sort the fields in a certain output table ?

For instance, the current sorting is: "Field6 Field4 Field3 Field1 Field2 Field7 Field5"

and I would like they were like: "Field1 Field2 Field3 Field4 Field5 Field6 Field7"

Suggestions?

Thanks in advance, Raul.


Back to: Top of message | Previous page | Main SAS-L page