DATA Step, Macro, Functions and more

Edit Check

Reply
Super Contributor
Posts: 673

Edit Check

The values of a column, no special characters are allowed and use an underscore to mark spaces?

New Contributor
Posts: 3

Re: Edit Check

Is this what you are looking for ?

x2=compress(tranlate(x1,'_',' '), '~!@#$%^&*()+|}{[]\<>?');


x1=your original column

x2=new output

note : you could change the list of special characters you want to remove.

Respected Advisor
Posts: 3,156

Re: Edit Check

Sometimes it is difficult to exhaust or even define special characters, that is where 'k' modifier coming in handy:

x2=compress(translate(x1,'_',' '),'_','kda');

Haikuo

Super User
Posts: 10,046

Re: Edit Check

What legal characters do you want ?

data x;
 x="x2=compress(tranlate(x1,'_sdsd',' '),   '~!@#$%^*()+|}{[]\<>?');";
 xx=prxchange('s/\W//o',-1,translate(compbl(x),'_',' '));
run;


Ksharp

Ask a Question
Discussion stats
  • 3 replies
  • 236 views
  • 3 likes
  • 4 in conversation