topic Re: SASUSER profile damaged in SAS Procedures

SASUSER profile damaged

yaswoman — Wed, 04 May 2011 14:13:41 GMT

Hello, I am hoping someone can help please. I was trying to bring an XCEL spread sheet into SAS and keep getting this message
ERROR: Catalog SASUSER.PROFILE.CATALOG is in a damaged state. Use the REPAIR command of PROC
DATASETS to restore it.
ERROR: Catalog SASUSER.PROFILE.CATALOG is in a damaged state. Use the REPAIR command of PROC
DATASETS to restore it.
ERROR: Catalog SASUSER.PROFILE.CATALOG is in a damaged state. Use the REPAIR command of PROC
DATASETS to restore it.
Can someone please let me know how exactly to use the PROC.
I run sas remotely if that helps.

Thank you so much.

Re: SASUSER profile damaged

art297 — Wed, 04 May 2011 14:36:28 GMT

Take a look at: http://support.sas.com/kb/15/758.html

It indicates that the message is wrong and explains how to correct the problem.

HTH,
Art
----------
> Hello, I am hoping someone can help please. I was
> trying to bring an XCEL spread sheet into SAS and
> keep getting this message
> ERROR: Catalog SASUSER.PROFILE.CATALOG is in a
> damaged state. Use the REPAIR command of PROC
> DATASETS to restore it.
> Catalog SASUSER.PROFILE.CATALOG is in a damaged
> state. Use the REPAIR command of PROC
> DATASETS to restore it.
> Catalog SASUSER.PROFILE.CATALOG is in a damaged
> state. Use the REPAIR command of PROC
> DATASETS to restore it.
> eone please let me know how exactly to use the PROC.
>
> I run sas remotely if that helps.
>
> Thank you so much.

Re: SASUSER profile damaged

yaswoman — Wed, 04 May 2011 14:53:00 GMT

Thanks so much Art. So I guess all my libraries that were reflected in my old profiles are no longer since a new profile has to be recreated once I open a session of SAS. Thanks so much for the effort to look up the error for me. Much appreciated.

Re: SASUSER profile damaged

momi — Mon, 27 Feb 2017 17:09:05 GMT

Hi,

I have the same question in this topic and I went to the link you provided. Below is the part of the explanation.

PROC DATASETS cannot restore the SASUSER.PROFILE.CATALOG. The user needs to rename the catalog to a different name. At the operating system level rename profile.sas7bcat to something like profile1.sas7bcat. When a new session of SAS is started, a new profile will be created."

I am still not clear how to rename the catalog file? Is this something simple? Just go to my library to rename the catalog file?

Thanks,

Momi

Re: SASUSER profile damaged

SASKiwi — Mon, 27 Feb 2017 19:16:52 GMT

Yes, just rename it, or in fact you can just delete it because it is totally unusable.

Re: SASUSER profile damaged

manix — Tue, 24 Jun 2025 11:31:29 GMT

I have the same problem.

I found the sasmacr.sas7bcat file in /opt/sas/spre/home/SASFoundation/cmacros(linux) in 6 folders:

or, hpf, dmine, modelsvr, decisionsvr and base.

Which one should i rename,delete?

After that a SAS restart is necessary?

Re: SASUSER profile damaged

SASKiwi — Tue, 24 Jun 2025 21:06:32 GMT

@manix Your screenshot refers to the SASMACR catalog in your WORK library. What happens if you start a new SAS session and rerun - does the same problem occur? WORK catalogs are deleted when you close your SAS session.

Edit - IO errors are also reported. That suggests you have run out of space in your WORK library. I suggest you report the problem to your SAS support people.

Re: SASUSER profile damaged

Kurt_Bremser — Tue, 24 Jun 2025 22:49:41 GMT

Your problem is not the same one. The original question was about SASUSER.PROFILE, your issue is with WORK.SASMACR. Different catalog file, different location.
You probably exceeded your quota in the WORK location, maybe because of remnants of crashed or improperly terminated SAS sessions.