BookmarkSubscribeRSS Feed
Stephane
Quartz | Level 8
Hi
a little birdy suggested me to post here a question about the launch of a VBS in EG.

The question is simple perhaps naive but could I execute this data inside EG
1. if the session invoked is on the same machine than EG (personal computer with an EBI platform)
2. on a remote server

options noxsync noxwait xmin ;
data _null_;
x 'd:\stef.vbs';
run;

On my personal computer with EBI, this step leaves the session running and I have to kill the process.

Does EG not support OLE launch as DDE launch and I have no possibility to run that ?

stef.vbs :

option explicit

dim word 'the Word application
dim doc 'the Word document
dim selection 'text selection

set word = createobject("word.application")
word.visible = False
word.DisplayAlerts = 0
set doc = word.documents.add
set selection = word.selection
selection.typetext "An Automated Word Report"
selection.typeparagraph

doc.saveas("d:\zztestdoc.doc")

word.Quit

set word = nothing

Any idea ?

Edit : I can successfully execute x command like that
data _null_;
x 'echo "funstuff"> d:\temp\myfunstuff.txt';
run;

data _null_;
x 'mkdir d:\temp\hello';
run; Message was edited by: Stephane
2 REPLIES 2
Stephane
Quartz | Level 8
From me to me : you need a administrator user on the machine and then the vbs will be executed.
ChrisHemedinger
Community Manager
You might also check out this note:

http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Ente...

Chris
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1164 views
  • 0 likes
  • 2 in conversation