merge two data set

How to merge data file using SPSS (data analysis part-5)

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Merge data is a very important for data analysis. It is very simple to merge data file using spss. Spss is a simple analytics tool.

Merge data file using spss

What do we mean by add case?

Add case means combing or merge two data set where the variables of the two data set are same and their name also. suppose we have a data set named “data set1” where the variables are “id”,”gender”,”age”,”gpa”, and there exist data of 10 students.

merge file
Data set 1


Again we have 2nd data set named “data set2” where the variables are same as “data set1”

spss data set
Data set 2


Now we have to merge data file using spss

  • At first we have to go to menu bar and select 

               “Data”→”Merge file”→”Add case”
Then there open a new box named “Add cases to data set1” and we have to select “An external spss data file” and click on “Browse” and select the second data set which we want to combine with “data set1″

merge data file using spss
Adding cases


                                                            ↓

merge data set
Adding cases


After selecting the target file we have to click on “continue” and there open a new box . Now we have to click on “ok”
Finally our two data set are combined as below:

final data set
New data set with all cases

Merge or combining two data set(Add variables):

What do we mean by add variables?
Add variables means merge or combing two data set where the variables are totally different from each other data set. we have to combine the variables of two data set.

Note: If there exist same variables in two data , one will be excluded after merge.
          And also, the length of the data or size of the data in two data set must be same.

suppose we have a data set named “data set1” where the variables are “id”,”gender”,”age”,”gpa”.

and there exist data of 10 students.

new data set
Data set 1

Again we have 2nd data set named “data set2” where the variables are “id”, “family_member” and there exist data of 10 students.

new data set 2
Data set 2


Now we have to combine two data set.

  • At first we have to go to menu bar and select 

               “Data”→”Merge file”→”Add variables”
Then there open a new box named “Add variables to data set1” and we have to select “An external spss data file” and click on “Browse” and select the second data set which we want to combine with “data set1″


merge data file using spss
Adding values



 

                                                                          

adding values
Adding values 

After selecting the target file we have to click on “continue” 

and there open a new box . Now we have to click on “ok” and if there exist same variable in the data sets they are excluded automatically .

merge data
Include/exclude variable



And finally we get the combine data set as below:

merge data file using spss
Final data set


How to analyze data using SPSS (for beginners)-part 1
How to analyze data using SPSS (part-2), how to input data in SPSS
How to analyze data using SPSS (part-3), how to import data in SPSS from excel file
How to analyze data using SPSS (part-4), how to sort data in SPSS
How to analyze data using SPSS ( part-5) how to merge file in SPSS?
How to analyze data using SPSS ( part-6), how to merge file in SPSS
How to analyze data using SPSS (part-7), Finding missing values, Replacing missing values, Coding missing values in SPSS
How to analyze data using SPSS (part-8), variable transformation, Recoding variables in spssUnivariate Analysis (data analysis using spss part-9)
Bivariate analysis| How to analyze data using spss (part-10)
Normality check| how to analyze data using spss (part-11)


Leave a Reply

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

Releated

normality check using spss

Normality checking of a data set using spss

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Spread the love          Normality checking is a procedure of check the normality of our working data set. Basically we check the normality using histogram. If the shape of the histogram is bell shaped then the data set follow the normal distribution. We also use the normality table including kolmogrov-smirnov test and shapiro-wilk test value. If the […]

bivariate analysis

Bivariate analysis using spss (data analysis part-10)

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Spread the love          Bivariate analysis using spss is very simple procedure of finding the association between two variables. Spss is a very simple data analytics tool by which we can perform our analysis very easily. Bivariate Analysis What is bivariate analysis? Bivariate analysis is the analysis of two random variable and find their association. For bivariate […]

univariate analysis using spss

Univariate analysis using spss (data analysis part-9)

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Spread the love          We conduct Univariate analysis using spss to find the characteristics of this variable. Spss is a simple statistical analytics tool which is very easy to use and maintain. What is univariate analysis using spss? It is the analysis of one random variable such as descriptive statistics (mean, variance etc.). We have the following […]