sir.. you are taking it wrong and catching me literally in words. its language. . I am not too comfortable in expressing.. Anyways...background is i work for  infosys but am fresher...there used to be production code which did this flagging bit using base sas code. recently my client purchased DI studio and teradata. hence they want all this to be converted in  macro code which will be called in autoexec and there will only be 1 mapping in my DI job for flag column instea ... View more

?????? this is job assignment only. Its time difference buddy. it was 11 pm im india. anyways, I have couple more days to finish this.. ... View more

Trying so very hard but its not working out. I so hate nested loops in macros now. Will try with data steps tomorrow morning n see how it goes. In the mean time , I tried like this but its not working obviously.  Can you see where m going wrong %macro rules (table_name);   %local label1 label2 label3 condition ;   %local prev_label1 prev_label2 prev_label3 ;   %local table_id rc n first new_condition ; /* open the table */ %let table_id=%sysfunc(open(&table_name,i)); %if not &table_id %then %do;   %put Unable to open &table_name ;   %goto quit; %end; /* Link dataset variables to macro variables */ %syscall set(table_id); %let n=0; %do %while (not %sysfunc(fetch(&table_id)));   %let n=%eval(&n + 1);   %let first_label1=%eval( &n=1       or %superq(prev_label1) ne %superq(label1)           )   ; /* Build up new_condition and emit previous condition */   %if &first_label1%then %do;    % let first_label2=% eval (&first_label1 or %superq(prev_label2) ne %superq(label2) ); % let first_label3=% eval (&first_label2 or %superq(prev_label3) ne %superq(label3) );   %if (&n > 1 and &prev_label1 and &prev_label2 and &prev_label3) %then      %let new_condition=%trim(&condition)); %put new_condition is case when (&new_condition) ;   %end;   %else %let new_condition=&new_condition or (%trim(&condition)) ; /* Save values for next iteration */     %let prev_label1=%superq(label1);     %let prev_label2=%superq(label2);     %let prev_label3=%superq(label3); %end; %let rc= %sysfunc(close(&table_id)); %if (&n) %then %put new_condition is case when (&new_condition) ; %else %put No Conditions; %quit: %mend; %rules(have); Thanks a ton in advance ... View more

Hi Tom ,I was Using your code which you wrote in the other post... it seemed to be most suited for this requirement as well. I am sure that in your first if where you check for all labels with its previous values , we need three nested loops one below other .. some how I am unable to correct it. Please help me in understanding the logic for this... ... View more

Hi mkeintz.. hope that was the case. But nope , macro nested loop is the requirement. . Please help me guys... ... View more

Ya it was seeming difficult to explain... so here we go .... Input data new; input @1 label1 $ @3 label2 $ @5 label3 $1. @7 condition $; cards; a d p code1 a d p code7 a e q code2 a e q code3 b p   code4 b a r code5 d a r code6 ; run; Output : proc sql; create table op as select label1 , label2 , label3,condition, case label1 when 'a' then     case label2         when 'd' then         case label3             when 'p' then              case condition                 when 'code1' then 'y'                 when 'code7' then 'y'                 else 'n'             end         else 'n'         end         when 'e' then case label3             when 'q' then             case condition                 when 'code2' then 'y'                 when 'code3' then 'y'                 else 'n'             end                end         else 'n'         end        when 'b' then     case label2     when 'a' then          case label3         when 'r' then'y'         when '' then 'y' else 'n'         end     else 'n'     end when 'd' then     case label2     when 'a' then      case label3     when 'r' then'y'     else 'n'     end     else 'n'     end     else 'n' end as meta_flag from new ; quit; All my case statements has to be generated from Macro. I hope I am making it clear now... Please need help on solving this ... View more