I have a code to simply delete record and then insert records. I don't get any error but got a warning of
"WARNING: Character expression will be truncated when assigned to character column LOB_CD." which should not make job to fail.
makes failed my job. Why?
PROC SQL;
DELETE FROM xx.xx;
DELETE FROM xx.xy;
QUIT;
PROC SQL;
INSERT INTO xx.xx SELECT * FROM ZZ.XX;
INSERT INTO XX.XY SELECT * FROM ZZ.XY;
QUIT;
On the Autosys environment the Success/ Failure criteria are defined by how you handle the sas return codes.
Typically on a Unix / Linux environment post execution this code would give you a return code 1 due to the warning. You may handle this return code from the Shell script( in case you are using any ) to mark this job as success despite the warning.
However, I would highly recommend to correct this warning as it appears that there is a type mismatch while inserting the data from your Proc SQL Insert.
On the Autosys environment the Success/ Failure criteria are defined by how you handle the sas return codes.
Typically on a Unix / Linux environment post execution this code would give you a return code 1 due to the warning. You may handle this return code from the Shell script( in case you are using any ) to mark this job as success despite the warning.
However, I would highly recommend to correct this warning as it appears that there is a type mismatch while inserting the data from your Proc SQL Insert.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.