Hi everyone,
I'm trying to do some autovalidation of macros. My problem is that there are macros that export the result
in the SAS OUTPUT.
How can I read the SAS OUTPUT to check if it works?
Thanks for the help,
Antonio
Ok, I gonna redirect the output with proc printto to later import to a dataset of the information, and doing this, then I can use the proc compare to ensure
that the outputis like I want.
Why do you want to validate macros, and how?
Please describe your requirement in more detail.
To validate macros that have an output, I have a kind of template with the expected output, then I use
the proc compare to ensure that the output is correct. But I have a few macros that have output in SAS
Output, and I don't know how acced to the output to know if it have the correct format automatable way.
Still don't get the overall picture for this, are you testing the source data that is used to produce the results by the macro, or the macro itself?
If the later, it usually is sufficient to to this in manual manner.
Not knowing anything about the macros them self, on way is to test if you could redirect the output to data set using ODS.
Or, you could develop a subroutine (macro), that handles macro output in a centralized way...?
Ok, I gonna redirect the output with proc printto to later import to a dataset of the information, and doing this, then I can use the proc compare to ensure
that the outputis like I want.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.