Randomly match subject ID with blind id

Div_sas — Thu, 23 Aug 2018 22:57:47 GMT

Hi,

I have two datasets, one has 100 subject IDs and the other has 100 Blind ids, is there a way to randomly merge/match these two datasets so that each subject ID gets a blind id assigned to it

I have:

dataset 1:

blind id

1-119

1-123

1-102

1-155

dataset2:

subject ID

122

234

345

566

I want:

subject ID	blind id
122	1-123
234	1-155
345	1-119
566	1-102

Thank you.

Re: Randomly match subject ID with blind id

PeterClemmensen — Thu, 23 Aug 2018 23:31:54 GMT

data dataset1;
input blindid $;
datalines;
1-119
1-123
1-102
1-155
;

data dataset2;
input subjectID;
datalines;
122
234
345
566
;

data help;
   set dataset1;
   x=rand('Uniform');
run;

proc sort data=help;
   by x;
run;

data want(drop=x);
   merge dataset2 help;
run;

topic Randomly match subject ID with blind id in SAS Programming

Randomly match subject ID with blind id

Re: Randomly match subject ID with blind id