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;
Macro variables won't resolve inside single quotes.
Why won't double quotes work in the query?
"&state."
Macro variables won't resolve inside single quotes.
Why won't double quotes work in the query?
"&state."
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!!!!
I thought that would be it.
&peril._ULT_LR_R_UC
Thanks Reeza!!
It's working perfectly now
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.