topic Re: my data consist orderID buyer price item unit courier in New SAS User

my data consist orderID buyer price item unit courier

IdlanHnf — Sat, 20 Jun 2020 10:40:52 GMT

when i run this coding, the price always change everytime I run it. is it possible to make it become fix? I want it to be fix no matter how much run I did on it.

PROC SQL;
UPDATE WORK.data2
SET 'Price (RM)'n=RAND("INTEGER",12,15);
RUN;
PROC PRINT DATA=WORK.data2;
RUN;

Re: my data consist orderID buyer price item unit courier

Jagadishkatam — Sat, 20 Jun 2020 10:56:45 GMT

Please try the seed, we need to use seed to make the rand generate consistent values

data data3;
set data2;
call streaminit(123);
'Price (RM)'n=RAND("INTEGER",12,15);
RUN;
PROC PRINT DATA=WORK.data3;
RUN;

Re: my data consist orderID buyer price item unit courier

IdlanHnf — Sat, 20 Jun 2020 11:02:56 GMT

Thank you so much. It's working