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 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 18 Nov 2008 21:01:16 -0800
Reply-To:     xlr82sas <xlr82sas@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         xlr82sas <xlr82sas@AOL.COM>
Organization: http://groups.google.com
Subject:      Re: data manipulation
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Nov 18, 3:19 pm, Mterje...@RUSSELL.COM ("Terjeson, Mark") wrote: > Hi, > > Here is one approach using RETAIN, > which will keep a value across rows: > > data sample; > infile cards missover; > input Var $ Set; > cards; > a 1 > b > c > d 2 > e > f > g > h 3 > i > ; > run; > > data result(drop=Hold_Set); > set sample; > retain Hold_Set .; > if Set ne . then Hold_Set = Set; > Set = Hold_Set; > run; > > Hope this is helpful. > > Mark Terjeson > Senior Programmer Analyst > Investment Management & Research > Russell Investments > 253-439-2367 > > Russell > Global Leaders in Multi-Manager Investing > > > > -----Original Message----- > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of hd > Sent: Tuesday, November 18, 2008 3:10 PM > To: SA...@LISTSERV.UGA.EDU > Subject: data manipulation > > Hello, > > My question is if I have a data set that looks like this > > Var Set > a 1 > b > c > d 2 > e > f > g > h 3 > i > > and I would like it to like this > > Var Set > a 1 > b 1 > c 1 > d 2 > e 2 > f 2 > g 2 > h 3 > i 3 > > In other words I want to just duplicate the entries until I reach an > entry in the Set column and then want to duplicate that. I am not sure > how I can do this, any help will be greatly appreciated. > > Thank you!- Hide quoted text - > > - Show quoted text -

One less line of code (untested)

data lvf(drop=set rename=lvf=set); retain lvf; set have; if not missing(set) then lvf=set; run;


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