DATA Step, Macro, Functions and more

Accepted Solution

Dynamic Keep=() When Column Names have Spaces

Reply
Valued Guide
Posts: 528

Re: Dynamic Keep=() When Column Names have Spaces

Posted in reply to DavidPhillips2

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

run;

 

I was missing a set of ()

Highlighted
Super User
Posts: 12,148

Re: Dynamic Keep=() When Column Names have Spaces

Posted in reply to DavidPhillips2

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 16 replies
  • 193 views
  • 1 like
  • 5 in conversation