Hi, Tom   Thanks for your sharing and replying. The codes work. I very appreciate your help. I'm new to SAS programming but have some C++ and java background. Do you have some websites or book that you recommend to read.   Sean ... View more

Hi, ballardw The "Source_Data" is imported excel sheet. I try to local var1(or column 1) and row 2 and take the subtring from last 2 characters. Create a new data set and insert substring into new column. the current imported table "Source_Data"    var1            var2 ab sc ef    12 43 56 dt wg df    56 23 55       ;                :       :                : The desired data set should like:     var1          Var2       New_col ab sc ef    12 43 56         df dt wg df    56 23 55         df      :                 :                df   ... View more

Hi, rogerjdeangelis   Thanks for you reply. Currently I'm using SAS Enterprise Guide. First of all, I already imported an excel sheet called "Source_Data" to SAS. The next step I'm trying to wrtie codes to read this Source_Data into another new data set called "Refined_Data". My question is when I read this Source_Data, I want to locate a specific cell such as column 1 row3. Then take the substring on this specific cell such as last 10 character and insert the substring into new clolumn on data set "Refined_Data" ... View more

Hi, Ballardw Thanks for your reply. But instead of using "datalines" statement. I want to read from imported Excel sheet. I have created a new table already. Next how can I achieve to locate column 1 and row 1 specifically and extract the substring on that cell. Finally put the substring value into new column on the new table. You understand the scenario now? Thanks ... View more