Running SAS script using %include

Question

I'm newbie in SAS, coming from SQL, so I'm dealing with them differences.

I have a SAS program "Master.sas" that runs, among other things, something like this:

%include "c:\script1.sas";
%include "c:\script2.sas";
%include "c:\script3.sas";

The question is, if I select all of them and run it, does it run sequentially or in parallel? For example, if script2 uses a table that is loaded in script1, will it fail to run succesfully? Well, that example maybe sound obvious as I tested, but what happens if script1 calculate a variable, script2 will have the variable calculated or uses what it found at run time (because, for example, script2 has runned previously than script1)? Just to clarify, I need that SAS run them sequentially, one after other.

In SQL exists "GO" to separate batch processing, i.e.:

CREATE TABLE XXXXX
GO

SELECT * FROM XXXXX
GO

If someone tries to run that script with out GO, SQL runs them in parallel producing an error on the second script telling that "table XXXXX doesn't exist".

Do I need something similar in SAS or SAS just process next when the previous has finished?

Thanks in advance!

the files are going to be run in sequence. 1;2;3. here is details if you wan't to make it in parallel: communities.sas.com/t5/Base-SAS-Programming/… — n1tk
– n1tk, Commented Sep 19, 2016 at 19:34

Joe · Accepted Answer · 2016-09-19 22:15:45Z

%include will run things in sequence. SAS will run the first %include as if it were just lines in the code, then hit the second and do the same, etc.

SAS's equivalent of GO is RUN, by the by, though in most cases RUN doesn't actually have to be included (though it's considered a good practice). SAS will not run in parallel mode just because you leave out RUN, but it is what tells SAS to go ahead and run the code that was given it. This does not apply in PROC SQL, however; that does not support run-group processing, and instantly executes each statement terminated by ;.

There are ways to make it run in parallel; for example, this hands-on workshop from SUGI 29 on Parallel Processing shows how to use RSUBMIT to do so. Enterprise Guide allows for parallel processing of programs (but not %includes in one program) if you tell it to (but not by default).

Ankit Mishra · Accepted Answer · 2019-03-17 17:04:12Z

1

%include will run things in sequence. If your code in 1st %include hits an error then your program will stop and won't process other lines.

answered Mar 17, 2019 at 17:04

Ankit Mishra

214 bronze badges

Comments

gaurav2141 · Accepted Answer · 2019-06-06 07:24:40Z

1

%include will always run things in sequence.

If there is some variable being created in script1, then you can use the same in script2 but if script 1 is dependent of some variable being created in script 2, it will get error out.

answered Jun 6, 2019 at 7:24

gaurav2141

1301 silver badge10 bronze badges

Comments

abinash mishra · Accepted Answer · 2023-07-31 18:23:59Z

0

%inc statements will execute the sas codes in sequence. 1)same tables or variables being used in script 1 and script 2 then it will get updated. 2) tables from script1 will be used in script2 but those must be available in work or any permanent libraries.

answered Jul 31, 2023 at 18:23

abinash mishra

112 bronze badges

Collectives™ on Stack Overflow

Running SAS script using %include

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related