Dynamic Keep=() When Column Names have Spaces

[DavidPhillips2]

data year2016; set work.combined (rename=(&renameString));

run;

I was missing a set of ()

[ballardw]

---

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