Help using Base SAS procedures

Extract symbol or number from text

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Extract symbol or number from text

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


Attachment

Accepted Solutions
Solution
‎02-13-2015 02:52 AM
Super User
Posts: 10,023

Re: Extract symbol or number from text

COMPRESS() is enough powerful for this .

data want;

set text;

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

run;

Xia Keshan

View solution in original post


All Replies
Super User
Posts: 19,772

Re: Extract symbol or number from text

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;

Solution
‎02-13-2015 02:52 AM
Super User
Posts: 10,023

Re: Extract symbol or number from text

COMPRESS() is enough powerful for this .

data want;

set text;

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

run;

Xia Keshan

Occasional Contributor
Posts: 14

Re: Extract symbol or number from text

Many thanks Reeza and Keshan!!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 210 views
  • 3 likes
  • 3 in conversation