Date:         Mon, 18 Sep 2006 17:31:44 -0700
Reply-To:     Steve_Dun <steve.bates003@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Steve_Dun <steve.bates003@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Sas Question (Re-organizing dataset)
Comments: To: sas-l@uga.edu
In-Reply-To:  <1158621927.514427.221330@k70g2000cwa.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Not overly elegant but:

        data    code1 (keep = name amount code1
                                        rename = (code1 = code))
                   code2 (keep = name amount code2
                                        rename = (code2 = code))
                   code3 (keep = name amount code3
                                        rename = (code3 = code));
        set x ;
        run ;

        data y (drop = code1-code3);
        set code1 code2 code3 ;
        run ;

        proc sort data = y ;
                by name ;
        run ;