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
COMPRESS() is enough powerful for this .
data want;
set text;
var2=compress(var1,'#' , 'kd');
run;
Xia Keshan
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;
COMPRESS() is enough powerful for this .
data want;
set text;
var2=compress(var1,'#' , 'kd');
run;
Xia Keshan
Many thanks Reeza and Keshan!!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.