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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 1523 views
  • 0 likes
  • 2 in conversation