BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11

Dear,

 

In my data the 'previous id'  value present in some character values of some OBS. I need to subset the dataset containing previous id value.Please help. Thank you

 

data

 

ID        value

1      Day -00 to -0-Previous ID

2      Day -11 to -16

 

output needed;

id                value

1           Day -00 to -0-Previous ID

 

 

1 REPLY 1
Reeza
Super User

Your looking for the actual text - Previous ID? 

 

Try FINDW() or INDEXW()

 

or

 

in a Where clause you can use LIKE.  

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