https://communities.sas.com/t5/SAS-Procedures/Proc-import-Change-column-names-if-columns-have-space-or/m-p/17445#M3312 Hi Again,<BR /> Problem was fixed by VALIDVARNAME options.<BR /> If set it to value V7 it replace all blanks and specific symbols to "_".<BR /> <BR /> Thanks! Fri, 25 Feb 2011 15:25:21 GMT Yura2301 2011-02-25T15:25:21Z https://communities.sas.com/t5/SAS-Procedures/Proc-import-Change-column-names-if-columns-have-space-or/m-p/17444#M3311 Hi all,<BR /> I use proc import for importing data from excel file.<BR /> First row in excel file can has cells with few spaces(or another specific symbols), for example:<BR /> Transactions amount<BR /> <BR /> After import sas treat this column as 'Transactions amount'n ,<BR /> but this format of column names isn't suitible for me, I need convert it to smth. like:<BR /> TransactionsAmount or Transactions_amount, without ' and "n".<BR /> 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...<BR /> So if you know some similar approach -please write.<BR /> <BR /> Thanks! Fri, 25 Feb 2011 13:06:57 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-import-Change-column-names-if-columns-have-space-or/m-p/17444#M3311 Yura2301 2011-02-25T13:06:57Z https://communities.sas.com/t5/SAS-Procedures/Proc-import-Change-column-names-if-columns-have-space-or/m-p/17445#M3312 Hi Again,<BR /> Problem was fixed by VALIDVARNAME options.<BR /> If set it to value V7 it replace all blanks and specific symbols to "_".<BR /> <BR /> Thanks! Fri, 25 Feb 2011 15:25:21 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-import-Change-column-names-if-columns-have-space-or/m-p/17445#M3312 Yura2301 2011-02-25T15:25:21Z