BookmarkSubscribeRSS Feed
pmayev
Calcite | Level 5

I am trying to import a .stc file into SAS University Edition. I get the error:

"ERROR: You cannot open WORK.SASGOPT.CATALOG for update access because WORK.SASGOPT.CATALOG is in use by you in resource environment. IOM ROOT COMP ENV."

 

This is my code:

 

libname datain "/folders/myfolders/SAS Project/apas2015";
options nofmterr;
filename parole "/folders/myfolders/SAS Project/apas2015/36619-0001-Data.stc";

proc cimport
	infile= parole
	library= work
	isfileutf8= true;
run;

This is my Log file:

 

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         libname datain "/folders/myfolders/SAS Project/apas2015";
 NOTE: Libref DATAIN was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: /folders/myfolders/SAS Project/apas2015
 74         options nofmterr;
 75         filename parole "/folders/myfolders/SAS Project/apas2015/36619-0001-Data.stc";
 76         
 77         proc cimport
 78         infile= parole
 79         library= work
 80         isfileutf8= true;
 81         run;
 
 ERROR: You cannot open WORK.SASGOPT.CATALOG for update access because WORK.SASGOPT.CATALOG is in use by you in resource environment 
 IOM ROOT COMP ENV.
 ERROR: Unable to open catalog WORK.SASGOPT.
 NOTE: Total number of entries processed in catalog WORK.SASGOPT: 0
 
 ERROR: You cannot open WORK.SASMAC1.CATALOG for update access because WORK.SASMAC1.CATALOG is in use by you in resource environment 
 IOM ROOT COMP ENV.
 ERROR: Unable to open catalog WORK.SASMAC1.
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC2
 NOTE: Total number of entries processed in catalog WORK.SASMAC2: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC3
 NOTE: Total number of entries processed in catalog WORK.SASMAC3: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC4
 NOTE: Total number of entries processed in catalog WORK.SASMAC4: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC5
 NOTE: Total number of entries processed in catalog WORK.SASMAC5: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC6
 NOTE: Total number of entries processed in catalog WORK.SASMAC6: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC7
 NOTE: Total number of entries processed in catalog WORK.SASMAC7: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC8
 NOTE: Total number of entries processed in catalog WORK.SASMAC8: 0
 
 NOTE: PROC CIMPORT begins to create/update catalog WORK.SASMAC9
 NOTE: Total number of entries processed in catalog WORK.SASMAC9: 0
 
 ERROR: You cannot open WORK.SASMACR.CATALOG for update access because WORK.SASMACR.CATALOG is in use by you in resource environment 
 _O_TAGS.
 ERROR: Unable to open catalog WORK.SASMACR.
 NOTE: Total number of entries processed in catalog WORK.SASMACR: 0
 
 NOTE: PROCEDURE CIMPORT used (Total process time):
       real time           0.01 seconds
       cpu time            0.00 seconds
       
 
 82         
 83         
 84         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 97         

Thank you

1 REPLY 1
ballardw
Super User

Create a different library an import to that library. The message you are getting is that catalogs in the stc file have the same name as catalogs you are 'using' in you current session. Send them elsewhere and the conflict will go away.

 

Since you had created a library datain I thought that was where you were going to import the stc to but you instead used work as the library in cimport.

 

BTW do not be surprised if after you get them imported you have some issue with "catalog was made in a different operating system".

 

If the purpose of this exercise is to recover macros I would suggest trying to find the code would be a good idea.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 910 views
  • 0 likes
  • 2 in conversation