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.
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;
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;
proc datasets library=work nolist;
modify your_dataset;
rename 'var one'n=var_one;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.