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

Hi,

 

I'm having trouble opening a SAS dataset. When I try to open the dataset I get an error that says  "unable to open table. Do you want to select a different table to open?". When I check the log I get an error that says "ERROR: Format CTYLBL not found or couldn't be loaded for variable IDCNTRY." The dataset opens for the person who shared it with me so I'm not sure what the issue is on my end. Any help is appreciated!!

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

You can change the option that is making not being able to find the format an ERROR.

 

Run this statement.

options nofmterr ;

And you should be able to use the dataset.

Hopefully you can tell from the raw unformatted values what the data means.  If not ask for the code to create the formats from the person that gave you the dataset.

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

You can change the option that is making not being able to find the format an ERROR.

 

Run this statement.

options nofmterr ;

And you should be able to use the dataset.

Hopefully you can tell from the raw unformatted values what the data means.  If not ask for the code to create the formats from the person that gave you the dataset.

nfatahi
Calcite | Level 5

Thank you so much! That worked. 

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1962 views
  • 0 likes
  • 2 in conversation