BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
DianeMC
Calcite | Level 5

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

No idea why i replaces the curly bracket.

Have tried to enclose the password in quotes?

Data never sleeps

View solution in original post

1 REPLY 1
LinusH
Tourmaline | Level 20

No idea why i replaces the curly bracket.

Have tried to enclose the password in quotes?

Data never sleeps

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 638 views
  • 0 likes
  • 2 in conversation