At a number of sites I've loaded data into CAS using Proc CASutil from a SAS 9.4 DI server. I've found that from time to time there are errors on the CAS side. While these appear in the SAS log they don't seem to throw an error condition at the SAS 9 side of things.
To work around this, I did exactly what you suggest "I'm thinking that I may have to parse the individual log files...but how?"
How? Well that's not too hard:
- Build a filename with a timestamp. This will become the log filename
- At the start of your job, assign the filename to a fileref
- Next use proc printto to redirect your log to the log file
- Do your processing
- At the completion of the processing, redirect the log back i.e. proc printto log=log;
- Parse the log...along the lines of:
*parse temp log;
data parselog;
infile CASLog eof = Done;
input;
put 'CAS Processing Log:' _Infile_ ;
if scan(left(_Infile_),1,':')='ERROR'
then do;
*error processing;
put "xxxxxxxxxxxxxxxxxxxxxxxx";
end;
run;
You could implement something similar in Viya:
1) build and test your job code in SAS StudioV, incorporate the log processing / error processing - you might want to code in an email step to alert you if you detect an error in the log.
2) create a job to call the code
3) schedule in Environment Manager
Mark
