topic extract only character and numeric values, remove special character in SAS Programming

extract only character and numeric values, remove special character

Riteshdell — Tue, 10 Oct 2017 06:52:52 GMT

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 — Tue, 10 Oct 2017 06:53:53 GMT

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

Patrick — Tue, 10 Oct 2017 06:59:28 GMT

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 — Tue, 10 Oct 2017 07:08:38 GMT

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