I have issues, where sometimes I submit a job and it'll error out, even though the code is fine. Hit submit again and everything runs fine.
Does anyone know why this occurs? And a workaround?
Desktop is SAS 9.2
Server is also 9.2
First time:
184 rsubmit;
NOTE: Remote submit to SERVER commencing.
506 proc sql;
ERROR 180-322: Statement is not valid or it is used out of proper order.
507 select count(*) from MY_TABLE.TABLE;
------
180
508 quit;
Second time:
186 rsubmit;
NOTE: Remote submit to SERVER commencing.
509 proc sql;
510 select count(*) from MY_TABLE.TABLE;
511 quit;
NOTE: The PROCEDURE SQL printed page 1.
NOTE: PROCEDURE SQL used (Total process time):
real time 6:21.47
cpu time 0.03 seconds
Probably something from the previous submission hanging out (a missing semicolon, who knows?).
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.