I am trying to send/receive messages to a row MQ using SAS Studio
Configure in SASStudio JVM CLASSPATH an ActiveMQ library, however, when executing error code "ERROR 23-2: Invalid option name URL", which appears to be pq or SASStudio does not describe JMS.
CODE:
data _null_;
file 'myqueue' activemq url='http://localhost:8161/api/message'
user=admin pass=admin;
format a datetime21.1;
a = datetime(); put a ' Testing: 1 2';
a = datetime(); put a +1 'This is a test. 3 4';
a = datetime();
put a @22 'This is only a test. 5 6';
run;
ERROR:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 data _null_;
74 file 'myqueue' activemq url='http://localhost:8161/api/message'
___
23
ERROR 23-2: Invalid option name URL.
75 user=admin pass=admin;
____
23
ERROR 23-2: Invalid option name USER.
75 ! user=admin pass=admin;
____
23
ERROR 23-2: Invalid option name PASS.
76 format a datetime21.1;
77 a = datetime(); put a ' Testing: 1 2';
78 a = datetime(); put a +1 'This is a test. 3 4';
79 a = datetime();
80 put a @22 'This is only a test. 5 6';
81 run;
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.01 seconds
82
83
84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
97
Kindly note this example is for 9.4 platform which is based on Apache ActiveMQ. However Viya uses RabbitMQ. I am sure there would be differences between the two.
I would suggest you to raise a TS track to get idea on how to do the same for Viya.
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
