SPSS Simple Random Sampling using Select Cases

This SPSS tutorial explains how to conduct Simple Random Sampling using Select Cases in SPSS.

You may also want to read:

Excel VBA generate non-duplicated random number

Assign unique random number using Excel

SPSS Simple Random Sampling

In conventional simple random sampling, you need to assign an ascending number to each value of a variable and then generate a random number to help you select the corresponding data.

While SPSS can generate random number using Compute Variable, it is even easier to directly select some random data as sample using Select Cases.

SPSS Simple Random Sampling using Select Cases

Navigate to Data > Select Cases

SPSS select cases 01

 

Select the second option Random sample of cases > click on Sample… button

SPSS select cases 07

 

The first option is to filter a certain percentage of cases. But note that it is only “Approximately”, the number of cases filtered could vary significantly.

SPSS select cases 08

 

Lets say we enter 50% in the box. Go back to Data View and you can see only 3 cases out of 8 cases are filtered.

SPSS select cases 09

 

Alternatively, you can specify how many data you need exactly. Go back to the previous screen and select the second option. Enter 4 cases from the first 7 cases. Click on Continue button and go back to Data View.

SPSS select cases 10

 

Now you can see 4 random rows from row 1 to 7 remain.

SPSS select cases 11

 

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in creating custom Function and Sub solutions, and is proficient in report automation with Access.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist
- Microsoft Specialist
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *