BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,
We are currently using SAS 9.1.3 on our platform and planning to migrate to 9.2 very soon. I wanted to make sure about something thats in place today will work when we switch over to the newer version. So here are the details -

We have a task in place where it calls SAS.exe via command line. Essentially there is a batch file with a piece of code looking like this -

"C:\Program Files\SAS\SAS 9.1\sas.exe" "C:\sas_run\TEST.SAS"

Does 9.2 allow calling the sproc like this via command line?

Any inputs/thoughts?

Thanks,
Sudhir
4 REPLIES 4
Vince_SAS
Rhodochrosite | Level 12
Who determines how and when the batch file is executed?

Vince DelGobbo
SAS R&D
deleted_user
Not applicable
There is a scheduled database job running on MS SQL Server 2005 that executes a batch file sitting locally on the DB server. Based on some criteria (I guess you can call it business logic), it runs the batch file. This local batch file then uses PSEXEC to remotely execute another batch file sitting on the SAS Server.
deleted_user
Not applicable
Confirmed with SAS Support that there will be no issues to run the stored process via command line in 9.2. Just thought of updating it over here.
Vince_SAS
Rhodochrosite | Level 12
Yes, you can use the command you stated earlier, but be aware that you are not really running a stored process. What you are doing is executing the underlying SAS code in batch mode, under the userid that starts the process.

The success of this method depends on what the SAS code is doing.

We are researching ways to formally run stored processes, and may include that functionality in a future release.

Vince DelGobbo
SAS R&D

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1059 views
  • 0 likes
  • 2 in conversation