Proc import.Change column names, if columns have space or cpecific symbols.

[Yura2301]

Hi all,
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:
Transactions amount

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.

Thanks!

[Yura2301]

Hi Again,
Problem was fixed by VALIDVARNAME options.
If set it to value V7 it replace all blanks and specific symbols to "_".

Thanks!