data year2016; set work.combined (rename=(&renameString));
run;
I was missing a set of ()
@DavidPhillips2 wrote:
The strip function seems to have made progress. I'm running into an error on:
"Grand total women (C2016_B)"n="Wn"n
ERROR 22-7: Invalid option name "Grand total women (C2016_B)"N.
I am currently playing with table 'junk' to see if I can recreate the error on a non-big data set. I'm working with 3000 columns.
Testing renaming can actually be done with a very small data set. You don't even need any observations unless you also want to do something like changing formats:
Data testset;
set bigset (obs=1);
run;
Or obs =0 if you don't need to see actual values.
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.