@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.