topic Re: executing sas script from java application in SAS Programming

executing sas script from java application

satya_asam — Thu, 04 May 2017 19:36:22 GMT

Hi I have sas script, given by our sas bi team.

I am new to SAS.

I need to execute that script take the output and need to store on db.

can you help me on that.

Re: executing sas script from java application

PeterClemmensen — Thu, 04 May 2017 19:38:26 GMT

If you are running Base SAS, press F3 🙂

Re: executing sas script from java application

satya_asam — Thu, 04 May 2017 19:43:21 GMT

Thanks for your quick response draycut.

as of now I have only sas script with me, which is given by our SAS team. and this script will run in some other machine.I am not aware of the machine. I have only hostname ,port & user credential to connect to that machine.

I need to develop a java application to get the output of the given sas script.

please help.

Re: executing sas script from java application

SASKiwi — Thu, 04 May 2017 23:26:42 GMT

You need to ask your SAS team: "what is the SAS command line I need to execute to run the SAS script in batch mode". Once they provide that you simply embed that in your Java application. Running a SAS application in batch is just like running an OS command. You will of course have to logon to the SAS server first to run the job.

Dealing with the output will be more complicated. What type of output is the script producing? Text, HTML or something else?

Re: executing sas script from java application

satya_asam — Fri, 05 May 2017 14:54:47 GMT

Is there any JAVA code snippet available to connect to SAS servers and executing the sas script?