SAS Support Communities

Hi All,   I need your help generating variables in SAS. Below is an example of the data which I have in a txt format:   Random Data Random Data Random Data Include... ABC Include... DEF Include... GHI Include... JKL   123456789123 ABC      ".."  [..]  12  34 DEF      ".."  [..]  56  37 JKL       ".."  [..]  64  73 23455122467 ABC       ".."  [..]  67 43 GHI       ".."  [..]  12 46 JKL       ".."  [..]  87 56 XYZ      ".."  [..]  45 78 56745123446 ABC      ".."  [..]  78 45 DEF      ".."  [..]  12 54 STU      ".."  [..]  32 82 LMN      ".."  [..]  45 36 To be considered: XYZ STU LMN   Random Data   I want the output in the below format: Column1 ABC_1 ABC_2 DEF_1 DEF_2 GHI_1 GHI_2 JKL_1 JKL_2 XYZ_1 XYZ_2 STU_1 STU_2 LMN_1 LMN_2 123456789123 12 34 56 37     64 73             23455122467 67 43     12 46 87 56 45 78         5674512344 78 45 12 54             32 82 45 36   Basically, I want to extract the strings after the word "include" and also the strings below "To be considered:" from the txt file and make them column headers followed by _1 and _2 and allocate the values accordingly as shown above in the output.    Any help will be greatly appreciated. Thanks!   ... View more