topic Re: Getting SAS Connection error in SAS Programming

Getting SAS Connection error

santhosh — Thu, 05 Mar 2015 05:51:21 GMT

Getting sas error Kindly check

NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.

NOTE: All profile changes will be lost at the end of the session.

ERROR: Expecting page 1, got page -1 instead.

ERROR: Page validation error while reading SASUSER.PROFILE.CATALOG.

Re: Getting SAS Connection error

Kurt_Bremser — Thu, 05 Mar 2015 07:16:49 GMT

Go to your home directory, search for the sasuser.vxx directory; in this directory delete the profile.sas7bcat file, it is most certainly damaged.

Re: Getting SAS Connection error

SASKiwi — Thu, 05 Mar 2015 07:17:15 GMT

Your SASUSER.PROFILE catalog is corrupted. You can simply delete it as SAS will re-create it automatically.

Re: Getting SAS Connection error

ylwang — Tue, 06 Feb 2018 17:16:36 GMT

The error reported in the SAS log:

Indicates the SASUSER profile files cannot be correctly read by SAS. The profile files are created or read by SAS every time the application is launched. Please do the following to delete the existing files so that SAS can recreate them on next startup:

1. Launch SAS and submit the following code:
proc options option = sasuser; run;
2. The output in the log will show you the location of the SASUSER profile on your machine, for example, the default location is as follows (where <UID> is your Windows user ID):
SASUSER=C:\Users\<UID>\Documents\My SAS Files\9.4
3. Navigate to the SASUSER path in a File Explorer window and delete the following files:
profbak.sas7bcat
profile.sas7bcat
profile2.sas7bcat
4. Close any open SAS sessions and launch a new session.