Help using Base SAS procedures

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

Reply
Regular Contributor
Posts: 161

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

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!
Regular Contributor
Posts: 161

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

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

Thanks!
Ask a Question
Discussion stats
  • 1 reply
  • 161 views
  • 0 likes
  • 1 in conversation