BookmarkSubscribeRSS Feed
abhik_giri
Calcite | Level 5

I'm not being able to read a particular SAS dataset (in sas7bdat format) into SAS using libname. Even obs=1 does not work. SAS gets hanged every time I run. I tried few times, but it doesn't work.

6 REPLIES 6
LinusH
Tourmaline | Level 20

What's the origin of the data set? Perhaps it's create on some other host?

Perhaps it's corrupt. Try PROC DATASETS with REPAIR.

Can you create new data sets in the same libname?

Can you read other data sets in the same libname?

Data never sleeps
abhik_giri
Calcite | Level 5

I tried "proc datasets library=your_lib; repair a; quit;. ". It says index of the dataset is damaged. 

In the same libname, I'm being able to create new datasets as well as read other datasets.

 

LinusH
Tourmaline | Level 20

"When you use the REPAIR statement for SAS data sets, it recreates all indexes for the data set"

So is it fixed after the REPAIR?

If not, share the full log from the REPAIR operation.

Data never sleeps
ballardw
Super User

What version of SAS are you using?

Do you know who made the data set and which version of SAS was used?

SAS 9.4 datasets are not readable by version 9.2 32 bit at least. So if you have an older version of SAS that may be the cause.

 

 

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1720 views
  • 0 likes
  • 4 in conversation