SQL Macro

DartRodrigo — Fri, 17 Jul 2015 15:18:52 GMT

Hi guys,

I need help to do the following:

- Need to use a macro variable created in a proc sql in a data step or another proc sql.

But when i declare it into proc sql and %put to the log it works, but when i call it into another step, it doesn't.

I have the following code test:

%MACRO PEGA_DATA();

DATA TESTE;

X='27APR2015'D;

FORMAT X DATE9.;

RUN;

PROC SQL;

SELECT X INTO: DATE FROM TESTE;

QUIT;

%LET DATE = &DATE.;

%PUT &DATE.;

DATA TESTE2;

Y = '&DATE.'D;

RUN;

%MEND;

%PEGA_DATA();

What shall i do ?

Tks,

Rodrigo Dartibali Elias

Re: SQL Macro

nketata — Fri, 17 Jul 2015 16:03:55 GMT

You felt into the quote trap

Try with Y = "&DATE."D;