topic How do I read data from a damaged SAS dataset in SAS Programming

How do I read data from a damaged SAS dataset

VVDR — Sun, 14 Jun 2020 00:53:31 GMT

Hi,

How do I read the data from a damaged SAS dataset.

In what instances SAS dataset gets damaged ?

Please help me here.

TIA..

Re: How do I read data from a damaged SAS dataset

Patrick — Sun, 14 Jun 2020 01:06:30 GMT

Look into Proc Repair

If you kill a SAS process in the middle of an in-place write process to a SAS table then it could get damaged (i.e. an insert/update/delete using the SAS data step modify statement).

Re: How do I read data from a damaged SAS dataset

SASKiwi — Sun, 14 Jun 2020 02:59:01 GMT

If your SAS dataset is not repairable, what strategies do you have restore it? Possible options are restoring from a backup version or recreating it from another data source. You may also be able to read up to and / or around the damaged record(s) by using the FIRSTOBS= and OBS= read options.

Re: How do I read data from a damaged SAS dataset

Kurt_Bremser — Sun, 14 Jun 2020 04:45:27 GMT

A dataset can als be damaged by running out of disk space while writing it.

PROC DATASETS has a REPAIR statement.