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
You felt into the quote trap
Try with Y = "&DATE."D;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.