topic Re: RANUNI function implementation in CI in SAS Customer Intelligence

RANUNI function implementation in CI

ravindrrapaal — Tue, 25 Feb 2020 16:30:08 GMT

Hello, I am facing some while implementing the RANUNI. Below is the definition of RAN UNI

FLOOR((MOD(<</Client/ID CUID>>*397204094,(2**31)-1)/((2**31)-1)+1)*1000000000000000)

the above string will generate 20 digit random number then i need to select 5th digit of this number basis on the result need to apply cases like

WHEN 5th Digit <2 THEN 'CG'
WHEN 5th Digit ❤️ THEN 'D1'
WHEN 5th Digit <10 THEN 'D2'

I am struggling to be able to covert form numeric to char then char to numeric. where <</Client/ID CUID>> variable is numeric.

I am getting error most of the time

like <<root.field367>> is invalid and can't be used in query

Rick_SAS — Wed, 26 Feb 2020 16:20:20 GMT

Is there a reason you are not using the RAND function, which has excellent statistical properties and supports the Table distribution and the discrete uniform ("Integer") distribution?

Anyway, if X is the 20-digit number,

Compute Y by dividing X by 1E15, truncating to an integer, and then multiplying by 1E15.

Compute Z as X - Y. The first digit of the 15-digit number Z is what you want.

To get the first digit of Z, divide by 1E15 and truncate.

ravindrrapaal — Thu, 12 Mar 2020 17:53:23 GMT

Thank you so much for your response. The solution worked