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.
Each script produces six tables and so does my Macro.
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 identical.
How could I achieve this?
You could use PROC COMPARE
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Explore Now →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.
Ready to level-up your skills? Choose your own adventure.