topic Re: PROC SQL insert issue with macro variable in SAS Programming

PROC SQL insert issue with macro variable

LeeJenson — Mon, 08 Feb 2010 13:15:30 GMT

I am constructing a little dataset based on some variables using SQL but I am having a problem with inserting the data with the contents of a variable.

This is what I have

Test dataset created...

%let testvar=XYZ;

PROC SQL;
insert into test;
values ('test field text &testvar. ');
quit;

This .sas file is not a macro? Does it have to be to translate the contents of the variable as it does not at the moment?

Thanks
Lee Message was edited by: Lee2010

Re: PROC SQL insert issue with macro variable

DanielSantos — Mon, 08 Feb 2010 14:19:56 GMT

Hi.

Replace the single quotes with double quotes.

Macro variables do not get resolved to their values inside single quoting.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: PROC SQL insert issue with macro variable

Cynthia_sas — Mon, 08 Feb 2010 15:42:19 GMT

Hi:
In addition to Daniel's advice, you might find this paper useful. It contains an overview of the SAS Macro Facility:
http://www2.sas.com/proceedings/sugi28/056-28.pdf

cynthia

Re: PROC SQL insert issue with macro variable

LeeJenson — Thu, 25 Feb 2010 13:32:23 GMT

Sorry...
that's twice that has caught me out and you have provided me with the answer.

Thanks

Lee