DATA Step, Macro, Functions and more

Renaming unconventional Variable names

Accepted Solution Solved
Reply
Contributor
Posts: 66
Accepted Solution

Renaming unconventional Variable names

Hi,

I've imported data from an Excel spreadsheet and some variable names have spaces characters that SAS doesnt like too much.

In the data step how would i rename these variables?

i've tried

RENAME "VAR ONE" =VAR_ONE ;

or

RENAME "ACCT#" = ACCOUNT_NUMB ;

but that didnt seem to work.

Thanks for your help.


Accepted Solutions
Solution
‎01-08-2012 05:36 PM
Respected Advisor
Posts: 3,908

Renaming unconventional Variable names

In case you used the EG import wizard easiest would be to re-import the Excel and to tick the box in the import wizard saying "rename columns to comply with SAS naming conventions".

Else: The quoting for literals looks like '<varname'n

rename 'VAR ONE'n = VAR_ONE;

View solution in original post


All Replies
Solution
‎01-08-2012 05:36 PM
Respected Advisor
Posts: 3,908

Renaming unconventional Variable names

In case you used the EG import wizard easiest would be to re-import the Excel and to tick the box in the import wizard saying "rename columns to comply with SAS naming conventions".

Else: The quoting for literals looks like '<varname'n

rename 'VAR ONE'n = VAR_ONE;

Super Contributor
Posts: 1,636

Renaming unconventional Variable names

proc datasets library=work nolist;

modify your_dataset;

rename 'var one'n=var_one;

quit;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 5894 views
  • 5 likes
  • 3 in conversation