topic Re: SAS DataSet in SAS Programming

Unable to open SAS DataSet

RohiniJ — Wed, 26 Mar 2025 09:20:02 GMT

Hi,

I am unable to open a SAS dataset. When I click on the SAS file, I get this message.

How do I open the SAS file and not get this error message?

Thanks

Re: SAS DataSet

FK21 — Mon, 24 Mar 2025 13:52:02 GMT

Have you checked, whether you have a library "TMP1" assigned?

Re: SAS DataSet

RohiniJ — Mon, 24 Mar 2025 14:12:14 GMT

How do i check that?

Re: SAS DataSet

Tom — Mon, 24 Mar 2025 14:22:10 GMT

Looks like you double clicked a FILE on your computer and it caused SAS to try and browse the dataset. From your photograph it looks like the file is named person.sas7bdat.

The most common issue is that the dataset has formats attached that you do not have defined in your SAS session and you are running with the FMTERR option turned on.

To get a better idea of what is happening avoid using the mouse and instead write some code. Make your own libref that points to the directory that has the dataset. Then run code against the dataset to see what it contains.

So if the directory where that file exists is named C:\MyDir then try running code like this:

libname mylib 'C:\MyDir\';
proc contents data=mylib.person; 
run;
proc print data=mylib.person(obs=10);
run;

If the PROC CONTENTS shows that some of the variables have user defined formats attached and the PROC PRINT fails try turning off the FMTERR option.

options nofmterr;

Re: SAS DataSet

Ksharp — Tue, 25 Mar 2025 01:54:03 GMT

Plz post the LOG information when you open this dataset.
Or try Tom's advice:

options nofmterr validvarname=any validmemname=extend ;

Re: SAS DataSet

RohiniJ — Wed, 26 Mar 2025 12:27:41 GMT

Thank you! This worked!

I greatly appreciate the help!