topic While creating the password it is throwing below error in New SAS User

While creating the password it is throwing below error

Lav001 — Fri, 21 Dec 2018 21:37:37 GMT

Hi,

While creating the password it is throwing below error, any suggestion?

%let QCCPW = QCC2019;
PROC SQL;
Create table SAMPLE.BO_DATA (alter=&QCCPW write=&QCCPW)
as select *
from BO_DATA_&YM A LEFT JOIN
AACILITY_INFO (drop=zip_code state: county: city: ) B
on A.Aacility=B.Aacility
order by A.Unique_ID;
QUIT;

ERROR: Invalid or missing ALTER password on member SAMPLE.BO_DATA.DATA.

Thanks

Lav

Re: While creating the password it is throwing below error

Kurt_Bremser — Fri, 21 Dec 2018 21:40:55 GMT

The message must be for another codepart, as the code you posted does not have any reference to QUALDAT.BI_DATA.

Re: While creating the password it is throwing below error

Reeza — Fri, 21 Dec 2018 23:18:42 GMT

Simplifying your code shows no errors. The error is likely somewhere else, otherwise please post your full log.

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         %let QCCPW = QCC2019;
 70         PROC SQL;
 71         Create table BO_DATA (alter=&QCCPW write=&QCCPW)
 72         as select *
 73         from sashelp.class;
 NOTE: Table WORK.BO_DATA created, with 19 rows and 5 columns.
 
 74         QUIT;
 NOTE: PROCEDURE SQL used (Total process time):
       real time           0.05 seconds
       cpu time            0.03 seconds

@Lav001 wrote:

Hi,

While creating the password it is throwing below error, any suggestion?

%let QCCPW = QCC2019;
PROC SQL;
Create table SAMPLE.BO_DATA (alter=&QCCPW write=&QCCPW)
as select *
from BO_DATA_&YM A LEFT JOIN
AACILITY_INFO (drop=zip_code state: county: city: ) B
on A.Aacility=B.Aacility
order by A.Unique_ID;
QUIT;

ERROR: Invalid or missing ALTER password on member SAMPLE.BO_DATA.DATA.

Thanks

Lav

Re: While creating the password it is throwing below error

ballardw — Fri, 21 Dec 2018 23:30:02 GMT

Is there any chance that the SAMPLE library is external database or odbc link or similar?

Any chance that instead of SAMPLE.BO_DATA you intended use SAMPLE.BO_DATA_&YM in the create table statement? If there is a name mismatch then perhaps the existing SAMPLE.BO_DATA has a different password than SAMPLE.BO_DATA_&YM.

And of course you may just have the wrong password.

Re: While creating the password it is throwing below error

Reeza — Fri, 21 Dec 2018 23:35:02 GMT

I can recreate the error if I use the wrong password and am trying to replace a file that already exists, but has a different password.

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         %let QCCPW = QCC2018;
 70         PROC SQL;
 71         Create table BO_DATA (alter=&QCCPW write=&QCCPW)
 72         as select *
 73         from sashelp.class;
 ERROR: Invalid or missing ALTER password on member WORK.BO_DATA.DATA.
 
 NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
 74         QUIT;
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE SQL used (Total process time):
       real time           0.01 seconds
       cpu time            0.00 seconds

@ballardw wrote:

Is there any chance that the SAMPLE library is external database or odbc link or similar?

Any chance that instead of SAMPLE.BO_DATA you intended use SAMPLE.BO_DATA_&YM in the create table statement? If there is a name mismatch then perhaps the existing SAMPLE.BO_DATA has a different password than SAMPLE.BO_DATA_&YM.

And of course you may just have the wrong password.