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.

Data set 1 |

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

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″

Adding cases |

↓

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:

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.

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.

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″

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 .

Include/exclude variable |

And finally we get the combine data set as below:

Final data set |

**Try some new contents about data analysis and statistics:**

- Time series analysis
- Business forecasting
- Hypothesis testing
- Logistic Regression
- Inference
- Experimental Design
- Correlation Analysis
- Data analysis using spss
- Data analysis using SPSS
- Data entry in SPSS
- Import data in SPSS from excel file
__Sort data in SPSS____Merge data set in SPSS__- Finding, Replacing and Coding missing values in SPSS
- Variable transformation, Recoding variables in SPSS
- Bivariate analysis in SPSS
- Normality check in SPSS

__ __