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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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