topic Re: How to output a macro result to a specified .lst file? in New SAS User

How to output a macro result to a specified .lst file?

cosmid — Thu, 07 Apr 2022 20:14:58 GMT

For example,

If I have a program with two macros that print out month report and the other for quarter report:

%macro printmonth(mon);

print statements here;

%mend printmonth;

%macro printqtr(qtr);

print statements here;

%mend printqtr;

%printmonth(Jan);

%printmonth(Feb);

%printqtr(qtr1);

How do I create two different .lst files and name them as monthly.lst and quarter.lst? Currently, this program will create a single .lst file with the same name as the program.

Thanks!

Re: How to output a macro result to a specified .lst file?

ballardw — Thu, 07 Apr 2022 20:33:44 GMT

Something like

ods listing file="<path goes her>/filename";
%printmonth(Jan);
%printmonth(Feb);
ods listing close;

ods listing file="<path>/othername";
%printqtr(qtr1);
ods listing close;

Though I have a hard time understanding why anyone actually wants Listing output any more.

@cosmid wrote:

For example,

If I have a program with two macros that print out month report and the other for quarter report:

%macro printmonth(mon);

print statements here;

%mend printmonth;

%macro printqtr(qtr);

print statements here;

%mend printqtr;

%printmonth(Jan);

%printmonth(Feb);

%printqtr(qtr1);

How do I create two different .lst files and name them as monthly.lst and quarter.lst? Currently, this program will create a single .lst file with the same name as the program.

Thanks!

Re: How to output a macro result to a specified .lst file?

cosmid — Thu, 07 Apr 2022 21:03:08 GMT

I didn't know any other output file format from SAS that might work in UNIX so I picked .lst. The method worked! Thank you so much for your help!

Re: How to output a macro result to a specified .lst file?

ballardw — Thu, 07 Apr 2022 21:26:06 GMT

ODS PDF should work and would allow way more appearance controls. I expect you can create ODS RTF files though I don't know if you would have a program to display them.

@cosmid wrote:

I didn't know any other output file format from SAS that might work in UNIX so I picked .lst. The method worked! Thank you so much for your help!

Re: How to output a macro result to a specified .lst file?

cosmid — Fri, 08 Apr 2022 02:21:03 GMT

I have never tried either of them in UNIX environment. Once I have a chance I will give both a try and update you. Thanks again for showing me how to use the ods file statement. I learned about it before but didn't know I can use it straight up on a macro.

Re: How to output a macro result to a specified .lst file?

Tom — Fri, 08 Apr 2022 04:00:32 GMT

@cosmid wrote:
I have never tried either of them in UNIX environment. Once I have a chance I will give both a try and update you. Thanks again for showing me how to use the ods file statement. I learned about it before but didn't know I can use it straight up on a macro.

The macro processor is just a tool to allow you to generate SAS code. So you can use it to generate any valid SAS code that you want to generate.

Re: How to output a macro result to a specified .lst file?

cosmid — Fri, 08 Apr 2022 17:00:07 GMT

I have tried with RTF and PDF in the UNIX environment and it didn't work. It creates a file ending in .rtf and .pdf but once opened, they are just gibberish. Maybe I need to contact system admin for add-ons to open RTF or PDF files in UNIX? However, they both worked in SAS Windows. For me, the lst is sufficent and gets the job done.

Thanks again, now I learned how to create RTF and PDF in SAS Windows. I'm sure this will come in handy when I need it.