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.
Please post your libname statement and the log that you get when you execute it.
Then try to run a PROC CONTENTS on the dataset.
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?
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.
Then I'd use the hints provided here: http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000247698.htm
to list, remove and recreate the damaged index(es).
"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.
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.
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!
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.