I'm setting up a macro variable to contain the connection to oracle input. I'm reading the username and password from a file and setting the macro variable CSSACC to contain the full connection string. I used a &put statement make sure the connection string looks correct. I'm showing it here with the password shortened:
user=dmcunnin orapw={SAS002}1D5793 path=css1 schema=cssprod
When I use the CSSACC macro in my program to set up the oracle libname, I receive an error and the log output has the first { of the password changed to an X. How to I correct this?
NOTE: Line generated by the macro variable "CSSACC".
945 user=dmcunnin orapw=XSAS002}1D5793 path=css1 schema=cssprod
______
22
ERROR: Libref CSS is not assigned.
ERROR: Error in the LIBNAME statement.
No idea why i replaces the curly bracket.
Have tried to enclose the password in quotes?
No idea why i replaces the curly bracket.
Have tried to enclose the password in quotes?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.