topic Re: How do I separate one text variable into two numeric variables? in ODS and Base Reporting

How do I separate one text variable into two numeric variables?

deleted_user — Thu, 17 Jan 2008 06:49:02 GMT

My variable is blood pressure (BP). For example the value is text and looks like:
BP
136/80

How do I convert this variable into two separate numeric variables that look like:
systolic
136

diastolic
80

Thanks.

Re: How do I separate one text variable into two numeric variables?

Andre — Thu, 17 Jan 2008 08:43:42 GMT

here is a solution with the use of scan function to separate words
then i use another function to translate the numbers in characters into a numeric sas variable
i showed, as you not precise give the length of the char variable, two start variables with the same information

data a;
a=" 136/80 ";
b="136/80";
c=input(left(scan(a,1,"/")),best12.);
d=input(scan(b,2,"/"),3.);
put c= d=;
run;

Andre

Re: How do I separate one text variable into two numeric variables?

deleted_user — Thu, 17 Jan 2008 17:52:06 GMT

good Message was edited by: Display name not found

Re: How do I separate one text variable into two numeric variables?

deleted_user — Mon, 21 Jan 2008 16:44:05 GMT

Thanks for the info. I used your example to make my code work.