topic Re: syscc doesn't get resolved. in SAS Programming

syscc doesn't get resolved.

GN0001 — Tue, 28 Mar 2023 23:04:25 GMT

%let email = ('bbbb@abc.com' 'dddd@abc.com' 'fff@abc.com');

filename mailit email;
options nosyntaxcheck;

%macro completeit;
  %if &syscc > 999 %then %do;
    data _null_;
      file mailit
           to=&email
           subject="&syscc.sas failed";

      put "This is an automated message that "&syscc.sas failed" failed with an error code &syscc..";
      put;
    run;
  %end;

  %else %do;

  data _null_;
     file mailit
          to=&email
           subject="job not completed";
            put ;
            put "&outdirectory.";
			put "==================";
			
    run;

  %end;

Program:

An email is created and sent over if the program succeeds. I don't have a log created for this code. This code is not resolved or opened in the log window.

Any help is appreciated!

Thanks,

Blue blue

Re: syscc doesn't get resolved.

SASKiwi — Tue, 28 Mar 2023 23:28:14 GMT

A SAS macro must start with a %MACRO statement and end in a %MEND statement. I don't see a %MEND statement in your code. However to call the macro you need to add the statement %COMPLETEIT; as well otherwise it will never get executed.

Try this:

%macro completeit;
  %if &syscc > 999 %then %do;
    data _null_;
      file mailit
           to=&email
           subject="&syscc.sas failed";

      put "This is an automated message that "&syscc.sas failed" failed with an error code &syscc..";
      put;
    run;
  %end;

  %else %do;

  data _null_;
     file mailit
          to=&email
           subject="job not completed";
            put ;
            put "&outdirectory.";
			put "==================";
			
    run;

  %end;
%mend;

%completeit;

Re: syscc doesn't get resolved.

GN0001 — Wed, 29 Mar 2023 16:50:54 GMT

Hello SASKIWI,

Wow, it is resolved! Thank you so very much. I needed to deliver the results of the program to leaders.

Thanks,

Bita

Re: syscc doesn't get resolved.

GN0001 — Tue, 02 May 2023 23:37:28 GMT

Hello team,

After a month, I came to run this code that mentioned on the start of this forum, it fails with error code 3000. While the program run correct, but the email message is created is a fail.

SYMBOLGEN:  Macro variable SYSCC resolves to 3000

I can't send the rest of the log, because it is confidential.

Regards,

blue

Re: syscc doesn't get resolved.

GN0001 — Wed, 03 May 2023 05:22:00 GMT

hello team,

I ran into same issue after a month.

I get &syscc to 3000.

I run the program line by line and no error in the log but as soon as I go to the part which I marked as answer, it gives me error code 3000.

regards,

a blue

Re: syscc doesn't get resolved.

ballardw — Wed, 03 May 2023 06:41:11 GMT

If the code was working correctly and the code was not changed then something else has changed. Possibly email addresses??? or stuff sent to the email system.

I might ask about changes to your system done by IT for any of the involved programs such as email.

If the code was changed, then you get start all over with the debug cycle.

Re: syscc doesn't get resolved.

Kurt_Bremser — Wed, 03 May 2023 09:15:51 GMT

Anything except zero is unnacceptable for SYSCC at the end of a job.

Any non-zero value means (at least) one of:

an ERROR has occured
a WARNING has occured
SYSCC was explicitly set (%LET, CALL SYMPUT, SELECT INTO)

You need to work through your whole log from top to bottom to fix any occurence of the above. If in doubt, add

%put &=syscc.;

frequently in your code to detect the location where something goes wrong (if it's not an obvious ERROR or WARNING).

Re: syscc doesn't get resolved.

GN0001 — Sun, 07 May 2023 23:30:35 GMT

Thanks,

I had a backup of the program so I used that one and I never realized what is the difference one works and one doesn’t work.
respectfully,

blue thunder