Splitting files in spss

Sign in. Forgot your password? Get help. Privacy Policy. Password recovery. Top Tip Bio. Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features. Performance Performance. Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

Analytics Analytics. Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc. Advertisement Advertisement. Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.

Others Others. This can be useful when you want to compare frequency distributions or descriptive statistics with respect to the categories of some variable e. The Split File window will appear. By default, the dataset is not split according to any criteria; this is indicated by Analyze all cases, do not create groups.

When you no longer want to split your analyses by group, you can turn Split File off through the same window you used to turn it on. The Compare and Organize options produce numerically identical results when the same grouping variable s are applied.

This is true regardless of what statistical analysis is used. The difference between the two options is how the numeric results are presented. The choice of which splitting method to use is entirely about what format the user wants their results in. Do you want a single table with all results, or separate tables for each group's results? A good rule of thumb is to choose Compare Groups if you want to be able to directly compare the results of your groups, and to choose Organize Output by Groups if the information is from separate trials or samples such as cohorts from different years.

Suppose that we want to get a summary of the differences in height between males and females in the sample data. Let's couple the Split File procedure with the Descriptives procedure to get summary statistics for the two groups. We'll use both Split File methods so that we can compare what their outputs look like. If you choose to split your data using the Compare groups option and then run a statistical analysis in SPSS, your output will be displayed in a single table that organizes the results according to the grouping variable s you specified.

After splitting the file, the only change you will see in the Data View is that data will be sorted in ascending order by the grouping variable s you selected. You should tick the option in the Output box to "Copy selected cases to a new dataset" and name the new dataset this is also in the syntax below. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Learn more.