SASUSER profile damaged

[yaswoman]

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.

[art297]

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.

[yaswoman]

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.

[momi]

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

[SASKiwi]

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

[manix]

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?

[SASKiwi]

@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.

[Kurt_Bremser]

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.