BookmarkSubscribeRSS Feed
Bridget53
Calcite | Level 5

I am trying to executing SAS code in batch mode using Powershell to kick it off.  Within the powershell code we assign the code to a variable call $SAS_APPLICATION_LOCATION and the code we are trying to assign to it as shown which the version that is use in a batch file:

"C:\Program Files\SAS\SAS 9.1\sas.exe" -sysin "E:\Propagator Import\Export PACS test data.sas" -fullstimer -ALTLOG "E:\codeshare\"

We are using the following to run the execute this job:

$ApplicationOutput = cmd /c $SAS_APPLICATION_LOCATION

We could not get it to work but we did get it work using Ping with one of our server.

Do anybody have any experience running SAS code in batch mode using PowerShell?

Thanks for your help in this matter.

2 REPLIES 2
ScottBass
Rhodochrosite | Level 12

Hi,

I'm only just starting to investigate this same thing, so my answer is not only belated (I only just saw your post) but half-baked as well.

Having said that, this works for me:

pushd "$env:userprofile\My Documents\My SAS Programs"

$cmd="C:\Program Files\SAS\SASFoundation\9.2\sas.exe"
$cfg="C:\Program Files\SAS\SASFoundation\9.2\nls\en\SASV9.CFG"
$pgm="test1.sas"

cmd /c " ""$cmd"" -config ""$cfg"" -sysin ""$pgm"" "

# I also tried all of these, since I do not want to use cmd /c if at all possible
# But, they do not properly set the $LastExitCode from SAS

# Start-Process "$cmd" "-config ""$cfg"" -sysin ""$pgm"" " -Wait 
# Start-Process "$cmd" "-config ""$cfg"" -sysin ""$pgm"" " -Wait -PassThru
# Start-Process "$cmd" "-config ""$cfg"" -sysin ""$pgm"" " -Wait -NoNewWindow

"LastExitCode=$LastExitCode"

popd

I've also posted here to try and get further help:  http://www.powershellcommunity.org/Forums/tabid/54/aft/7999/Default.aspx

But like I said, the above works for me.

Regards,

Scott


Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.
ljin0599
Calcite | Level 5

Thanks a lot.

It is good to know we have to add Start-Process before call sas.exe

 

Did anyone try call SAS EG Project from PowerShell? 

I tried, but it only pops up EG window, not execute the Project Flow,

wondering what is the trick(or option) I have to give here?

 

Lynn

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 2 replies
  • 3930 views
  • 1 like
  • 3 in conversation