Random draws without replacement

Pabster — Mon, 25 Mar 2019 20:00:26 GMT

Hi everyone,

I' ve posting quite a bit about this to try and get around the problem without succes.

Here is part of the data set I have to work on

The companies that have a DLRSN number are Inactive, those without it are Active.

What I need to do is:
-Through the use of the Uniform Function , give each company a random number between 0-1 (hence the uniform)
-Afterwards use that number to select a unique Active company for each possible Inactive company.
an Active company Cannot be used 2 for analysis purpose

my final data set should look something like this :

DATADATE FYEAR DLRSN CONM DLDTE COSTAT SICH

03/12/1992 1989 . A 0 112

03/12/1993 1989 02 B 1990 1 112

03/12/1994 1990 . D 0 333

03/12/1992 1990 03 F 1992 1 333

03/12/1993 1994 . J 0 445

03/12/1994 1994 03 L 1996 1 445

03/12/1998 1998 . I 0 001

03/12/1998 1998 02 Z 2000 1 001

*Update*
I realized that by MERGING my data set and not doing a SET merge, I obtained the following data:

This are all Active companies that correspond to my Inactive ones (that you can see in the 1st picture). How can I create a random uniform function that will give them random values between 0-1 so I can pick some of them for further analysis

Hope its clear and you guys can help

Re: Random draws without replacement

Reeza — Mon, 25 Mar 2019 20:05:00 GMT

Have you looked into PROC SURVEYSELECT to pick random samples?

topic Re: Random draws without replacement in SAS Programming

Random draws without replacement

Re: Random draws without replacement