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?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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: