topic File ECI00001.seg_info.data is not a SAS data set. in SAS Programming

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

cellurl — Mon, 08 Aug 2016 15:55:22 GMT

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

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

ballardw — Mon, 08 Aug 2016 18:53:51 GMT

How did you attempt to read the data?

Please post the code and the log results.

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

cellurl — Mon, 08 Aug 2016 20:02:03 GMT

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

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

ballardw — Mon, 08 Aug 2016 20:12:05 GMT

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?

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

cellurl — Mon, 08 Aug 2016 20:43:08 GMT

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