SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Random Sample of a non-event

Reply
New Contributor
Posts: 4

Random Sample of a non-event

Hi All:

I am working on a logistic regression-- binary outcome. The 1 (or the event) has a sample size of 600, while the 0 (non-event) has a sample size of 8000.

How do I extract a random sample of 600 of the non-event? It seems like proc suveyselect only lets me take a random sample of all participants, not just those who fall in the non-event.

Thanks so much!

Super User
Posts: 10,516

Re: Random Sample of a non-event

On the input dataset name use the where option to select input records only for specific values. This completely subsets the data. The selection probability and weights will only work for that subset so be careful.

proc surveyselect data=lib.have (where=(eventvariable = 0)) ....

New Contributor
Posts: 4

Re: Random Sample of a non-event

This code is not working. I keep getting an error message that says that my use of the where statement is incorrect.

Super User
Posts: 10,516

Re: Random Sample of a non-event

Post the code you're submitting

Trusted Advisor
Posts: 1,204

Re: Random Sample of a non-event

Hi,

Seems like trying to make a dataset containing equal number of event and non-event cases. Try this to get the desired sample dataset.

data sample;

set have;

if y=1 or (y=0 and ranuni(1234)<0.075) then output;   /* Suppose y is the event variable */

run;

New Contributor
Posts: 4

Re: Random Sample of a non-event

When I used the code that you suggested, I got: data set has 0 observations and 1 variable.

I am trying to make a dataset containing an equal number of event and non-event cases.

New Contributor
Posts: 4

Re: Random Sample of a non-event

Thank you for all of your help! Smiley Happy

Super User
Posts: 10,516

Re: Random Sample of a non-event

If you had clearly stated your need earlier then STRATA in survey select with event and nonevent sample sizes specified would have worked.

Ask a Question
Discussion stats
  • 7 replies
  • 445 views
  • 0 likes
  • 3 in conversation