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
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 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.