Random number generation as a new variable

[Rish]

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.

R

[PGStats · Accepted solution]

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;

PG

[Rish]

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

R

[PGStats]

Remove the data=

data carslist;

     set sashelp.cars;

     z=rand('UNIFORM');

run;

PG