topic define the value of "Variable" based on proc macro in SAS Programming

define the value of "Variable" based on proc macro

Alexxxxxxx — Mon, 09 Mar 2020 18:39:37 GMT

Hi all,

I would like to define the value of "Variable_name" as "WC01201"

%macro DatastreamVar(variable=);
data &variable.1(drop=AA AB AC AD Code NAME);
	length
	Type : $50.
	Variable_name :$100.
	;
	set &variable.;
	Variable_name=‘&variable.’;

	if _1990 = 'NA' then _1990 =.;
run;

%MEND DatastreamVar;
%DatastreamVar(variable=WC01201)
run;

however, it shows as "&variable." could you please give me some suggestions about this?

thanks in advance.

Re: define the value of "Variable" based on proc macro

PaigeMiller — Mon, 09 Mar 2020 18:50:14 GMT

Variable_name=‘&variable.’;

This is incorrect. You must use double-quotes (and they can't be the "curly" quotes you show either, they must be straight double-quotes).

Variable_name="&variable.";

Re: define the value of "Variable" based on proc macro

Tom — Mon, 09 Mar 2020 18:50:16 GMT

The macro processor ignores text in strings quoted using single quotes on the outside. Use double quotes instead.

	Variable_name="&variable.";