topic Re: How to interpret and implement %include statement in SAS Studio

How to interpret and implement %include statement

avecesar97 — Fri, 03 Apr 2020 15:32:41 GMT

I have the following code which takes variables from two datasets and then uses it to form a new table

%let msevars=ticker ncusip shrcd exchcd; %let msfvars = prc ret retx shrout cfacpr cfacshr; /* variables from the first dataset */

%include '/wrds/crsp/samples/crspmerge.sas'; /* second dataset*/

%crspmerge(s=m,start=01jan1959,end=30jun2011, sfvars=&msfvars,sevars=&msevars,filters=exchcd in (1,2,3));

I have been trying to replicate the %include statement for the crspmerge dataset that I have saved in my myfolders like this:

%include '/folders/myfolders/comp/merged.sas7bdat';

but I get this error "Maximum level of nesting of macro functions exceeded".

Am I using the statement wrong, if not, is there a different way to do this procedure without using macro variables . I am a noobie in sas so be patient with me 🙂

Re: How to interpret and implement %include statement

Tom — Fri, 03 Apr 2020 15:52:16 GMT

A %INCLUDE statement is for included lines of CODE. Not a dataset.

Having an include followed by a macro call to a macro with same name as the file that was included makes it look like that file just has the MACRO definition. I would be surprised if that file had any code that defined any datasets.

Re: How to interpret and implement %include statement

ballardw — Fri, 03 Apr 2020 15:57:42 GMT

Do you mean that you are attempting to USE the data set? Or something else, if so what?

Re: How to interpret and implement %include statement

Quentin — Fri, 03 Apr 2020 16:01:31 GMT

Hi,

It looks like crspmerge.sas defines a macro, perhaps https://github.com/jcizel/WRDS-SAS-UTILITIES/blob/master/wrdsmacros/crspmerge.sas or http://people.stern.nyu.edu/jhasbrou/ftp/sasmacros/crspmerge.sas.

You are justifiably confused because the comments in the code are wrong:

%include '/wrds/crsp/samples/crspmerge.sas'; /* second dataset*/

The purpose of the %INCLUDE statement is to execute the code in the program crspmerge.sas. That code does not create a second dataset. It compiles a macro named crspmerge. After the macro has been compiled, you can call the macro, and the macro will write some output datasets. The macro has a number of dependencies that are not clearly defined, for example it expects certain data tables to exist in the directory /wrds/crsp/sasdata/.

You should not need to create macro variables in order to use the macro. In order to use the macro, you need to compile the macro (which means you must run the code in crspmerge.sas). One way to run that code is to use %INCLUDE.

So you should be able to run the macro like:

%include '/wrds/crsp/samples/crspmerge.sas';  /*Execute crspmerge.sas to compile the macro CRSPmerge*/

/*now call the macro*/
%crspmerge(s=m,start=01jan1959,end=30jun2011, sfvars=prc ret retx shrout cfacpr cfacshr,sevars=ticker ncusip shrcd exchcd,filters=exchcd in (1,2,3));

I hope that helps. Getting started with macros is hard. And if your first time trying to use a macro is to run a complicated macro like this, written by someone else, and not well-documented, that makes it harder.

One suggestion is to turn on options MPRINT and SYMBOLGEN and MLOGIC before you call the macro. That will write helpful debugging info to your log.

Good Luck.