SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DI - use parameter in advance expressions

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 8
Accepted Solution

SAS DI - use parameter in advance expressions

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


Accepted Solutions
Solution
3 weeks ago
Super Contributor
Posts: 493

Re: SAS DI - use parameter in advance expressions

Posted in reply to Peter_Wine

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

 

"&parm"

Hope this helps,

-- Jan.

View solution in original post


All Replies
Solution
3 weeks ago
Super Contributor
Posts: 493

Re: SAS DI - use parameter in advance expressions

Posted in reply to Peter_Wine

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

 

"&parm"

Hope this helps,

-- Jan.

Occasional Contributor
Posts: 8

Re: SAS DI - use parameter in advance expressions

Posted in reply to jklaverstijn

Works!!!

 

Thanks a lot.

 

Regards,

 

Peter

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 226 views
  • 1 like
  • 2 in conversation