topic Re: Run program automatically without making manual changes every time? in SAS Programming

Run program automatically without making manual changes every time?

Walternate — Wed, 12 Jan 2022 20:47:50 GMT

Hi everyone,

I have a program which uses the macro variable &num to do a bunch of stuff (the purport of the program is not really relevant to my question). &num is set by hand.

I want to set up some automated runs of my program. I know how to do this, but my question is this: I'll be doing lots of runs of the program and changing &num each time (but not making any other changes). Is there a more efficient way to set this up than:

1. Make manual change to &num

2. Let automatic run happen as scheduled

And repeat this process for each new instances of &num?

Any help is much appreciated!

Re: Run program automatically without making manual changes every time?

PaigeMiller — Wed, 12 Jan 2022 21:15:08 GMT

Just one macro variable, that's all that changes?

What determines in your mind (not in SAS) what the value of &num will change to?

Re: Run program automatically without making manual changes every time?

Walternate — Wed, 12 Jan 2022 21:44:43 GMT

The program processes files and &num is in the file name.

Re: Run program automatically without making manual changes every time?

PaigeMiller — Wed, 12 Jan 2022 21:58:12 GMT

@Walternate wrote:

The program processes files and &num is in the file name.

I don't think this answers my questions.

Re: Run program automatically without making manual changes every time?

Reeza — Wed, 12 Jan 2022 22:29:25 GMT

@Walternate wrote:

The program processes files and &num is in the file name.

The generated file name? Or the input file name? Does it follow an increment schedule? Randomly assigned? Or magically assigned?

Re: Run program automatically without making manual changes every time?

ballardw — Wed, 12 Jan 2022 22:30:52 GMT

Where to do the "new instances of &num" come from? Are these values in a data set? Based on a calendar date? The phase of the moon? Armenian Fiscal Years?

Without knowing where values for &num come from there is no way this can be automated.

Re: Run program automatically without making manual changes every time?

Walternate — Thu, 13 Jan 2022 13:56:27 GMT

I receive input files to be processed by the program and &num is in the name of the input file, eg: Listing of files in directory &num.xlsx .

Re: Run program automatically without making manual changes every time?

PaigeMiller — Thu, 13 Jan 2022 14:15:03 GMT

So are you saying that you receive a file, here is a possible name of the file:

Listing of files in directory 16.xlsx

And then in your program you want to use 16?

Is this Excel file in a specific folder, where its name can be read by your program and parsed? Are there ever other Excel files in that folder?

Please explain the process by which this file is found in detail, rather than have us ask lots of questions. Don't be brief with your explanations, don't be stingy with information. We're trying to help you but you have to help us.

Re: Run program automatically without making manual changes every time?

Kurt_Bremser — Thu, 13 Jan 2022 17:11:39 GMT

SAS provides several ways to pick up data from the "outside".

You can add

-sysparm="string"

to the commandline and then use the SYSPARM function or the &SYSPARM automatic macro variable.

Or (and this is what schedulers do) set environment variables and retrieve those with the SYSGET data step function or %SYSGET macro function.

Script file (if on UNIX)

export NUMBER=16
sas program.sas

In the program,

%let number = %sysget(NUMBER);

will set the macro variable number to 16.

On Windows, use the set command in the batch file.