Hi Team,   I have TWO Datasets      1) GRADE     2) ACCT   GRADE dataset is kind of a cross table. It tells the Severity -- between Grade values and Balance values   e.g: Grade=1 & BAL6=9000 -- then severity is VeryLow etc   data Grade; input Grade $ : 15. BAL1 $ BAL2 $ BAL3 $ BAL4 $ BAL5 $ BAL6 $ BAL7 $ BAL8 $ BAL9 $ BAL10 $; datalines; 0 2200 3500 5000 6250 7500 9000 10500 12500 15000 999999 1 VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow 2 VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow 3 VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow Low Low Low Low 4 VeryLow VeryLow VeryLow VeryLow VeryLow VeryLow Low Low Low Low 5 VeryLow VeryLow VeryLow VeryLow Low Low Low Low Low Medium 6 VeryLow VeryLow VeryLow Low Low Low Low Low Medium Medium 7 VeryLow VeryLow Low Low Low Low Low Medium Medium Medium 8 VeryLow VeryLow Low Low Low Low Low Medium Medium Medium 9 VeryLow Low Low Low Low Low Medium Medium Medium High 10 VeryLow Low Low Low Low Medium Medium Medium Medium High 11 VeryLow Low Low Low Medium Medium Medium Medium High High 12 Low Low Low Medium Medium Medium Medium High High High 13 Low Low Medium Medium Medium Medium High High High High 14 Low Medium Medium Medium Medium High High High High High 15 Low Medium Medium Medium Medium High High High High High 16 Low Medium Medium Medium High High High High High High 17 Low Medium Medium High High High High High High High 18 Medium Medium Medium High High High High High High High 19 Medium Medium High High High High High High High High 20 Medium Medium High High High High High High High High 21 Medium High High High High High High High High High 22 Medium High High High High High High High High High 23 Medium High High High High High High High High High 24 Medium High High High High High High High High High 25 Medium High High High High High High High High High ; run; data Acct; /*Mock Data */ input acctno Grade Balance; datalines; 111 1 20000 222 10 14550 9887 18 4065 ; run;   Now the WANT dataset should have new column TAG-- holding the Severity values.   acctno  Grade Balance   FLAG 111       1          20000      VeryLow 222     10          14550      Medium 9887   18         4065         Medium ; run;     Please advice. Thank You ... View more

I am new to CNTLIN and tried to make use of it and failed.   I have the following table ID, SSN and COMP_SSN and I have to create then new column MULTI_FLAG  Where the combination of SSN & COMP_SSN is repeated,  then the entire ID row has to be tagged as Y.   data DS_To_Flag; input ID SSN $ COMP_SSN $; datalines; 123 999 0 333 666 987 444 765 0 9996 987 0 876 8889 999 777 8889 0 ; run;   e.g: For the row where ID = 333 -> SSN of 666 is unique, while COMP_SSN of 987--- the same 987 does exist in SSN List...hence Multi_flag will be Y..   *Wanted Column -> MULTI_FLAG ID      SSN    COMP_SSN        MULTI_FLAG 123    999       0                             Y 333    666       987                         Y 444    765       0                            N 9996  987       0                            Y 876    8889     999                        Y 777    8889    0                            Y   I am trying to achieve this by CNTL... IF not please suggest the resolution in creating the new MULTI_FLAG   * I need the new flag column as Multi_Flag ... View more