topic Re: SAS code Trigger jar software in SAS Programming

SAS code Trigger jar software

ZHOUD — Sat, 25 May 2019 05:53:00 GMT

Hi, I have an external jar software which uses txt file as input and exports csv file. Previously I type command in command prompt to run the software but I want to automate this step in SAS. I generate txt input file in SAS and want to write sas code to trigger java software to take the input file and generate output. Can anyone help me with this step? Thanks.

Re: SAS code Trigger jar software

Kurt_Bremser — Sat, 25 May 2019 07:13:45 GMT

You can easily create csv files with SAS, and if there's additional logic in the Java code, pull it into SAS to get a more homogenous environment.

Re: SAS code Trigger jar software

ZHOUD — Sat, 25 May 2019 16:08:43 GMT

Yes, there is additional logic in java software need to be ran. Not sure if
I can see the java code because it's an external software. I did see your
other posts suggesting filename pipe code for jar file, but couldn't figure
it out. Thanks.

Re: SAS code Trigger jar software

Kurt_Bremser — Sat, 25 May 2019 16:19:20 GMT

Running software without knowing what it really does can come back to bite you in the behind.

Running an external command with filename pipe goes like this:

Get the command running from the command line, in the same context that your SAS session runs in.

Once that is done, create the following code:

filename oscmd pipe "command as you ran it 2>&1";

data _null_;
infile oscmd;
input;
put _infile_;
run;

the 2>&1 redirects error messages to the pipe, so you can see everything in the SAS log.

Please post your log here if you still have problems.

Re: SAS code Trigger jar software

ZHOUD — Sat, 25 May 2019 16:26:43 GMT

which part of the code can tell the java software to use the txt file I
create?

Re: SAS code Trigger jar software

Kurt_Bremser — Sat, 25 May 2019 16:34:30 GMT

Before you try to make your code dynamic, get it to run with literal values.

Maxim 34: Work in Steps.

Re: SAS code Trigger jar software

ZHOUD — Sat, 25 May 2019 17:35:52 GMT

Not sure if i fully understand the process.

Here is the command I put in the command prompt: java -jar abc.jar -i C:\Users\test_input.txt

so i just put the same command in SAS like this?

filename oscmd pipe "C:\Users\abc.jar, java -jar abc.jar -i C:\Users\test_input.txt 2>&1";

Re: SAS code Trigger jar software

Kurt_Bremser — Sat, 25 May 2019 18:14:34 GMT

So this is your command:

java -jar abc.jar -i C:\Users\test_input.txt

Then your SAS code needs to be

filename oscmd pipe "java -jar abc.jar -i C:\Users\test_input.txt 2>&1";

data _null_;
infile in;
input;
put _infile_;
run;

Post the log if it does not work as you intended.

Re: SAS code Trigger jar software

ZHOUD — Sun, 26 May 2019 02:15:11 GMT

Still doesn't work. I attached the log in the post, thanks.

Re: SAS code Trigger jar software

Kurt_Bremser — Sun, 26 May 2019 03:41:59 GMT

You get a Java exception; that has to be fixed on the Java side.

The SAS part works.

Re: SAS code Trigger jar software

ZHOUD — Sun, 26 May 2019 05:20:06 GMT

I figured it out. I missed your "in the same context that your SAS session runs in". I modified my code to

filename oscmd pipe 'cd redirect-path && java -jar "C:\Users\abc.jar" -i "C:\Users\test_input.txt" 2>&1';

and it works. Thanks for your help.