In reading a dataset using sas9 or EG7.12 , I get the error. (attached, but seg_info.sas7bndx didn't copy correctly....)
It is very infrequent. I would like to understand what I might do to prevent it in the future?
Any insight appreciated.
Thanks!
Jim
I suspect that you may need to rebuild the index or rename the index file. Something may have corrupted it. Is performance acceptable if you don't reference the index?
How did you attempt to read the data?
Please post the code and the log results.
MPRINT(GET_CURRENT_DATA): proc sql; MPRINT(GET_CURRENT_DATA): create table prim_raw.seg_info(index=(seg_id)) as select a.* from prmviews.seg_info a, tmp b where a.seg_id = b.seg_id ; INFO: Index seg_id of SQL table ISHDATA1.SEG_INFO selected for SQL WHERE clause (join) optimization. ERROR: File PRIM_RAW.SEG_INFO.DATA is not a SAS data set.
MPRINT(DRIVER): libname prim_raw "/mktg/prcxx/app_scratch/xxx_audit/xxxxxxx/prim/raw"; NOTE: Libref PRIM_RAW was successfully assigned as follows: Engine: V9 Physical Name: /xxxx/xxxxxx/app_scratch/xxx_audit/xxxxx/prim/raw
I suspect that you may need to rebuild the index or rename the index file. Something may have corrupted it. Is performance acceptable if you don't reference the index?
yea, if it happens again, I will remove the index creation. Thanks!
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.