BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11

Dear,

Please suggest in my code. I need to output only records containing word "Platelet'. I am getting both records. Thank you

 

output needed;

tran Platelet

 

data one;
input val $1-21;
datalines;
tran Plateletpheresis
tran Platelet
;

data two;
set one;
if index(val,'Platelet') >0;
run;
1 REPLY 1
andreas_lds
Jade | Level 19

If you want to search for words, use the function findw or a regular expression.

data two;
set one;
if findw(val,'Platelet') >0;
run;

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
  • 1 reply
  • 662 views
  • 1 like
  • 2 in conversation