topic Re: How to find nth digit in numeric string in SAS CI in SAS Customer Intelligence

How to find nth digit in numeric string in SAS CI

ravindrrapaal — Tue, 25 Feb 2020 17:12:34 GMT

How can i find the nth digit in a 20 digit random number.

Example 1753150515609025 is random number where i want find 5th digit then wanted to use for CASE statment.

CASE

WHEN 5th digit of the 1753150515609025 is <2 THEN 'A'

WHEN 5th digit of the 1753150515609025 is ❤️ THEN 'B'

WHEN 5th digit of the 1753150515609025 is <10 THEN 'C

END'

Re: How to find nth digit in numeric string in SAS CI

Astounding — Tue, 25 Feb 2020 22:10:46 GMT

Do you actually have a SAS data set to work with?

SAS cannot accurately store integers that long. Is your random number a character string instead of numeric? What's the name of that variable?

Are you working in a DATA step or in SQL? The syntax for CASE WHEN does not appear to be correct syntax for a SAS program, but the right syntax probably depends on all of these questions being answered.

Re: How to find nth digit in numeric string in SAS CI

ravindrrapaal — Wed, 26 Feb 2020 03:19:16 GMT

Hi Yes, I have custonerid of 10 digit, then using RANUNI function in SAS CI campaigns, once the number is genatrated and this is working with that i need to take nth digit. Please advice

Re: How to find nth digit in numeric string in SAS CI

JamesAnderson — Wed, 26 Feb 2020 04:03:23 GMT

Hi,

Does your random number really need to be that long ?

SAS will handle an integer up to 16 digits (doc).

If you can work with that, the the following approach will find your nth digit and has the added benefit of generating Pass Thru SQL from PROC SQL (which is what CI Studio will do) for most RDBMS:

MOD({your integer variable}, 10) – this returns the last digit

MOD(FLOOR({your integer variable}/10),10) – this returns the 2^nd last digit

MOD(FLOOR({your integer variable}/100),10) – this returns the 3^rd last digit

MOD(FLOOR({your integer variable}/1000),10) – this returns the 4^th last digit

keep adding a zero to the divisor to get the next "digit".

Regards

James

Re: How to find nth digit in numeric string in SAS CI

Astounding — Wed, 26 Feb 2020 14:43:28 GMT

Not sure about CI, but here's a way in base SAS:

digit5 = input(substr(put(varname, 20.-L), 5), 1.);

Re: How to find nth digit in numeric string in SAS CI

ravindrrapaal — Thu, 12 Mar 2020 17:54:00 GMT

Thank you so much. It worked.