Error handling using macro variables

[FatCaptain]

Hi,

I'm trying to generate a variable in SAS which shows whether the code has run without any errors.

The main body of the code is run on the server using an rsubmit command. The error variable needs to be available locally on my pc.

The code is very simple as it just backs up some SAS datasets e.g.

rsubmit;

data dataset_backup ;
set  dataset ;
run ;

data dataset2_backup ;
set  dataset2 ;
run ;

endrsubmit;

I've been playing around with &syserr and &_efierr_ to obtain an error flag and %sysrput to get the variable on the server to the local machine.

Once I have this error flag on the local machine, I would like to use it to alter the contents of an automated email as shown in this thread;

http://www.tek-tips.com/viewthread.cfm?qid=1607439&page=1

e.g.

*If the code has no errors;
%if &localerrorvar = 0 %then %do;
put '.Subject = "Files backed up successfully"';
%end;
*If the code has fallen over or has errors;
%if &localerrorvar = 1 %then %do;
put '.Subject = "FILE BACKUP ERROR"';
%end;

Any help with this would be appreciated!

Cheers,

FatCaptain.

 

[klaz2002]

Can't you have the server send the email? If it can then your error macro var can be used.

Another way you can do this task is to write the error (or lack of error) to a text file and then have the local sas read that text file in. Of course you would have to use a timestamp type of file name so that mult. runs of the same code don't overwrite each other.

Have you tried the %sysrput macro statement. This statement will allow a value generated in the Remote session(server) to be available in the client session. You could set the error code to that macro var and have the client 'see' that value.

Klaz