topic Re: Macro for dynamically assigning new values based on random numbers in SAS Programming

Macro for dynamically assigning new values based on random numbers

mike_579357 — Wed, 10 Jan 2018 20:59:03 GMT

Hello - I am relatively new to SAS and a first time poster. I have some code that assigns a random integer to a set of IDs. I have posted this below. Is it possible to create a new ID variable chosen by the user based on these random variables? Ive had trouble with this because the number of new IDs I want to assign inherently changes. Is there a better way to go about this?

data data_1;

Input id_no;

cards;

123

456

789

987

654

;

run;

%macro assign_rand(no_rand=);

%macro randbetween(min,max);

(&Min + floor((1+&max-&min)*Rand("uniform)));

%mend;

data data_1;

set data_1;

random_no = %randbetween(1,&no_rand);

run;

%mend;

Re: Macro for dynamically assigning new values based on random numbers

Reeza — Wed, 10 Jan 2018 21:11:16 GMT

Are you looking for something along these lines?

https://gist.github.com/statgeek/fd94b0b6e78815430c1340e8c19f8644

@mike_579357 wrote:

Hello - I am relatively new to SAS and a first time poster. I have some code that assigns a random integer to a set of IDs. I have posted this below. Is it possible to create a new ID variable chosen by the user based on these random variables? Ive had trouble with this because the number of new IDs I want to assign inherently changes. Is there a better way to go about this?

data data_1;

Input id_no;

cards;

123

456

789

987

654

;

run;

%macro assign_rand(no_rand=);

%macro randbetween(min,max);

(&Min + floor((1+&max-&min)*Rand("uniform)));

%mend;

data data_1;

set data_1;

random_no = %randbetween(1,&no_rand);

run;

%mend;

Re: Macro for dynamically assigning new values based on random numbers

Ksharp — Thu, 11 Jan 2018 13:34:53 GMT


data data_1;
  Input id_no;
  cards;
  123
  456
  789
  987
  654
;
run;


  data _null_;
    set data_1 end=last;
 if _n_=1 then call execute('data want;');
 call execute(catt('random_no=1 + floor(',id_no,'*Rand("uniform"));output;'));
 if last then call execute('run;');
  run;

Re: Macro for dynamically assigning new values based on random numbers

ArtC — Thu, 11 Jan 2018 19:03:07 GMT

@Ksharp cool code, but would the following be a simpler approach?

  data want2;
   set data_1;
   random_no=1+floor(id_no*rand('uniform'));
   run;

Do we need to be sure that the random identifiers are unique?

Re: Macro for dynamically assigning new values based on random numbers

Ksharp — Fri, 12 Jan 2018 12:41:46 GMT

@ArtC Cool ! Maybe I get confused by OP. Hope one day we could have a meet in the future.