07-31-2013 11:22 PM
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
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
08-01-2013 12:53 AM
CREATE TABLE TEST AS
CASE WHEN VAR1 EQ &VAR1. AND VAR2 EQ &VAR2. AND VAR3 EQ &VAR3. THEN 1 END AS FLAG
Why not surround your macro variable values in single quotes?
Need further help from the community? Please ask a new question.