Two IF statements within a BY statement

kk89 — Thu, 12 Jan 2023 04:30:29 GMT

How do two or more if statements work within a By statement. I was looking at the macro suppress in this link: https://blogs.sas.com/content/sgf/2016/04/13/automatic-data-suppression-in-sas-reports/

(and also below) and I found that once the code in blue ran, the macro ran the code in green. It almost seemed like a loop.

%macro suppress(dsname=,supclass=);
 
   proc sort data=&dsname;
      by &supclass count;
   run;
 
   %let sup_flag = 0;
   data &dsname (drop=_supnum_);
      set &dsname;
      by &supclass count;
      if first.&supclass then _supnum_ = 0;
      if (1 le count le &sup_max) or (_supnum_ eq 1 and count ne .S) then
      do;
         count = .S;
         call symput('sup_flag','1');
      end;
      if (count eq .S) then _supnum_ + 1;
   run;
 
%mend suppress;

Re: Two IF statements within a BY statement

Tom — Thu, 12 Jan 2023 05:29:57 GMT

The IF statements are not "within" BY statements.

The first IF statement is taking advantage of the fact that when using a BY statement SAS will create flag variables that will indicate if the current observation is the first or last in the current BY group. So it resets the counter variable the data step is creating to zero when a new group starts.

Your guess on the second IF statement is going to be better than mine. Especially since it is referencing a macro variable, SUP_MAX, that you have not defined anywhere. (Programming hint: Do not use "magic" macro variables in macro code. That is a macro variable that is suddenly used by the macro but has never been defined by the macro and is not an input parameter of the macro. At the very least add a comment at the top of the macro stating that the macro will be using this externally defined macro variable.)

topic Re: Two IF statements within a BY statement in New SAS User

Two IF statements within a BY statement

Re: Two IF statements within a BY statement