topic [Problem] Launch a VBS script from SAS Ent. Guide in SAS Enterprise Guide

[Problem] Launch a VBS script from SAS Ent. Guide

deleted_user — Mon, 29 Mar 2010 07:44:36 GMT

I tried to launch a script VBs from a SAS Ent Guide project.

I follow the instruction mentionned here : http://support.sas.com/kb/13/501.html

-- -- --
data _null_;
X "E:\SITE.vbs"
run ;
-- -- --

So, I created a CODE and pasted the lines here upper but I get a message error from SAS which is :

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code);
4 %LET _EGTASKLABEL=%NRBQUOTE(Code);
5 %LET _CLIENTPROJECTNAME=%NRBQUOTE();
6 %LET _SASPROGRAMFILE=;
7
8 ODS _ALL_ CLOSE;
NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these
drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support.
9 OPTIONS DEV=ACTIVEX;
10 FILENAME EGHTML TEMP;
NOTE: Writing HTML(EGHTML) Body file: EGHTML
11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=EGDefault
11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared%20Files/BIClientStyles/EGDefault.css")
11 ! ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v91/sasgraph.exe") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation
11 ! ;
12
13 %gaccessible;
14
15
16
17
WARNING: Shell escape is not valid in this SAS session.
18 data _null_;
19 X "E:\SITE.vbs"
20 run
20 ! ;
21 /*quit;
22 run ;
23
24
25
26 %LET _CLIENTTASKLABEL=;
27 %LET _EGTASKLABEL=;
28 %LET _CLIENTPROJECTNAME=;
29 %LET _SASPROGRAMFILE=;
30
31 ;*';*";*/;quit;run;
____
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

32 ODS _ALL_ CLOSE;
33
34
35 QUIT; RUN;
36

Any idea from where comes the problem ?

Thank you in advance

Re: [Problem] Launch a VBS script from SAS Ent. Guide

andreas_lds — Mon, 29 Mar 2010 10:05:16 GMT

Have a look at the note: http://support.sas.com/kb/14/619.html.

Re: [Problem] Launch a VBS script from SAS Ent. Guide

deleted_user — Mon, 29 Mar 2010 13:54:32 GMT

> Have a look at the note:
> http://support.sas.com/kb/14/619.html.

Thanks 😉
I know now why it's blocking but I don't know how to deblock it 😕

The following warning may be displayed when attempting to remote submit
an X command when the -NOXCMD option has been specified:

Warning: Shell escape is not valid in this SAS Session.

If a script file was used to initiate the SAS/CONNECT SIGNON, make sure
the -NOXCMD option was not specified on the SAS invocation statement.

How can I change it ?
Where can I find the SAS invocation statement to modifiy it ?
Thank you in advance.

Message was edited by: Fab.from.be Message was edited by: Fab.from.be

Re: [Problem] Launch a VBS script from SAS Ent. Guide

deleted_user — Mon, 29 Mar 2010 18:00:06 GMT

For security reasons, I'm not able to use this command ...

:/

Re: [Problem] Launch a VBS script from SAS Ent. Guide

RichardH_sas — Wed, 07 Apr 2010 14:16:19 GMT

See the following note about using the x command within EG. You're right, by default it's turned off.

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

If you're working with EG locally but SAS installed on a server, you'll have to petition your SAS administrator to allow the x command on the server. Good luck: there are definite security risks posed by enabling x commands so the admin may say "no". If you have EG and SAS installed locally, the note above should give you a starting point for enabling x commands.

Re: [Problem] Launch a VBS script from SAS Ent. Guide

deleted_user — Fri, 09 Apr 2010 06:49:02 GMT

I confirmed, it is turned off and will stay like this but ...

Is there a way to "run" the VBS through another way ?

One of my colleague told my about an hyperlink link that point to the VBS ?

So I would get out of SAS Guide, just to launch it and get back just after but this solution will offer me the opportunity to get everything in my SAS project.

For the moment, I do need to launch SAS, then go in the explorer and launch the VBS and get back to SAS.

What I will appreciate is to "control" (get) everything whithin SAS project.

Do you see a way to integrate such a thing ?

Thank you in advance !