https://communities.sas.com/t5/SAS-Programming/Rewriting-similar-scripts-to-Macros-Testing-if-it-is-quot-right/m-p/749809#M235709 <P>I have 3 scripts (programs) (for three seperate countries) that are very similar and I have written a macro function that will replace them. So, in a "Main program", the three scripts were previously included with the %include statement, now I will just call the macro function instead which makes things much easier and more tractable.<BR /><BR />Each script produces six tables and so does my Macro.&nbsp;</P> <P>&nbsp;<BR />But, now when I have written the macro function, I must make sure that everything is right and would for instance like to run a seperate script (program) for a country and run my Macro for that specific country aswell and then compare that the six output tables are <STRONG>identical</STRONG>.&nbsp;<BR /><BR />How could I achieve this?</P> Wed, 23 Jun 2021 08:42:58 GMT SasStatistics 2021-06-23T08:42:58Z https://communities.sas.com/t5/SAS-Programming/Rewriting-similar-scripts-to-Macros-Testing-if-it-is-quot-right/m-p/749809#M235709 <P>I have 3 scripts (programs) (for three seperate countries) that are very similar and I have written a macro function that will replace them. So, in a "Main program", the three scripts were previously included with the %include statement, now I will just call the macro function instead which makes things much easier and more tractable.<BR /><BR />Each script produces six tables and so does my Macro.&nbsp;</P> <P>&nbsp;<BR />But, now when I have written the macro function, I must make sure that everything is right and would for instance like to run a seperate script (program) for a country and run my Macro for that specific country aswell and then compare that the six output tables are <STRONG>identical</STRONG>.&nbsp;<BR /><BR />How could I achieve this?</P> Wed, 23 Jun 2021 08:42:58 GMT https://communities.sas.com/t5/SAS-Programming/Rewriting-similar-scripts-to-Macros-Testing-if-it-is-quot-right/m-p/749809#M235709 SasStatistics 2021-06-23T08:42:58Z https://communities.sas.com/t5/SAS-Programming/Rewriting-similar-scripts-to-Macros-Testing-if-it-is-quot-right/m-p/749818#M235713 <P>You could use PROC COMPARE</P> Wed, 23 Jun 2021 10:27:50 GMT https://communities.sas.com/t5/SAS-Programming/Rewriting-similar-scripts-to-Macros-Testing-if-it-is-quot-right/m-p/749818#M235713 PaigeMiller 2021-06-23T10:27:50Z