02-13-2015 12:23 AM
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.
informat var1 $256.;
format var1 $256.;
02-13-2015 12:52 AM
Look into the compress function for starters. Regular expressions will also get you there, but a bit harder to understand off the start.
var2=compress(var1, , 'a');
proc print data=want;
Need further help from the community? Please ask a new question.