MPRINT(_M_CREATESIM_REF): CREATE TABLE CES0123.SIM_MAP_COINS ( coinsrCode CHARACTER(10) LABEL = 'coinsrCode', systemCoinsrCode
CHARACTER(10) LABEL = 'systemCoinsrCode' ) ;
ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
SYMBOLGEN: Macro variable IN_SIMID resolves to CES0123
Hi Team,
After creating the datasets, we are getting error like ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA. even we have not set any alter password.
Could you please check and update why this issue came.
Regards,
Chandra
Plesse show the complete log of the step that creates the dataset, and the complete log of the failing step. Copy/paste the log text into a window opened with this button:
Is CES0123.SIM_MAP_COINS a SAS dataset? If so, please run PROC CONTENTS and show the output, it should show if there is a password under PROTECTION.
Are you able to recreate this problem? If so, please run a small example that replicates the problem and post the full code and log. The code should create a dataset that did not exist previously, and then attempt to insert data into that dataset (or overwrite it), and trigger the error.
Hi,
A similar looking issues appears to have been resolved here:
It might be of help.
Thanks & kind regards,
Amir.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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: