Hey everyone,
I'm trying to use a macro for a datasource name. I've defined it under Administration > Macro Files, and I can use it successfully with other nodes, such as a SQL Query node. In an Expression node, though, it doesn't work. I've tried the two ways the Expression Language Guide suggests:
1) DSN = %%dsn_name%%
2) DSN = "%%dsn_name%%" // with quotes
2) DSN = getvar("dsn_name")
# 1 does not validate
# 2,3 validates, but results in the same error: "Data source name not found and no default driver specified..."
I'm using DM Studio 2.6.
Thanks,
mark
Your expression code will look something like this:
string macro1
macro1 = getvar("MyMacro")
where MyMacro was defined in a macros file. A few things to check:
Ron
Hi Ron,
Thanks so much! I will try this out.
- mark
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!Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.