While creating the password it is throwing below error

[Lav001]

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

[Kurt_Bremser]

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

[Reeza]

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

---

[ballardw]

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.

[Reeza]

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.

---