topic Re: SAS Macro - Error submitted by using a PUT statement in SAS Programming

SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 09:53:43 GMT

Hi Everyone.

Lately I got to deal with the folliwing issue. I am wondering if there is any SAS inhabitant able to figure a way out of that. It's simple, but not easy.

This was the last practical question of the "SAS Certified Professional: Advanced Programming Using SAS 9.4".

Program:

%macro Test();
  %put ERROR: Do not print;

  proc print data=sashelp.cars;
  run;
%mend;

options /* **??** */;
%Test();

Log

The description was very clear:

"It's not possible to add anything else to the macro program. How do we make the program execute without errors?"

I am wondering if there is an option (on errors or macro) to avoid it. I already tried a few, but it still makes my brain wrecking.

Thanks. Regards.

Vittorio

Re: SAS Macro - Error submitted by using a PUT statement

PaigeMiller — Fri, 02 Oct 2020 10:02:49 GMT

I don't see a problem with your code or the results. SAS is doing exactly what the macro says it should do. The fact that the log contains an error statement is because you (or someone) programmed the macro to write

ERROR: Do not print

to the log.

So, what is the problem?

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 10:10:41 GMT

The macro program should execute the proc print and not show the error in the log!
Most likely there is an option for that.

Maybe there is no solution and the question was wrong!

Re: SAS Macro - Error submitted by using a PUT statement

PaigeMiller — Fri, 02 Oct 2020 10:26:59 GMT

But the macro specifically writes the text "ERROR: Do not print" to the log. That is the first line under %MACRO. That is what the macro was designed to do. If you don't want it to do that, change the macro. You are the programmer, you have complete control over what the macro does.

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 10:37:35 GMT

That was the exam question. "It's not possible to add anything else to the macro program".

If I modify the program, the evaluation points are ZERO.

I don't think you get the question.

Of course you can to modify the code. Here is not possible!!!!!!!!!!!!!!!!!!

We have a sort of constraint that I found myself bumping up against. Again: it's an exam question.

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 10:41:13 GMT

As I said, maybe that was a BUG of the exam. As far as I got from your answers, that's what you also think. Thanks

Re: SAS Macro - Error submitted by using a PUT statement

PaigeMiller — Fri, 02 Oct 2020 10:43:30 GMT

So we find ourselves in an absurd situation where the code doesn't do what we want, but we are not allowed to change the code.

By the way, when you say "It's not possible to add anything else to the macro program", I point out that the solution I am proposing, to remove the line of code that we don't want, does not ADD anything else to the macro program. It SUBTRACTS code from the program. Seems to me that is okay according to the directive: "It's not possible to add anything else to the macro program".

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 10:45:27 GMT

No, the program should be that. It can't be CHANGED, that's the meaning.

Re: SAS Macro - Error submitted by using a PUT statement

PaigeMiller — Fri, 02 Oct 2020 10:50:53 GMT

Then I choose to leave this discussion, as the exam question is absurd, and not worth more of my time. I wish you good luck in finding an answer.

Re: SAS Macro - Error submitted by using a PUT statement

RichardDeVen — Fri, 02 Oct 2020 11:43:25 GMT

The program is the entire source code. The macro program is the section of the macro code that defines the macro Test.

How do we make the program execute without errors?

The program is already executing correctly as coded without actual errors. The macro program has been coded to write a message (starting with ERROR:) to the log.

If the inferred task is to change the program but not the macro program would you go 'meta' and look at the macro %PUT message ? The message is telling you to DO NOT PRINT. Based on the 'meta' analysis I would say simply comment out the macro invocation.

%*Test();

No error message ! No printing !

Agree with @PaigeMiller "the exam question is absurd"

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 11:45:58 GMT

It is not allowed to modify the macro program.

Recalling that macro, the result should be:

1) no error message

2) proc print (from the sas program) prints

None of the exam answer was so dumb: there is an option or the question was wrong (it's not a new).

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 11:48:31 GMT

*
2) proc print (from the sas macro program) prints

Re: SAS Macro - Error submitted by using a PUT statement

PaigeMiller — Fri, 02 Oct 2020 12:08:16 GMT

"It's not possible to add anything else to the macro program. How do we make the program execute without errors?"

In SAS, highlight this part of the code and then just execute this:

  proc print data=sashelp.cars;
  run;

Thus, we haven't changed the program, every single line of the program still is intact, but we get the desired output.

If that is the correct answer, the person who created this question should be ashamed. And if this answer is correct, this defeats the purpose of having a macro, and it defeats the purpose of programming in general.

Re: SAS Macro - Error submitted by using a PUT statement

gamotte — Fri, 02 Oct 2020 12:25:49 GMT

Hello,

I completely agree with @PaigeMiller but i tried to find a solution anyway :

filename tf temp;

proc printto log=tf;
run;

%macro Test();
  %put ERROR: Do not print;

  proc print data=sashelp.cars;
  run;
%mend;

proc printto log=log;
run;


data errorless;
infile tf;
input;
retain out 0;

code=prxchange("s/^\d+ //",1,_INFILE_);

if strip(upcase(code))=:'%MACRO' then out=1;
if out and strip(upcase(code)) ne: '%PUT ERROR' then output;
if strip(upcase(code))=:'%MEND' then out=0;
run;

data _NULL_;
set errorless;
call execute(code);
run;

Re: SAS Macro - Error submitted by using a PUT statement

Quentin — Fri, 02 Oct 2020 12:29:23 GMT

I agree with others, it's likely an error in the question (or just a bad question).

Unless there is a system option to turn off %PUT statements (I don't think there is), I can't imagine what would be a good answer to this question.

Since it's apparently a question from a SAS book or online test prep guide, I'd recommend you submit it to the publisher as an erratum. I'd be curious how they respond, please let us know.

Re: SAS Macro - Error submitted by using a PUT statement

vittorio_giatti — Fri, 02 Oct 2020 13:23:35 GMT

This is a solution!! Probably a bit too much for the knowledge the candidate is expected to have, even the functions used are part of the exam, so it might be correct.

The way to highlight that part of the code and then execute it only, can't work in the exam @PaigeMiller .

That's because in the advanced programming exam, you save a sas program for each answer, and a macro program provided before evaluates your sas program returning a 3-digits code, which has to be insert as answer into a cell. So the whole program is compiled, leaving no possibility to highlight it.