DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 43
Accepted Solution

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

[ Edited ]

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 

 

Attachment

Accepted Solutions
Solution
‎08-08-2016 04:43 PM
Super User
Posts: 10,500

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

[ Edited ]

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?

 

View solution in original post


All Replies
Super User
Posts: 10,500

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

How did you attempt to read the data?

 

Please post the code and the log results.

Contributor
Posts: 43

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

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
Solution
‎08-08-2016 04:43 PM
Super User
Posts: 10,500

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

[ Edited ]

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?

 

Contributor
Posts: 43

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

[ Edited ]

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

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 533 views
  • 0 likes
  • 2 in conversation