Error : File is NOT a SAS Dataset

[hexx18]

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 ?

[Reeza · Accepted solution]

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

[Tom]

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.

[hexx18]

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 .

[SASKiwi]

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

[hexx18]

How do I do that ? Any help on this ?

Thank you

[SASKiwi]

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

[hexx18]

It worked Thank you