topic macro is not creating the graphs in SAS Programming

macro is not creating the graphs

LOLO12 — Mon, 09 Oct 2023 20:42:42 GMT

Hi All,

this macro dosn't work not sure what is the issue.
%macro create_graph(_paramn=, _param=, _avision=, _trta=, _usubjid=);

data _null_;
set all;
where paramn=&_paramn. & param="&_param." & avision="&_avision." & trta="&_trta." & usubjid="&_usubjid.";
call symput('Int', put(intercept, BEST6.));
call symput('Slope', put(slope, BEST6.));
run;

proc sgplot data=all noautolegend;
where trta="&_trta." & usubjid="&_usubjid.";
title "Regression Line with Slope and Intercept";
reg y=aval x=accommodation_level;
inset "Intercept = &Int" "Slope = &Slope" /
border title="Parameter Estimates" position=topleft;
run;

%mend;

data test;
set all;
by paramn param avision trta usubjid NOTSORTED;
if first.usubjid then
do;
str=catt('%create_graph(_paramn=', paramn, ", _param=", param,
" , _avision=", avision, ", _trta= ", trta, ", _usubjid=", %str(usubjid),
');');
output;
end;
run;

Re: macro is not creating the graphs

tarheel13 — Mon, 09 Oct 2023 23:10:39 GMT

what does the log say?

Re: macro is not creating the graphs

Tom — Mon, 09 Oct 2023 23:33:37 GMT

You never call the macro in the code you posted.

You define a macro.

You create a dataset with a character variable that looks like perhaps it has the code to call the macro. But you never run the code you put into the character variable.

Re: macro is not creating the graphs

Sajid01 — Tue, 10 Oct 2023 13:30:54 GMT

Hello @LOLO12

Did you try the code before creating the macro?
Have a look at this blog post How to use PROC SGPLOT to display the slope and intercept of a regression line - The DO Loop (sas.com)
This will help you understand using Proc SGPLOT do what you want.