topic Re: Error : File is NOT a SAS Dataset in SAS Programming

Error : File is NOT a SAS Dataset

hexx18 — Mon, 27 Jan 2020 19:29:40 GMT

Hi There was an upgrade on server for space issue and I get below error . I am unable to retrieve any records from testlib.payments SAS dataset . libname testlib "serverpath"; data apple; set testlib.payments; run; ERROR: File testlib.payments.DATA is not a SAS data set. Can anyone please help ?

Re: Error : File is NOT a SAS Dataset

Reeza — Mon, 27 Jan 2020 19:36:19 GMT

You should probably raise this first with an internal administrator to ensure there isn't an issue with your set up.

Re: Error : File is NOT a SAS Dataset

Tom — Mon, 27 Jan 2020 19:39:38 GMT

Sounds like you file is bad. Are you sure the file is a SAS dataset? Just changing the name of the file at the operating system level does not make the contents a SAS dataset.

You seem to say that SAS itself has changed on your system. What was changed? Are you using the same machine and a different version of SAS? What version are you using now? What version were you using before? SAS datasets are normally compatible, but there are limits. You cannot read version 5 datasets for example. You cannot read datasets from an IBM mainframe on Unix or Windows machines. You might need to run the old verison of SAS and convert the files to a transport file of some type to be able to read it with the new version of SAS.

Re: Error : File is NOT a SAS Dataset

hexx18 — Mon, 27 Jan 2020 19:57:54 GMT

It’s a SAS dataset which resides in server and Server space has been increased so we can store more data . Now I think file got corrupted . And gives above error when I am trying execute above SAS code .

Re: Error : File is NOT a SAS Dataset

SASKiwi — Mon, 27 Jan 2020 20:13:40 GMT

Get the file restored from backup from a date you know when it wasn't corrupted.

Re: Error : File is NOT a SAS Dataset

hexx18 — Mon, 27 Jan 2020 20:17:07 GMT

How do I do that ? Any help on this ?

Thank you

Re: Error : File is NOT a SAS Dataset

SASKiwi — Mon, 27 Jan 2020 21:21:27 GMT

Contact your IT support folks / help desk or your SAS administrator. They should be able to help you.

Re: Error : File is NOT a SAS Dataset

hexx18 — Wed, 29 Jan 2020 16:47:40 GMT

It worked Thank you