Cutting digit

[dapenDaniel]

Hi. I have two variables as following below. 

           ID                                Year

US2007025948                     2007

What I want to do is that if year (2007) equals to the third to the sixth digit of ID (US2007025948), delete this observation.

What code do I need to use? Thanks.

[Reeza · Accepted solution]

if put(year, 4.) = substr(id, 3, 4) then delete;

This assumes year is numeric and ID is character. If it's otherwise you'll need to modify the functions a little bit, but in general that's what you need. It can be modified to be in a WHERE clause, or for SQL or a data step as needed as well.

---

@dapenDaniel wrote:

Hi. I have two variables as following below. 

           ID                                Year

US2007025948                     2007

What I want to do is that if year (2007) equals to the third to the sixth digit of ID (US2007025948), delete this observation.

What code do I need to use? Thanks.

---

[dapenDaniel]

Year is also character variable.

[Reeza]

Then remove the PUT function and it should work.

[dapenDaniel]

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

Is it correct?

[Reeza]

Does it work?

---

@dapenDaniel wrote:

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

Is it correct?

---

[dapenDaniel]

there is no error message so I think it works.

[Reeza]

Check the output. Just because code runs doesn't mean it's correct. You should always know what you should expect as output and test for that. This will help you avoid mistakes.

[dapenDaniel]

I checked the output. The code works well. Thanks.