topic Re: PROC REPORT and Masking in SAS Procedures

PROC REPORT and Masking

dtchoi86 — Fri, 21 Oct 2016 13:40:09 GMT

Hello I am having trouble masking the following highlighted in yellow:

proc report data=safrptshell1 nowd
...;

compute groups;
if groups='OVERALL' then
do;
groups="Criteria (%nrbquote(Dummy = "Y"))";
call define (_col_, "style/merge", "style=[font_face=&font. fontstyle=italic]");
end;
else if strip(groups) in(...) then
do;
call define (_col_, "style/merge", "style=[font_weight=bold]");
end;
endcomp;

run;

I get the following error "ERROR 388-185: Expecting an arithmetic operator." It seems no matter what type of masking I try, the procedure unmasks the block of line before execution. Is there a way to quote/mask this?

Thank you!

Re: PROC REPORT and Masking

RW9 — Fri, 21 Oct 2016 13:44:39 GMT

At a guess, just put single quotes around it:

groups='Criteria (Dummy = "Y")';

Re: PROC REPORT and Masking

dtchoi86 — Fri, 21 Oct 2016 13:47:19 GMT

If I were to replace the dummy with a macro:
%let dummy = Dummy = "Y";

group = 'Criteria (&dummy)';

My guess is that this would not work? I should have been more clear - sorry. I would eventually like to put in a macro there.

Re: PROC REPORT and Masking

Tom — Fri, 21 Oct 2016 14:02:27 GMT

If you have control over the macro variable generation then it is not much of an issue.

%let group = Dummy='Y';
...
groups="Criteria (&group)";

If don't and the value of &GROUP might have double quotes then you can use QUOTE() function to make sure they are properly doubled up.

groups= %sysfunc(quote(Criteria (&group)));

Re: PROC REPORT and Masking

data_null__ — Fri, 21 Oct 2016 14:11:37 GMT

QUOTE function will properly quote DUMMY to produce the correct syntax.

%let dummy = dummy = "y";
data class;
   length sex $32;
   set sashelp.class;
   run;
proc report data=class;
   columns sex height;
   define sex / group;
   
   compute sex;
      if sex = 'M' then do;
         sex = %sysfunc(quote(Criteria(&dummy)));
         end;
      endcomp;
   run;