topic Re: Printing sas macro contents in output window in SAS Programming

Printing sas macro contents in output window

AJ_Brien — Mon, 30 Sep 2019 22:05:04 GMT

Hello,

I'm trying to figure out a way to display the contents of a macro function into the sas output window instead of the log window.

this is just a sample, just trying to understand a concept here. I know we can use put and %put for variables and macro variables, but what can we do to display the contents of a macro function stored in a remote unix location in the output window instead of the log file. Thank you for your guidance 🙂

Below is the sample code:

options mautosource sasautos = ('unix path location for macro')  
                               nocenter source2 mlogic symbolgen mprint;

%include 'unix path location for macro/checkk.sas';

data _null_;
title 'macro details:';
put z = %checkk;
title;
run;


Details in macro checkk:

File name is checkk.sas
%macro checkk;
a=1 or b=3
%mend;

Re: Printing sas macro contents in output window

Reeza — Mon, 30 Sep 2019 22:14:56 GMT

Maybe PROC ODSTEXT, but you may need a proc to trigger the output. At least ODS TEXT did.

A workaround is to push the data to a data set and PROC PRINT/REPORT on the data set to the results viewer.

Re: Printing sas macro contents in output window

AJ_Brien — Mon, 30 Sep 2019 22:45:34 GMT

thank you for your reply.

the macro will most likely contain a bunch of conditions, such as if %checkk then delete; will be the kind of condition used. So I'm not sure if i can push that into a dataset. I tried working around odstext, but looks like it requires 'P' to be added before each line in the macro. That will be an issue if I end up using this with multiple macros in the future.

The main purpose of doing this exercise is to be able to see what the macro in the remote location consists of without going out of the way and opening that file through winscp or another software.

Re: Printing sas macro contents in output window

Reeza — Mon, 30 Sep 2019 22:48:26 GMT

Sorry, I don't understand what you're trying to do then. Good Luck!

Re: Printing sas macro contents in output window

ballardw — Mon, 30 Sep 2019 23:21:56 GMT

It may help if you show something that actually should create some output and what you would expect to appear in the output destination.

Since your "example" output for the data step is basically a bunch of uninitialized variables it doesn't make much sense

And is the macro itself supposed to provide the output???

I don't understand your comment about the P statement of Proc Odstext other than in that context:

If I run:

%macro checkk;
a=1 or b=3
%mend;

proc odstext;
p "%checkk";
run;

The results window shows

a=1 or b=3

Re: Printing sas macro contents in output window

AJ_Brien — Mon, 30 Sep 2019 23:28:35 GMT

ah I see what you did here. This is what I was looking to see how to use. Thank you!