Hi All,    I really need help on writing this code as I am not sure on how to do it.     From my current dataset 1, I would like to filter these lists of reportable tax country (info in dataset 2). The tax country in current dataset 1 is available in 3 different columns (i.e. Tax1 to Tax3). I have multiple conditions such as customer declared as 1 tax country ranging up to 3 tax countries. I would need to identify all the 3 reportable tax country  (i.e. Tax1 to Tax3) and populate the required to tax countries into new columns and also the maintaining existing info for reference.   Required output will be in data set 3. Data set 3 comprise of: 1. Existing info in data set 1 from Cus_Name to TIN3 2. Column Tax1_New to TIN3_New - For these columns, information will only appear when Tax1 to Tax3 in data set 1 match Reportable_Cntry (data set 2). This includes the TIN (Tax Number).  3. TINIssuedby column - Will derive based on tax country that has TIN (Tax Number). If TIN is not available, TINIssuedby should be blank.    Anyone able to help on this scenario? Thank you for your help.    Sample: Data set 1: Current dataset   CUS_NAME TAX1 TAX2 TAX3 TIN1 TIN2 TIN3 CUSTOMER 1 SG GB HK S7777777F A123456Z C688688(0) CUSTOMER 2 SG HK   S7777667F C688666(0)   CUSTOMER 3 MY SG JP   S7777887F   CUSTOMER 4 AL     I05101999X     CUSTOMER 5 AR AU AT     88-888/9999 CUSTOMER 6 MY JP ID       CUSTOMER 7 TH US GM   777777777     Data set 2: List of Reportable Tax Country DATA REPORTABLE_CNTRY;  LENGTH REPORTABLE_CNTRY$2.; INPUT REPORTABLE_CNTRY; CARDS; AL AD AG AR AU AT AZ BB BE BR CA CL CN SG HK AU RUN;    Data set 3: Output   CUS_NAME TAX1 TAX2 TAX3 TIN1 TIN2 TIN3 TAX1_New TAX2_New TAX3_New TIN1_New TIN2_New TIN3_New TIN1_Issuedby TIN2_Issuedby TIN3_Issuedby CUSTOMER 1 SG GB HK S7777777F A123456Z C688688(0) SG HK   S7777777F C688688(0)   SG HK   CUSTOMER 2 SG HK   S7777667F C688666(0)   SG HK   S7777667F C688666(0)   SG HK   CUSTOMER 3 MY SG JP   S7777887F   SG     S7777887F     SG     CUSTOMER 4 AL     I05101999X     AL     I05909999X     AL     CUSTOMER 5 AR AU AT     88-888/9999 AR AU AT     88-888/9999     AT CUSTOMER 6 MY JP ID                         CUSTOMER 7 TH US GM   777777777                     ... View more

Hi. I have a large dataset that requires to spilt by cus_number. Planning to spilt into several dataset by every 100,000 of cus_number. there will be same cus_number in the dataset as the dataset contains transaction data too. any idea how i can spilt the data based on the above scenario? example: Cus_Number Trnx 1234 Trnx 1 (consider as 1st cus_number) 1234 Trnx 2 (consider as 1st cus_number) 2345 Trnx 1 (consider as 2nd cus_number) 2345 Trnx 2 (consider as 2nd cus_number) 2345 Trnx 3 (consider as 2nd cus_number) 3456 Trnx 1 (consider as 3rd cus_number) Many thanks for your help ... View more