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
Compensation Survey Manager@Mercer
Wyman is human resources professional, specialized in business analysis, project management, data transformation with Access and Excel.

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

You may drop me a message if you are interested in HR consultancy services from Mercer.

Leave a Reply

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