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 (July 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 9 Jul 2004 14:50:34 -0400
Reply-To:     "Lustig, Roger" <roger.lustig@CITIGROUP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Lustig, Roger" <roger.lustig@CITIGROUP.COM>
Subject:      More about: Fill Up the data.........?
Comments: To: graeme.kirton@totalise.co.uk
Content-Type: text/plain; charset="iso-8859-1"

Revised version:

data sneaky/view=sneaky;***Why fill up the SASWORK folder?; ID + 1;***Make a temporary sequence number; do until (header='PRR'); ***PRR is the last record in a set, right?; set original; output; end; run; data final (drop=xheader ID); merge sneaky(drop=x y where=(header='PTR')) sneaky(keep=header x y [Lustig, Roger] ID rename=(header=xheader) where=( xheader='PRR')); by ID; run; Roger

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Graeme Kirton Sent: Friday, July 09, 2004 9:19 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Fill Up the data.........? Importance: High

Hi I'm stuck on how to Fill Up my data. My dataset has 2.7 million obs but I enclose a snippet.

I need to fill up (retain upwards) the x y and fill down the parameters excluding the header PRR? Thanks for any stuff.

header,x,y,WaferNo,TPTime,Parameter,Parameter_VAL PTR,,,3,,VL_ONDC,6.931811E-8 PTR,,,3,,A1RX_ILS11,-17.42966 PTR,,,3,,A1RX_ILS12,-0.9998372 PTR,,,3,,A1RX_ILS21,-0.9887992 PTR,,,3,,A1RX_ILS22,-18.45851 PTR,,,3,,A2RX_ISOL_A1RX_ONS21,-29.90085 PTR,,,3,,A1TX_ISOL_A1RX_ONS21,-36.20408 PRR,-11,77,3,1085,, PTR,,,3,,,2.085953E-7 PTR,,,3,,,-17.44223 PTR,,,3,,,-0.9867322 PTR,,,3,,,-0.9765825 PTR,,,3,,,-18.51518 PTR,,,3,,,-29.85899 PTR,,,3,,,-36.02086

------------------------------------- Name : Grame Kirton Email : graeme.kirton@totalise.co.uk

_____

Message sent via Totalise Webmail - http://www.totalise.co.uk/

_____

Message sent via Totalise Webmail - http://www.totalise.co.uk/


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