SQL Macro

Accepted Solution Solved
Reply
Regular Contributor
Posts: 212
Accepted Solution

SQL Macro

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


Accepted Solutions
Solution
‎07-17-2015 12:03 PM
Contributor
Posts: 34

Re: SQL Macro

You felt into the quote trap Smiley Happy

Try with   Y = "&DATE."D;

View solution in original post


All Replies
Solution
‎07-17-2015 12:03 PM
Contributor
Posts: 34

Re: SQL Macro

You felt into the quote trap Smiley Happy

Try with   Y = "&DATE."D;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 181 views
  • 0 likes
  • 2 in conversation