I use proc import for importing data from excel file.
First row in excel file can has cells with few spaces(or another specific symbols), for example:
After import sas treat this column as 'Transactions amount'n ,
but this format of column names isn't suitible for me, I need convert it to smth. like:
TransactionsAmount or Transactions_amount, without ' and "n".
I can resolve this problem by making macro with loop which will replace in each column names which has space(or some specific symbol) this space into "_", but I think must be some more simple and universal solution for such situations...
So if you know some similar approach -please write.