topic Re: Cutting digit in SAS Programming

Cutting digit

dapenDaniel — Mon, 19 Nov 2018 23:15:00 GMT

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.

Re: Cutting digit

Reeza — Mon, 19 Nov 2018 23:22:37 GMT

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.

Re: Cutting digit

dapenDaniel — Mon, 19 Nov 2018 23:38:21 GMT

Year is also character variable.

Re: Cutting digit

Reeza — Mon, 19 Nov 2018 23:52:29 GMT

Then remove the PUT function and it should work.

Re: Cutting digit

dapenDaniel — Tue, 20 Nov 2018 03:35:04 GMT

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

Is it correct?

Re: Cutting digit

Reeza — Tue, 20 Nov 2018 15:35:36 GMT

Does it work?

@dapenDaniel wrote:

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

Is it correct?

Re: Cutting digit

dapenDaniel — Tue, 20 Nov 2018 16:56:26 GMT

there is no error message so I think it works.

Re: Cutting digit

Reeza — Tue, 20 Nov 2018 16:57:22 GMT

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.

Re: Cutting digit

dapenDaniel — Tue, 20 Nov 2018 17:13:38 GMT

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