SAS 9.4 testing if Viya is available

TimCampbell — Thu, 26 Nov 2020 09:05:44 GMT

Hi everyone,

I have a cloud environment with a SAS 9.4 server and also a separate SAS Viya server for running visual analytics.

I want to have a process that:

Runs on the SAS 9.4 server to create the data table for my VA report.
Sends the data across to the Viya server.
Sends an email to alert users that the data is updated.

This is an example of the code I have so far for sending data to Viya.

cas casauto;

caslib _all_ assign;

proc casutil incaslib='MYCASLIB' outcaslib='MYCASLIB';

droptable casdata='Report_Table' quiet;

load data=Report_Table casout='Report_Table' replace;

promote casdata='Report_Table';

save casdata='Report_Table';

run;

The problem I have is that the Viya server is not turned on 24/7 at the moment so the process throws errors when it's down.

The long term solution will probably be that we need it up 24/7 in line with out prod SAS9.4 server however I would still want to come up with a plan for how to handle things if Viya is down for any reason.

Does anyone have any examples of code I could run to check if the viya envrionment is up before I try to send the data across?

Ideally my end goal will be that if Viya is down I want the 9.4 process to send the email saying it's down rather than just the alert that the new data is available.

Thanks in advance,

Tim

Re: SAS 9.4 testing if Viya is available

SASJedi — Mon, 30 Nov 2020 19:58:18 GMT

A little macro magic should do the trick:

%let CASSTMTERR=0;

cas casauto;

%if &CASSTMTERR ne 0
   or %index(%superq(SYSERRORTEXT),session failed) 
  %then %do;
  /* Connnection was not successful */
  %put NOTE: No connection made.;
     /* You could also termiante this job */
     /* endsas;*/
  %end;
  %else %do;
      /* Connection successful - do the work */
      caslib _all_ assign;
      proc casutil incaslib='MYCASLIB' outcaslib='MYCASLIB';
         droptable casdata='Report_Table' quiet;
         load data=Report_Table casout='Report_Table' replace;
         promote casdata='Report_Table';
         save casdata='Report_Table';
      run;
   %end;

topic Re: SAS 9.4 testing if Viya is available in SAS Programming

SAS 9.4 testing if Viya is available

Re: SAS 9.4 testing if Viya is available