MACRO in SAP HANA

[bibbnd]

Is there a way to pass a macro variable into SAP HANA? 

Normally you use double quotes around a marco in proc sql to resolve but double quotes define a column name in SAP HANA therefore it will not resolve correctly

this is  snip of the code. if i put double quotes around it than it read as a column name.

where

E."0UCOPERAND"="&OP_TYPE."

i have tried it without double quotes and it stll doesn't work.

Any ideas

[SASKiwi · Accepted solution]

What does "doesn't work" mean? If SAP HANA insists on only accepting single quotes then try this:

E."0UCOPERAND"=%str(%')&OP_TYPE.%str(%')

[bibbnd]

I GET AN ERROR MESSAGE
ERROR: CLI prepare error: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;260 invalid column name: TOUDEF: line 1 col 281 (at pos
280)
IT READS THE MARCO AS A COLUMN NAME