topic Re: %macro? in SAS Data Management

%macro?

ybz12003 — Thu, 18 May 2017 15:45:22 GMT

Hi, all:

I saw several codes written from previous programmer. Could someone let me know what they are refering to? Thanks.

%including "file-specification"/source2;

%rename (uned., _3);

%including "file-specification"/source2;

%state (uned., _4);

%including "file-specification"/source2;

%report (uned., _5);

Re: %macro?

ybz12003 — Thu, 18 May 2017 15:55:08 GMT

I specify the %including code:

%including "\\test\_3_rename.sas"/source2;

%rename (uned., _3);

%including "\\test\_4_state.sas"/source2;

%state (uned., _4);

%including "\\test\_5_report.sas"/source2;

%report (uned., _5);

Re: %macro?

RW9 — Thu, 18 May 2017 15:59:04 GMT

I don't think that is the exact code is it. The first:

%including "file-specification"/source2;

Is not correct, correct syntax is:

%include "file-specification" / source2;

This loads the given text file and inserts the text at the point of include.

The other three are calls to user built macros. As I am not on your system, can't see any of it, I cannot state anything other than that.

Re: %macro?

Kurt_Bremser — Thu, 18 May 2017 16:00:46 GMT

You should post the real code you have questions about. "%including" is not valid SAS syntax.

That said, %include tells SAS to fetch the file and place its contents where the %include was.

The other lines seem to call macros from those files.

Re: %macro?

ybz12003 — Thu, 18 May 2017 16:02:11 GMT

Yes. I apologize my typo. It's %include.

Re: %macro?

Jagadishkatam — Thu, 18 May 2017 16:04:32 GMT

It is one way of using the macro calls (sas programs) which are located in some location and you want to use them in your current program.

%include is used to refer to the location where the macro program is located and source2 causes the SAS log to show the source statements that are being included in your SAS program.

%rename is the macro call which is being referred in the %include statement.

But i wonder why the %include statemnet has the sas program name as _3_rename.sas and %macro call name is %rename I am expecting the %include should refer to the rename.sas programs file.

Re: %macro?

ballardw — Thu, 18 May 2017 17:01:50 GMT

@Jagadishkatam wrote:
But i wonder why the %include statemnet has the sas program name as _3_rename.sas and %macro call name is %rename I am expecting the %include should refer to the rename.sas programs file.

@Jagadishkatam I've seen file naming conventions like that when they were used to indicate the Order that scipts or programs should be run. I'm not saying it's a good practice but I've seen that.

Re: %macro?

ybz12003 — Thu, 18 May 2017 17:32:12 GMT

Hi,

If %rename is the macro call which is being referred in the %include statement. It shouldn't be use semicolom, it should be just

%rename

Am I right?

Re: %macro?

Jagadishkatam — Thu, 18 May 2017 17:40:36 GMT

you can always call macro calls either with or without semicolon