topic MACRO in SAP HANA in SAS Programming

MACRO in SAP HANA

bibbnd — Mon, 12 Jul 2021 21:02:31 GMT

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

Re: MACRO in SAP HANA

SASKiwi — Mon, 12 Jul 2021 21:36:51 GMT

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

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

Re: MACRO in SAP HANA

bibbnd — Mon, 12 Jul 2021 23:23:37 GMT

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