topic Renaming unconventional Variable names in SAS Programming

Renaming unconventional Variable names

Danglytics — Sun, 08 Jan 2012 21:59:01 GMT

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 ;

RENAME "ACCT#" = ACCOUNT_NUMB ;

but that didnt seem to work.

Thanks for your help.

Renaming unconventional Variable names

Patrick — Sun, 08 Jan 2012 22:36:37 GMT

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;

Renaming unconventional Variable names

Linlin — Sun, 08 Jan 2012 23:25:01 GMT

proc datasets library=work nolist;

modify your_dataset;

rename 'var one'n=var_one;

quit;