I want to run sas script from (in a batch) from local command line. The problem is, that i want to connect to remote metadata server and run script there.
(In enterprise guide it is not problem because i can choose server from "code" menu)
But I don't know how to pass remote server connection information to sas.exe in command line. "sas.exe /?" doesn't show any help - it runs GUI.
I have created xml file with server connection information using some tool.
I suppose that this file should be passed to sas.exe altogether with sas script file.
Do you know how to do this?
I am newbie to sas. (a programmer forced to do someting in sas)
I suppose - when I start enerprise guide I can run script locally on localhost sas server. I can add remote machine (in Enterprise guide explorer) and then run scripts over tables on remote server. In the code menu, there is "select server" item. When I want to work with tables on remote server I choose remote server and run script. I think/thought that script is running on remote server.
I am trying to run some SQL based scripts.
The same case is in Data Integration Studio - I enter servername/port/user/pass/repository and can run script over those tables.
Basically, I need the same functionality as with SQL server - connecting with client to server and run script and get the results. In the terminology of SAS, the client is enterprise guide or data integration studio or sas.exe and I suppose that server is metadata server, database is repository.
If not, please correct me.
So in IDE (such as enterprise guide) I can click it and run ... and I need the same from command line with passing arguments/config to sas.exe. Something like "sas.exe -server asd -repository xyz -userid julo -pass pwd -script myscript.sas" or at least "sas.exe -config file.conf -script ,yscript.sas". But as I wrote "sas.exe /?" ir "sas.exe -h" doesn't work.