Help using Base SAS procedures

Execution from Enterprise Guide in CMD

Reply
New Contributor
Posts: 4

Execution from Enterprise Guide in CMD

Hi all

I'm accessing remotely to a server (A), which has the Enterprise guide installed. In Enterprise Guide, I'm using a profile(connection) to a sas server in another machine(B), where are all the libraries.

The server(A) has the following installations:

Enterprise Guide 5.1 (64bit)

Integration Technologies Configuration

Manage Sas File Types

Install Qualification Tool

(sas_instalations.png)

(1)

I have developed a simple *.egp file in EG (A), which access a data-set, do a query builder transformation, and do a export step to a csv file in the server (A).

I have generated the VBS, and I'm trying to execute that in a Command Line Session, with the 64bit windows cscript and I'm having an error.

"Permission Denied"

C:\windows\system32\cscript.exe H:\Filipe_Vieira\DEVS\EGScript9.vbs ( this is the command I'm using)

(2)

I am now using a credentials.xml file, that's in the following location (according to sas troubleshooting page)

%allusersprofile%\SAS\SharedSettings\5.1\credentials.xml

the code of my credentials.xml is:

<xml FileVersion="5.1">

  <credentials>

  <server name="SASApp" userid="XXXXXX" password="{SAS002}1XXXXXXXXXXXXXXXXXXXXXXXXXCB"/>

  </credentials>

</xml>

(3)

I've built a egp file to pwencode my user password in a program, which i then use in the credentials.xml file. This is the code I'm using there:

proc pwencode in='MyPassword'; run;

(4)

I have debuged the problem a bit and found that the problem starts with a CreateObject statement. In the meanwhile, I have reduced my VBS code in order to contain the error origin and I am trying to run a simple code I found in the internet, with a simple CreateObject statement for SAS.

C:\windows\system32\cscript.exe H:\Filipe_Vieira\DEVS\EGScript1.vbs


EGScript1.vbs

'force declaration of variables in VB Script

Option Explicit

Dim Application

On Error Resume Next

Set Application = CreateObject("SASEGObjectModel.Application.5.1")

If Err.Number <> 0 Then

  WScript.Echo "Error: " & Err.Description

  MsgBox "Error: " & Err.Description

Else

  WScript.Echo Application.Name & ", Version: " & Application.Version

  Application.Quit

End If

I do not understand why this code isn't working and I'm running out of options to solve this, so I really could use some input from you guys

Apart this option is there any alternatives? How could i run my EGP file?

thanks in advance

New Contributor
Posts: 4

Re: Execution from Enterprise Guide in CMD

Just one aditional note. If i remove the credentials.xml from its place, I get the desired output in cmd line for EGScript1.vbs, however, I also get this strange pop up (attached)Untitled.png

Super User
Super User
Posts: 7,407

Re: Execution from Enterprise Guide in CMD

Speak to your IT support for this application.  Explain what you want to do.  They should be able to provide a solution.  It looks like you do not have access of a certain kind.  Why do you need to use VB script to run your project in the first place?  Is it scheduling, then your IT support should provide scheduling software and help you set it up.

Ask a Question
Discussion stats
  • 2 replies
  • 369 views
  • 1 like
  • 2 in conversation