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.
Catch up on SAS Innovate 2026
Dive into keynotes, announcements and breakthroughs on demand.
