topic Re: Random number generation as a new variable in SAS Procedures

Random number generation as a new variable

Rish — Tue, 28 Aug 2012 23:14:09 GMT

Hello seniors -

I want to add a column called RandomNumber (say Z) to my existing list of variables (X Y).

Similar to way we generate a random number in excel using command =Rand().

Thanks for advise.

PGStats — Tue, 28 Aug 2012 23:31:19 GMT

The RAND function in SAS has arguments. For uniformly distributed values similar to the RAND() function in Excel do:

data want;

set have;

Z = RAND("UNIFORM");

run;

Rish — Wed, 29 Aug 2012 00:14:11 GMT

Hi PG,

I used the following, I am newbie and am sure missing something basic. Can you please gide?

data carslist;

set data=sashelp.cars;

z=rand('UNIFORM');

run;

Thanks

PGStats — Wed, 29 Aug 2012 00:28:34 GMT

Remove the data=

data carslist;

set sashelp.cars;

z=rand('UNIFORM');

run;