select into macro variable - no row selected with single quotation mark

[ZRick]

why this marco doesn't work:

%macro t(var=);

proc sql;

select name into: name from sashelp.class where name='&var.';

quit;

%put _user_;

%mend;

%t(var=Henry);

what is wrong with my single quotation mark?

[Tom · Accepted solution]

Macro language references are not expanded when enclosed in single quote marks. Use double quote character instead.

name = "&var"

[ZRick]

is this the only main difference when choosing to use single or double quotation?

I always thought single/double quotation can be used interchangeably.

[Haikuo]

Good topic for a SUG paper. Their differences seem to be more than just that. Especially when you refer Windows path ( X command, etc) or using SQL pass-thru ( well, to be fair, that is NOT a difference within SAS).

Haikuo

[ZRick]

Is it safe to say that double quote is more generic than single quote in passing macro variables?

[Tom]

Here is a nice write up in the on line documentation.

http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a001071889.htm