File ECI00001.seg_info.data is not a SAS data set.

[cellurl]

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 

[ballardw]

How did you attempt to read the data?

Please post the code and the log results.

[cellurl]

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

[ballardw · Accepted solution]

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?

[cellurl]

yea, if it happens again, I will remove the index creation.  Thanks!