topic Re: How to randomise number to a range of +/- 1,000 in SAS Programming

How to randomise number to a range of +/- 1,000

Sean_OConnor — Wed, 03 Jun 2020 08:45:27 GMT

Dear All,

I have a numeric variable which is the median price of a property in a region. I need to add some noise to the data. Basically I would like to increase/decrease the values in the variable by no more than 1,000.

So on row 1, 176,000, might come 176,200 or on Row 2 79,000, might become 78,400.

Would anyone know how to do this?

Re: How to randomise number to a range of +/- 1,000

yabwon — Wed, 03 Jun 2020 09:26:18 GMT

Hi,

try: (RAND("uniform")*2000 - 1000)

but before that use: call streaminit(123);

All the best
Bart

Re: How to randomise number to a range of +/- 1,000

ed_sas_member — Wed, 03 Jun 2020 09:29:55 GMT

Hi @Sean_OConnor

Please try this:

data want;
	set have;
    x_noise=ceil(ranuni(1)*2000) - 1000 + x;
run;

Re: How to randomise number to a range of +/- 1,000

FreelanceReinh — Wed, 03 Jun 2020 09:32:36 GMT

Hello @Sean_OConnor,

With a recent SAS release such as 9.4M5 or M6 you can also use the Integer Distribution (if a discrete uniform distribution is fine):

data have;
input median_price;
cards;
176000
 79000
;

data want;
call streaminit(27182818);
set have;
median_price+rand('integer',-1000,1000);
run;

Re: How to randomise number to a range of +/- 1,000

johnmorgan — Wed, 03 Jun 2020 09:45:16 GMT

Hi everyone. Interesting solution, thanks for the information.