Yes. When I open the xlsx file, the value in the second column is with a formula relationship with the first column, For example, when you click the 3rd row cell of the second column, that is, B3 , the cell B3 will not show its value but "=A3". It means that this cell has relationship with the first column. The solution is that we copy all its values in this xlsx file into another one to discard the formula, keep original values as text. Thanks so much! ... View more

Thanks so much, Chris! I will continue to publish my articles on our SAS Communities Library.   I already submitted to SAS Global Forum 2018 couple minutes ago.   I found lots of SAS programmers and developers have some similar ideas on the same topic like how to decrease SAS execution time, how to fullfil automatic run using dynamic coding ways, how to develop clear, readable, understandable SAS engines. that is why I want to publish my may-be innovative ideas as soon as possible.    Anyway, thanks so much! ... View more

Thanks so much, Reeza!   ... View more