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' ... View more

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       ... View more

Hello,   I am new to SASCI. Just wanted to know can we create a campaign diagram by selecting criteria from a table rather than using Infomap ? Or Is it mandatory to use Infomap to use any database table in SAS diagram?   Regards, Ravindrra ... View more