topic Re: MAcro variable with single quotes in SAS Programming

MAcro variable with single quotes

yashpande — Thu, 01 Aug 2013 03:22:45 GMT

Hi All,

I have 4 macro variables which I want to use in Teradata SQL passthrough, since TD doesnt recognise double quotes, my challenge is to create them in single quotes.somehow I am unable to do it since few of them have missing values as well.

My macro variables are like this

%let var1=abc;

%let var2=pqr;

%let var3=;

%let var4=new;

I want to use it something like this in my proc sql

case when var1 eq 'abc' and var2 eq 'pqr' and var3 eq '' and var4 eq 'new' then true;

Any help is really appreciated

Re: MAcro variable with single quotes

SASKiwi — Thu, 01 Aug 2013 03:56:32 GMT

Does something like this help:

%let var1 = abc;

%put case when var1 eq %str(%')&var1%str(%');

Re: MAcro variable with single quotes

Scott_Mitchell — Thu, 01 Aug 2013 04:53:39 GMT

%LET VAR1='ABC';

%LET VAR2='PQR';

%LET VAR3='';

%LET VAR4='NEW';

PROC SQL;

CREATE TABLE TEST AS

SELECT *,

CASE WHEN VAR1 EQ &VAR1. AND VAR2 EQ &VAR2. AND VAR3 EQ &VAR3. THEN 1 END AS FLAG

FROM HAVE

;

RUN;

Why not surround your macro variable values in single quotes?

Re: MAcro variable with single quotes

yashpande — Thu, 01 Aug 2013 06:34:30 GMT

Got it working with something like this

%let var1_n=%unquote(%bquote(')&var1%bquote('));