topic Re: Extract symbol or number from text in SAS Procedures

Extract symbol or number from text

Johnlee — Fri, 13 Feb 2015 05:23:10 GMT

Dear all,

How to pick up a symbol or/and number in a paragraph? for example, how to extract "#" or "678" or "# 678" from the following data named as text? The attached dataset can be read into SAS in the following code.

DATA text;

INFILE "C:\text.txt"

dlm="," lrecl=5000;

informat var1 $256.;

format var1 $256.;

input var1;

RUN;

thanks!

John

Re: Extract symbol or number from text

Reeza — Fri, 13 Feb 2015 05:52:15 GMT

Look into the compress function for starters. Regular expressions will also get you there, but a bit harder to understand off the start.

data want;

set text;

var2=compress(var1, , 'a');

run;

proc print data=want;

run;

Re: Extract symbol or number from text

Ksharp — Fri, 13 Feb 2015 07:52:03 GMT

COMPRESS() is enough powerful for this .

data want;

set text;

var2=compress(var1,'#' , 'kd');

run;

Xia Keshan

Re: Extract symbol or number from text

Johnlee — Mon, 16 Feb 2015 02:32:48 GMT

Many thanks Reeza and Keshan!!