topic Re: Calling SAS code from another SAS program including passing variables? in SAS Procedures

Calling SAS code from another SAS program including passing variables?

shellp55 — Wed, 11 Jul 2018 13:28:57 GMT

Hello

I am using SAS 9.4.

I have a program called "regroup" that indicates the location of two sets of text documents plus an export file name as %let export_file:

Libname mylib 'C:\SAS Datasets';
filename M_regrp('C:\text data\monthly\.*txt';
filename Y_regrp('C:\text data\yearly\*.txt';
%let export_file="C:\sas_data.mdb";

I wish to call the regroup from another program and pass the 4 settings above from the other program. How do I do that? Thanks.

Re: Calling SAS code from another SAS program including passing variables?

Kurt_Bremser — Wed, 11 Jul 2018 13:46:52 GMT

Why would you handle something simple as that in an external include? It only obfuscates your code and makes life a misery for your future self.

Re: Calling SAS code from another SAS program including passing variables?

shellp55 — Wed, 11 Jul 2018 13:51:51 GMT

The report in question (regrp) is actually used for many hospitals and I have them all in the code and just comment out the sites I don't want at the time I run it. So rather than have multiple copies of regrp to call for each site from this other program, I thought it would be easier to call it from another program that I have to run that uses the resulting dataset from the regrp program.

Re: Calling SAS code from another SAS program including passing variables?

Kurt_Bremser — Wed, 11 Jul 2018 13:53:34 GMT

And what about those 4 statements should be parameterized?

Re: Calling SAS code from another SAS program including passing variables?

shellp55 — Wed, 11 Jul 2018 13:57:59 GMT

Not sure I know what you're asking but each hospital with have a different location for the file location of M_regrp and Y_regrp as well as different locations for the library name and the export_file. So I want to pass those to the report via the other report that calls the program.

Re: Calling SAS code from another SAS program including passing variables?

Kurt_Bremser — Wed, 11 Jul 2018 14:18:33 GMT

Define what the "settings" are in this sentence from your first post:

I wish to call the regroup from another program and pass the 4 settings above from the other program.

Re: Calling SAS code from another SAS program including passing variables?

shellp55 — Wed, 11 Jul 2018 14:28:15 GMT

The other program imports data from two locations and merges them, exports to a database and is saved to a specific library.

So I assume I would use %include to indicate the program I want to run, but I want to know how to identify the location of M_regrp and Y_regrp files, the library name to save the dataset to and the database to export the table to. Those are the settings being passed to the called report.

Re: Calling SAS code from another SAS program including passing variables?

Kurt_Bremser — Wed, 11 Jul 2018 15:21:49 GMT

So you would do something like

%let libpath=C:\SAS Datasets;

%include 'c:\.......\regroup.sas';

and regroup.sas would be

libname mylib "&libpath.";

Re: Calling SAS code from another SAS program including passing variables?

shellp55 — Wed, 11 Jul 2018 15:37:20 GMT

I wasn't sure about what you were advising but I found that all I needed to do was to copy the filename, libname and let statement for the database to above the %include line and it runs as it should. Thanks.

Re: Calling SAS code from another SAS program including passing variables?

Ksharp — Thu, 12 Jul 2018 14:10:58 GMT

If you have SAS/IML, you could try CALL EXECUTEFILE() .