BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
3 REPLIES 3
Andre
Obsidian | Level 7
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
deleted_user
Not applicable
good Message was edited by: Display name not found
deleted_user
Not applicable
Thanks for the info. I used your example to make my code work.
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1603 views
  • 0 likes
  • 2 in conversation