BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi All,

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.
Priya
2 REPLIES 2
deleted_user
Not applicable
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:
data test;
input string $ 1-22;
length num 8;
digit1=scan(string,1,".");
i=anydigit(digit1,1);
j=anydigit(digit1,-23);
str1=trim(left(substr(digit1,i,j)));
digit2=scan(string,-1,".");
i=anydigit(digit2,1);
j=anydigit(digit2,-23);
str2=trim(left(substr(digit2,i,j)));
all=compress(str1||"."||str2);
num=all;
keep string num;
cards;
14.2 MG/DL
19.2 %
no result 12.13 mmol/l
run;
deleted_user
Not applicable
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.

PeterC

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1083 views
  • 0 likes
  • 1 in conversation