Date:         Fri, 29 Mar 2002 07:31:01 -0500
Reply-To:     "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Subject:      Re: how to transform this data set? Thanks!
Comments: To: "jcui@UCLA.EDU" <jcui@UCLA.EDU>
Content-Type: text/plain; charset="iso-8859-1"

Henry,

For this type of question, there are many solutions. However, the DOW loop
offering stands out for its brevity:

data a;
   input a:$1. b;
   datalines;
a 15
a 5
a 10
b 10
c 5
c 10
;

data b (drop = c);
   do until (last.a) ;
      set a (rename = (b = c)) ;
      by a ;
      b = sum(b,c) ;
   end ;
run ;

Kind Regards,

Venky
#****************************************#
#  E-mail: swovcc@hotmail.com            #
#  Phone:  (734) 622-1963                #
#****************************************#


-----Original Message-----
From: Jinrui Cui [mailto:jcui@UCLA.EDU]
Sent: Thursday, March 28, 2002 7:14 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: how to transform this data set? Thanks!


  Hi,

I have a data set (a), how to transfrom it into (b)?

(a)              (b)
-------------    ------------------
A    15          A    30
A    5           B    10
A    10          C    15
B    10          ------------------
C    5
C    10
-------------

Thanks!

Henry