BookmarkSubscribeRSS Feed
RohiniJ
Calcite | Level 5

Hi, 

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

RohiniJ_0-1742822613040.png

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

 

Thanks 

 

 

5 REPLIES 5
FK21
Obsidian | Level 7

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

RohiniJ
Calcite | Level 5
How do i check that?
Tom
Super User Tom
Super User

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;

 

 

 

RohiniJ
Calcite | Level 5

Thank you! This worked! 

 

I greatly appreciate the help! 

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

options nofmterr validvarname=any validmemname=extend ;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2047 views
  • 3 likes
  • 4 in conversation