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 (September 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 20 Sep 2007 10:23:01 -0400
Reply-To:   Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:   Re: Large datastep interrupted, have a large data1.sas7bdat.lck file - any way to convert to usable data?
Comments:   To: kvasikonkav@gmail.com
In-Reply-To:   <1190243043.374804.203080@g4g2000hsf.googlegroups.com>
Content-Type:   text/plain; charset="us-ascii"

I would side with Paul here. You don't know exactly how the temporary file corresponds to the program that you are executing.

Four days of runtime sounds excessive today for processing datasets of GB scale. Perhaps this unfortunate event will motivate improvements in the program. Many SAS programmers have benefited from advice on how to streamline programs from Paul and others on the 'L.

While I strongly prefer to see a large program run in one stream, SAS does make it easy to segment programs into %INCLUDE blocks, save temporary files to permanent libraries, and delete temporary files in a subsequent %INCLUDE block. I'd program that safeguard before launching another program on a four-day journey. S

-----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of kvasikonkav@gmail.com Sent: Wednesday, September 19, 2007 7:04 PM To: sas-l@uga.edu Subject: Large datastep interrupted, have a large data1.sas7bdat.lck file - any way to convert to usable data?

I was running a job on a server, and the server was rebooted.

Consequently, I have a partially completed datafile, which has the suffix .sas7bdat.lck

The ".lck" file is a 225,000,000kb file (I think that is 225gb, right?)

SAS was nearly done processing a datastep when the server was rebooted. My understanding is that the ".lck" extension is sort of a temporary dataset that will later be renamed once the datastep is fully finished.

I don't want to wait another 4 days for the program to run again, so I was hoping the nearly complete ".lck" data could be recovered into a regular dataset without too much effort?

is there any way to recover any of the data out of a ".sas7bdat.lck" file, or convert it into a sas7bdat file?

Thanks!

Thanks again!


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