Unable to Repair Large Data Set
in [SAS]
|
From: Kevin Myers on 5 Oct 2009 20:40 Yes, I did. Setting DLDMGACTION=3DREPAIR had no positve effects on this = data set. It refused to be repaired. Any attempts to repair met with = the same error message as attempting to read it. ----- Original Message -----=20 From: Joe Matise=20 To: Kevin Myers=20 Cc: SAS-L(a)listserv.uga.edu=20 Sent: Monday, October 05, 2009 09:59 Subject: Re: Unable to Repair Large Data Set Just a random thought, but did you check that OPTION DLDMGACTION (As = referenced earlier) is set to force it to attempt to repair the dataset? -Joe On Mon, Oct 5, 2009 at 3:36 PM, Kevin Myers <KevinMyers(a)austin.rr.com> = wrote: SAS would not allow the "damaged" data set to be read or repaired at = all. Nothing that I tried worked. Everything resulted in an error = message to the effect that "the index file was damaged", and it wouldn't let you to anything else at all. ----- Original Message ----- From: "Patrick" <patrick.matter(a)GMX.CH> To: <SAS-L(a)LISTSERV.UGA.EDU> Sent: Saturday, October 03, 2009 21:49 Subject: Re: Unable to Repair Large Data Set Why couldn't you just re-create the index? Something like: data large; do keyA=3D1 to 10000; keyB=3Dceil(ranuni(0)*1000); output; end; run; proc sql; create index keyAKeyB on large ( KeyA,Keyb); create index KeyB on large ( Keyb); quit; |