topic Edit Check in SAS Programming

Edit Check

SASPhile — Wed, 27 Jun 2012 20:14:15 GMT

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

Daisy — Wed, 27 Jun 2012 21:23:52 GMT

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 — Wed, 27 Jun 2012 21:47:45 GMT

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 — Thu, 28 Jun 2012 02:30:53 GMT

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