Each macro submission, new plots with different names are created

[trungdungtran]

Hi,

I am trying to use ODS combining with macro to save png plots. The first time I submit the following codes:

%Let param1=Intercept;
%Let param2=x;
/* Save png */
%macro m_hist;
	%Do para=1 %to 2;
	Ods graphics / imagename="&&param&para" imagefmt=png;
	Proc univariate data=combination;
		Title "Histogram of &&param&para";
		Where Variable="&&param&para";
		Var Estimate;
		Histogram Estimate/ odstitle="Histogram of &&param&para";
	Run;
	%End;
%mend;
%m_hist;

I get two files Intercept1.png and x1.png.

This is unusual since I set the names without number 1 at the end.

I submit the macro program again, %m_hist;, this time I get Intercept3.png and x3.png. The third time I submit I get Intercept5.png and x5.png.

That is not what I expect. Do you have any idea?

Thanks for reading!

Kind regards,

Trung Dung.

[VDD]

that is because of this statement:

%Do para=1 %to 2;

so you are getting the results that are specified.

[trungdungtran]

Hi @VDD,

I think the file names are fixed as &&param&para is resolved as "Intercept" when i=1 and "x" when i=2. Could you explain more?

[VDD]

the do loop is setting &para.

[PGStats · Accepted solution]

The numbers at te end if file names have nothing to do with your macro. They are added by the ODS to avoid overwriting existing files as explained here:

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_odsgraph_sect036.htm&docsetVersio...

Change your statement to

Ods graphics / imagename="&&param&para" imagefmt=png reset=index;

to force overwriting.

[trungdungtran]

Yes, the option "reset=index" solves the problem!

Thank you @PGStats.