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 09:40:58 +0100
Reply-To:     Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Subject:      Re: how to transform this data set? Thanks!
Comments: To: "jcui@UCLA.EDU" <jcui@UCLA.EDU>
Content-Type: text/plain

Hi Henry,

Yet another method, using a standard PROCedure:

DATA Original; INPUT x$ y; CARDS; A 15 A 5 A 10 B 10 C 5 C 10 ; RUN;

PROC UNIVARIATE DATA=Original NOPRINT; VAR y; BY x; OUTPUT OUT=Result SUM=y; RUN;

PROC PRINT DATA=Result; RUN;

Regards - Jim. -- Y. (Jim) Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070 senior statistician, P.O. Box 1 fax. +31 412 407 080 senior data manager 5350 AA BERGHEM IMRO TRAMARKO: a CRO J.Groeneveld@ITGroups.com the Netherlands in clinical research

My computer beeps when it complains; I complain when it beeps

Notice of confidentiality: this e-mail may contain confidential information intended for the addressed recipient only. If you have received this e-mail in error please delete this e-mail and please notify the sender so that proper delivery can be arranged.

> -----Original Message----- > From: Jinrui Cui [SMTP:jcui@UCLA.EDU] > Sent: Friday, March 29, 2002 1:14 AM > 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


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