topic Want to Include external SAS Statements into the sas code in SAS Programming

Want to Include external SAS Statements into the sas code

dkanand86 — Thu, 07 Apr 2016 22:10:33 GMT

Hi Everyone,

I want to include the sas statements stored in an external file (.sas) into another sas code.

However, when i submit following code on server, it gives error.

RSUBMIT;
/*%let MyProgramFolder = \serverlocation\SAS_UTILITY_FOLDER_NEW;*/
%include "./ED_MACRO_for_fillr_v1.sas" / lrecl=500;
ENDRSUBMIT;

ERROR:

ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.

Re: Want to Include external SAS Statements into the sas code

ballardw — Thu, 07 Apr 2016 22:20:42 GMT

You may be missing something in you %include file.

Try adding

options source2;

before the RSUBMIT to show the contents of the %include in the log and post the log. Post the results of the log.

Also between your comment and the %include there might confusion as the system you are running. The comment looks like Windows and the %include file looks like Unix or similar file system.

Generally it is a good idea to use a fully qualified path to the file as well.

Re: Want to Include external SAS Statements into the sas code

Reeza — Thu, 07 Apr 2016 22:29:34 GMT

If your running on the server, the server needs to have access to the file path, ie usually not your local C drive.

Re: Want to Include external SAS Statements into the sas code

Kurt_Bremser — Fri, 08 Apr 2016 06:24:53 GMT

RSUBMIT is a statement of the SAS/CONNECT package.

To use it, you must have a CONNECT session to a host active; a session is initiated with the SIGNON statement.

Documentation for SAS/CONNECT is found here: SAS/CONNECT 9.4 User's Guide