topic Re: Variable passed to Macro, needs single quotes. in SAS Programming

Variable passed to Macro, needs single quotes.

adamhyman — Mon, 14 May 2012 17:02:52 GMT

I have this SAS code which is not running, because in the where clause, my variables need to have single quotes around them and '&state.' causes an error.

Any help would be greatly appreciated!!!

%macro linreg(state, var);

data data_&state_&var;

set final_rva_5;

where st_cd eq '&state.' and

variable eq '&var.';

x = _N_;

run;

%mend;

DATA _NULL_;

SET linreg_state_variable_peril;

CALL EXECUTE('%LINREG('||linreg_state||','||linreg_variable||','||linreg_peril||');');

RUN;

Re: Variable passed to Macro, needs single quotes.

Reeza — Mon, 14 May 2012 17:06:08 GMT

Macro variables won't resolve inside single quotes.

Why won't double quotes work in the query?

"&state."

Re: Variable passed to Macro, needs single quotes.

adamhyman — Mon, 14 May 2012 18:03:42 GMT

Works like a charm! Thanks Reeza.

Can I ask you one more question....

What should I be using for &peril._ULT_LR_R_UC?

If I call it with linreg(total), I want the code to be model total_ULT_LR_R_UC = x.

%macro linreg(peril);

ods output 'Fit Statistics'=fit_statistics
'Solution'=ParameterEstimates;

proc glm data=linreg2_data;

model &peril._ULT_LR_R_UC = x;

weight &peril._EARNED_UC_PREMIUM;

run; quit;

ods output close;

%mend;

Thanks!!!!

Re: Variable passed to Macro, needs single quotes.

Reeza — Mon, 14 May 2012 18:11:55 GMT

I thought that would be it.

&peril._ULT_LR_R_UC

Re: Variable passed to Macro, needs single quotes.

adamhyman — Mon, 14 May 2012 19:26:12 GMT

Thanks Reeza!!

It's working perfectly now