How to subset data based on variable value containing some characters

knveraraju91 — Sat, 14 Jan 2017 18:10:57 GMT

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

Re: How to subset data based on variable value containing some characters

Reeza — Sat, 14 Jan 2017 18:31:24 GMT

Your looking for the actual text - Previous ID?

Try FINDW() or INDEXW()

in a Where clause you can use LIKE.

topic How to subset data based on variable value containing some characters in SAS Programming

How to subset data based on variable value containing some characters

Re: How to subset data based on variable value containing some characters