BookmarkSubscribeRSS Feed
Jaheuk
Obsidian | Level 7
dear all,
to use an update/insert in SAS SQL you have to specify UNDO_POLICY=OPTIONAL or NONE
But because of this i get a WARNING in the log and on mainframe this
gives a RETURN CODE 4!
HoW can i push this RC to 0 (zero) in the SQL or with an extra data step to tell OPC the job is ok??

Regards,
Herman
1 REPLY 1
DanielSantos
Barite | Level 11
Force the system macro variable SYSCC to the value you want.

Ideally you should save its value BEFORE executing the SAS SQL then restore it after.

%let _SYSCC=&SYSCC; * save SYSCC;

...

%let SYSCC=&_SYSCC;

Be aware that this will mask any type of error occurred between the two %let.

Check the online doc: http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/tw3514-syscc-var.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

hackathon24-white-horiz.png

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.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1207 views
  • 0 likes
  • 2 in conversation