topic Re: ERROR: invalid or missing alter password on member in SAS Programming

ERROR: invalid or missing alter password on member

sathya66 — Thu, 11 Jul 2019 16:33:28 GMT

Hi,

I was trying to open one of my datasets after the migration(We copied the datasets to new location) and I was prompted to enter an ‘Alter Password’ . I tried and failed with my current sas password, and now when I run the code again this appears in the log.

please suggest.

Re: ERROR: invalid or missing alter password on member

ChrisNZ — Thu, 11 Jul 2019 22:49:10 GMT

Give us more details. It works for me.

options dlcreatedir; 
libname SUB "%sysfunc(pathname(WORK))\sub";

data T(alter='A'); X=1; run;

proc sort data=WORK.T(alter='A'); by X; run;

proc copy in=WORK out=SUB; select T; run;

proc sort data=SUB.T(alter='A'); by descending X; run;

This code runs fine as is, and fails when the passwords are erroneous.

Re: ERROR: invalid or missing alter password on member

sathya66 — Fri, 12 Jul 2019 08:04:30 GMT

Below code doesn't work for me .It is giving an error at proc copy statement

ERROR: File SUB.T.DATA does not exist.
ERROR: File SUB.T.DATA has not been saved because copy could not be completed.

We moved the data sets manually to new location (cut and paste).when I try to duplicate that table ,it is giving below error.

Re: ERROR: invalid or missing alter password on member

sathya66 — Fri, 12 Jul 2019 08:39:13 GMT

The file path for the folder before was

libname ss "/data/datasets/Departments/ss";

and post migration it is now

libname ss "/data/datasets/Departments/EG/SS/All_Files";

Initially when I ran the code concerning datasets in the location there was a pop-up prompt asking for the alter data password. Now when I open it and try to run there is no pop-up but in the log it has the error shown in the original post.

Thanks,

Re: ERROR: invalid or missing alter password on member

sathya66 — Fri, 12 Jul 2019 12:03:30 GMT

Hi,

Now issue is resolved.

Deleted the data sets and recreated them.

Thanks,