SQL Macro

[DartRodrigo]

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

[nketata · Accepted solution]

You felt into the quote trap

Try with   Y = "&DATE."D;