Hi Shmuel, Thanks for the reply, However, apologies on my part, i forgot to mention that I have raw lines which dont have < such as: Temperature : 56 I am currently using many IF statements for my scan function. The only thing unique about these rows that do not have column names are that they contain a number with a %. for the code here else do; i+1; col_name = 'Arm1_Yield_' || suffix(i); col_value = raw_line; end; I have also columns for Arm2_Yield , All_Yield etc as seen in the picture above, at this rate I would have duplicate column names in my final data set. I need SAS to recognize these names and then assign the approriate suffix respectively.
... View more
