Read Output SAS

[arodriguez]

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

[LinusH]

Why do you want to validate macros, and how?

Please describe your requirement in more detail.

[arodriguez]

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.

[LinusH]

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...?

[arodriguez · Accepted solution]

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.