BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PleaseHelpKMS
Calcite | Level 5

I get the error "An error occurred while attempting to display a message. The details of the message were: --------" when I try to open a .sas7bdat file. Also SAS enterprise Guide crashses after that. I have all the latest versions, I reinstalled SAS a number of times, changing the software version every time, and I always get the same error. The file is not corrupted as I tried to open different .sas7bdat files and I get the same error, I also sent my files to colleagues with the same version of SAS Enterprise Guide and they can open the files just fine. Please help!

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

Instead of opening the file directly, can you assign a SAS library to the path and access the data from there?

 

It sounds like you have SAS installed on your machine as well as EG.  But if not, try the Upload Data Set to Server task to send your data set to a library on your SAS session (could be WORK) and see if you can access that way.

 

A little behind-the-scenes info: when you double-click or select to open a sas7bdat file in EG, one of two approaches is followed:

  • If you have SAS on your local machine, EG will connect to your local SAS and assign a temporary libname to access the data from your local file path.
  • If you don't have SAS locally, EG will use the SAS OLE DB Local Data provider to read the data directly to provide you with a data view.  However, if you run a task or query, EG will copy that data to your remote SAS session to make the data available there.

If you can provide the details of the message, I might be able to provide some more insight into what's happening here.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

Remove all SAS components first (using Control Panel), then install everything from the ground up. If that does not fix it, I suggest the Windows solution #1: format the system drive and reinstall Windows from scratch, followed by the SAS software.

ChrisHemedinger
Community Manager

Instead of opening the file directly, can you assign a SAS library to the path and access the data from there?

 

It sounds like you have SAS installed on your machine as well as EG.  But if not, try the Upload Data Set to Server task to send your data set to a library on your SAS session (could be WORK) and see if you can access that way.

 

A little behind-the-scenes info: when you double-click or select to open a sas7bdat file in EG, one of two approaches is followed:

  • If you have SAS on your local machine, EG will connect to your local SAS and assign a temporary libname to access the data from your local file path.
  • If you don't have SAS locally, EG will use the SAS OLE DB Local Data provider to read the data directly to provide you with a data view.  However, if you run a task or query, EG will copy that data to your remote SAS session to make the data available there.

If you can provide the details of the message, I might be able to provide some more insight into what's happening here.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
PleaseHelpKMS
Calcite | Level 5

"--------" is literally the message of the error.

I tried uploading the data to the server and opening it from there in my EG, it's the only thing that worked so far, thank you!

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

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 4 replies
  • 2807 views
  • 1 like
  • 3 in conversation