Hi SAS Community,
I'm trying to use "Extract" transformation and for one column I'd like to use parameter defined in "User Written" step.
In "User written" I declare:
%LET parm='abc'
In "Extract" I created new column and in expression field I write:
&parm
I get error:
ERROR: The following columns were not found in the contributing tables: abc
Any idea?
Regards,
Peter
If you intend to use a character value then enclose the macro variable reference in double quotes:
"&parm"
Hope this helps,
-- Jan.
If you intend to use a character value then enclose the macro variable reference in double quotes:
"&parm"
Hope this helps,
-- Jan.
Works!!!
Thanks a lot.
Regards,
Peter
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.