ERROR: invalid or missing alter password on member

[sathya66]

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.

[ChrisNZ]

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.

[sathya66]

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. 

[sathya66]

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,

ss

[sathya66 · Accepted solution]

Hi,

Now issue is resolved.

Deleted the data sets and recreated them.

Thanks,

SS