topic SAS DI - use parameter in advance expressions in SAS Data Management

SAS DI - use parameter in advance expressions

Peter_Wine — Fri, 02 Feb 2018 11:14:41 GMT

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

jklaverstijn — Fri, 02 Feb 2018 11:26:15 GMT

If you intend to use a character value then enclose the macro variable reference in double quotes:

"&parm"

Hope this helps,

-- Jan.

Peter_Wine — Fri, 02 Feb 2018 11:39:51 GMT

Works!!!

Thanks a lot.

Regards,

Peter