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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.
Ready to level-up your skills? Choose your own adventure.