Proc append in macro

[Thalitacosta]

I have a macro that has proc append, when running once the output is perfect, but when changing the macro variables and running again the output of proc append that would have the same name is not created. How to fix this problem without having to disconnect the server?

%macro psi ([...]);

[...]

proc append data= dist_resul_&date. base=Result_DIST;run;

[...]

%mend psi;

%psi( [variables1] ); Here is the output "Result_DIST"!

%psi( [variables2] ); Here the output "Result_DIST" does not work!

[PaigeMiller · Accepted solution]

It's hard to tell, since you provide only a fragment of the actual macro. There could be many causes. Furthermore, @Thalitacosta when you say "does not work", you have not provided the slightest bit of evidence about what went wrong. We can't diagnose what went wrong when all you tell us is that it "does not work". Is there an error in the LOG? If so (now and in the future), show us the ENTIRE log for this macro. Please, from now on, be generous with information. Do not try to provide the absolute bare minimum information, as you have done.

One possible cause is that when you append to an existing data set, but the new data set has different variables, PROC APPEND fails. You can use the FORCE option to override this. There are many other possible causes...