I have imported the file and kept only the Text column, which is made up of a text blob. One row is pasted below. I want to move the numbers after the word 'ORIG:' in bold below to there own data set so i can count how many characters they are.    Any help will be appreciated.     WIRE TYPE:BOOK OUT DATE:013018 TIME:1716 ET                 TRN:2018013000426338                                        FED IMAD:                                                   RELATED REF:9796E9BF1D3F7440                                ORIG:ECE2D1F0F6D04FEC80363791807F ID:                       BNF:      BNF BK: ID:                                                 INT BK: ID:                                                 RECV BK: ID:                                                PAYMENT DETAILS: ... View more

I have two datasets. One our own and the other a clients. I need to match them. However in our dataset we use Account_Number and the client uses BANKACCOUNT. I need match what accounts are in both datasets to produce a matching dataset and a non-matching dataset for Reconciliation purposes. How can this be done? Thanks    Below is my code which does not work   data Match No_Match; Merge Dataset1 Dataset2; by ACCOUNT_NUMBER BANKACCOUNT; if ina and inb then output Match; else output No_Match; run; ... View more