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/