topic Re: How to use Rand Function in SAS Programming

How to use Rand Function

CathyVI — Mon, 29 Jul 2019 16:24:51 GMT

In the SAS learning course Programming 2, the rand function was used with “Integer” for random values to the data but when I tried it using my SAS 9.4 TS level 1M3 on Microsoft windows 10 enterprise(x64), I couldn’t get the same result. I also looked online to see compatible distribution for the Rand function but non specify the “integer”. This is my data step;

data test.class1;

NameID=Rand("Integer", 100,999);

set test.Class;

drop name sex;

run;

I have also tried the (RandBetween), but didn’t work. Any help ?

Re: How to use Rand Function

Reeza — Mon, 29 Jul 2019 16:28:45 GMT

Rand with the INTEGER option was introduced in SAS 9.4 - which is about 7 years old now. It's not available in SAS 9.3. Instead you can roll your own using Uniform distribution or using a macro written by Rick Wicklin here:
https://blogs.sas.com/content/iml/2015/10/05/random-integers-sas.html

Re: How to use Rand Function

CathyVI — Mon, 29 Jul 2019 16:56:00 GMT

@Reeza Thank you, it worked.