filter data

[dapenDaniel]

Hello! My data set has an ID number (character variable) and I want to filter some of observations.

The criteria is if the 3rd and the 4th digits are "RE", then delete.

For example, if the ID is ABRE5550, this observation should be deleted.

What code do I need to use? 

Thanks.

[Reeza]

Look at the SUBSTR() function.

[dapenDaniel]

if substr(id, 3, 4) = RE then delete;

Is it correct? 

[Reeza]

Is RE a variable or text? If it's text it needs to be in quotes, if it's a variable then it's fine.

[kiranv_ · Accepted solution]

if substr(id, 3, 2) = "RE" then delete;

3 is starting position and 2 is length and you need quotes around the value