topic Read Output SAS in ODS and Base Reporting

Read Output SAS

arodriguez — Tue, 04 Feb 2014 09:55:34 GMT

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

Re: Read Output SAS

LinusH — Tue, 04 Feb 2014 11:24:23 GMT

Why do you want to validate macros, and how?

Please describe your requirement in more detail.

Re: Read Output SAS

arodriguez — Wed, 05 Feb 2014 07:56:31 GMT

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.

Re: Read Output SAS

LinusH — Wed, 05 Feb 2014 11:37:54 GMT

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

Re: Read Output SAS

arodriguez — Thu, 06 Feb 2014 08:28:09 GMT

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.