extract only character and numeric values, remove special character

[Riteshdell]

hello ALL,

I am looking for a  solution which extract only character (A-Z) and numeric (0-9) data, remove special character and space.

Is there any function for same.

Output should be : Ram7shaym

data temp;
input A $50.;
datalines;
Ram7$%?shay m
;
run;

[andreas_lds]

The function translate can do this, maybe you need to call it more than once.

[Patrick]

@andreas_lds

Sounds like a use case for the compress() function.

data temp;
  input A $50.;
  wantstr=compress(a,,'kda');
  datalines;
Ram7$%?shay m
;
run;

[andreas_lds]

@Patrick: of course, compress is the easier way to solve this 😉