Getting SAS Connection error

Reply
Frequent Contributor
Posts: 89

Getting SAS Connection error

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.

Super User
Posts: 10,592

Re: Getting SAS Connection error

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 4,028

Re: Getting SAS Connection error

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

New Contributor
Posts: 2

Re: Getting SAS Connection error

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.

Ask a Question
Discussion stats
  • 3 replies
  • 596 views
  • 0 likes
  • 4 in conversation