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 (March 2002, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 29 Mar 2002 00:43:37 -0500
Reply-To:   "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Organization:   MindSpring Enterprises
Subject:   Re: how to transform this data set? Thanks!
Content-Type:   text/plain;

"Jinrui Cui" <jcui@UCLA.EDU> wrote in message news:200203290013.QAA07439@serval.noc.ucla.edu... > 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

Here's another

data b; do until (last.column1); set a; by column1; sum = sum (sum, column2); end; output; keep a sum; run;

-- Richard A. DeVenezia Need long HTML Titles and Footnotes ? http://www.devenezia.com/downloads/sas/macros/index.html#js


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