topic Re: find notprintable string in data in SAS Programming

find notprintable string in data

Riteshdell — Fri, 18 May 2018 06:33:25 GMT

hello experts,

I need a help to solve a query. I have a dataset and column called NAME but this column Name has some kind of encoding data like .

I want to check which row has encoding data of ASC value which is falling between 161 to 255.

Suppose if you below code and data , so it should check each observation each string and identify the each string ASC value and if any ASC value in observation is falling between 161 to 255, then a new column RANK_VALUE should give result of ASC Value,

if no value from 161 to 255, then null should pass.

data test;
input name $32.;
datalines;
RÃm
John
èra
©kumara
¶cris
;
run;

output :


Name   Rank_value

RÃm       195
John
èra       232
©kumara    169
¶cris       182

Re: find notprintable string in data

RW9 — Fri, 18 May 2018 07:12:48 GMT

And have you tried the rank procedure:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212189.htm

Re: find notprintable string in data

Riteshdell — Fri, 18 May 2018 07:18:39 GMT

rank procedure I ahev idea, but here each string we need to check . with array and loop we need to find out

Re: find notprintable string in data

RW9 — Fri, 18 May 2018 07:30:49 GMT

Random words, ahve no idea.

Functions work anywhere in arrays, or loops, anywhere in datastep. Provide test data in the form of a datastep, show what the output should look like, explain the logic between the two.

data test;
  input name $32.;
  do i=1 to lengthn(name);
    rank_value=rank(char(name,i));
    output;
  end;
datalines;
RÃm
John
èra
©kumara
¶cris
;
run;

That might not actually do what you want however, try it out. Some other possiblities:

http://www.sascommunity.org/planet/blog/category/rank/

29May example, shows compress removing specials, but you could reverse it with:

data want;
  set have;
  if lengthn(compress(name," ","ad"))>0 then result="special character";
run;

So remove the alaph and numerics then if the lengthn is greater than 0 you know you have odd characters.