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.
Hi,
Now issue is resolved.
Deleted the data sets and recreated them.
Thanks,
SS
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.
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.
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
Hi,
Now issue is resolved.
Deleted the data sets and recreated them.
Thanks,
SS
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: