I have a variable whose values are both numeric and charaacters.e.g., 14.2 MG/DL, 19.2 %, no result 12.13 mmol/l, etc... its a mixed of different units r values. My question is 'Is it possible to read only the numeric portion of these values ie. 14.2, 19.2 (if it is text mark as .) 12.13, etc....Will this work with substring & scan function.
It would b helpful if I can have the solution ASAP.
Thanks in advance.
While this question is not related to "Mathematical Optimization and Operations Research with SAS" and while there might be more elegant ways to solve your challenge you might want to use a combination of existing SAS functions to tackle it.
I understand that your orginial variable is a character string containing alphanumeric symbols. Your goal is to read the numeric part and convert it to a numeric variable. Your digit symbol is ".".
The following example might illustrate what you are looking for:
input string $ 1-22;
length num 8;
keep string num;
no result 12.13 mmol/l
if you can use a data step, put the variable into the _infile_ buffer and then you have all the capabilities and flexibility of "input" statements to parse the text.
A paper given on this technique in an earlier SUGI "More _Infile_ Magic" http://www2.sas.com/proceedings/sugi28/086-28.pdf.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.