Edit Check

[SASPhile]

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

[Daisy]

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.

[Haikuo]

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

[Ksharp]

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