Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

How to generate a list of random numbers in SAS

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 82
Accepted Solution

How to generate a list of random numbers in SAS

I wish to simulate(generate) a list of random numbers, where I specify the number of observations that I wish, the underlying distribution(normal,lognormal), the mean, the std. deviation and I want as  output a list of random numbers from this distribution.

Further I wish to draw a probability plot of these numbers, conforming to stathe distribution that they were drawn from.

How to do it in SAS?


Accepted Solutions
Solution
‎06-10-2015 05:00 PM
SAS Super FREQ
Posts: 3,482

Re: How to generate a list of random numbers in SAS

This is found in Chapter 2 of Simulating Data with SAS. In the DATA step, use the RAND function within a loop to generate the data. Use the PROPPLOT statement in the UNIVARIATE procedure to construct the probability plot:

data Random;

N = 100;    /* sample size */

family = "Normal";  /* or "Lognormal" */

mean = 8;

stdDev = 3;

do i = 1 to N;

   x = rand(family, mean, stdDev);

   output;

end;

run;

/* draw propability plot */

proc univariate data=Random;

var x;

probplot x / square normal; /* or lognormal; optionally specify popluation parameters */

run;

View solution in original post


All Replies
Super Contributor
Posts: 336

Re: How to generate a list of random numbers in SAS

This book is essential for what you want to do. Absolutely recommended!

Simulating Data with SAS® by

Super User
Posts: 5,085

Re: How to generate a list of random numbers in SAS

This might be a good place to start:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202908.htm

The example in the "Details" section is pretty close to one of your objectives.

Solution
‎06-10-2015 05:00 PM
SAS Super FREQ
Posts: 3,482

Re: How to generate a list of random numbers in SAS

This is found in Chapter 2 of Simulating Data with SAS. In the DATA step, use the RAND function within a loop to generate the data. Use the PROPPLOT statement in the UNIVARIATE procedure to construct the probability plot:

data Random;

N = 100;    /* sample size */

family = "Normal";  /* or "Lognormal" */

mean = 8;

stdDev = 3;

do i = 1 to N;

   x = rand(family, mean, stdDev);

   output;

end;

run;

/* draw propability plot */

proc univariate data=Random;

var x;

probplot x / square normal; /* or lognormal; optionally specify popluation parameters */

run;

Frequent Contributor
Posts: 82

Re: How to generate a list of random numbers in SAS

Thanks. How come the probplot does not represent a bell curve but more like a 45 degree straight line?

SAS Super FREQ
Posts: 272

Re: How to generate a list of random numbers in SAS

The probplot isn't plotting the distribution of x, but a probability plot, similar to a Q-Q plot.  This is from the doc:

The PROBPLOT statement creates a probability plot, which compares ordered variable values with the percentiles of a specified theoretical distribution. If the data distribution matches the theoretical distribution, the points on the plot form a linear pattern. Consequently, you can use a probability plot to determine how well a theoretical distribution models a set of measurements.

Frequent Contributor
Posts: 82

Re: How to generate a list of random numbers in SAS

Thanks. How to get the plot of the distribution? I am looking for something like xyplot(x, p);

Super Contributor
Posts: 336

Re: How to generate a list of random numbers in SAS

SAS Super FREQ
Posts: 3,482

Re: How to generate a list of random numbers in SAS

You can get a histogram of the simulated sample by using the HISTOGRAM statement in PROC UNIVARIATE. To overlay a line plot of the distribution, specify the distribution name and any known parameters after a "slash" (/) :

histogram x / normal; /* or lognormal; optionally specify popluation parameters */

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 577 views
  • 6 likes
  • 5 in conversation