IBM SPSS Interview Questions

by Azhar Uddin Technical Architect

If you're looking for IBM SPSS Interview Questions & Answers for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research IBM SPSS has a market share of about 29.5%. So, You still have opportunity to move ahead in your career in IBM SPSS Analytics. Mindmajix offers Advanced IBM SPSS Interview Questions 2018 that helps you in cracking your interview & acquire dream career as IBM SPSS Analyst.

Are you interested in taking up for IBM SPSS Certification Training? Enroll for Free Demo on IBM SPSS Trainin Online!

Q. How can I compare two data sets in SPSS? orHow do I check that the same data input by two people are consistently entered?

NOTE: The methods shown on this page work with SPSS versions 21 and later. If you are using an earlier version of SPSS.

There are times when you would like to compare two data sets to see if they are exactly the same. For example, if two people enter the same data (double data entry), you would want to know if any discrepancies exist between the two datasets (the rationale of double data entry), and if so, where those discrepancies are. We start by reading in the two datasets, one entered by person 1 and the second by person 2. The two data sets are identical, except that we created a missing value in the ninth row, second variable, in the first data set, and we changed the very last entry from 51 to 52 in the second data set.

data list list /id female race ses * schtype (A3) prog read write math science socst.begin data. 147 1 1 3 pub 1 47 62 53 53 61 108 0 1 2 pub 2 34 33 41 36 36 18 0 3 2 pub 3 50 33 49 44 36 153 0 1 2 pub 3 39 31 40 39 51 50 0 2 2 pub 2 50 59 42 53 61 51 1 2 1 pub 2 42 36 42 31 39 102 0 1 1 pub 1 52 41 51 53 56 57 1 1 2 pub 1 71 65 72 66 56 160 . 1 2 pub 1 55 65 55 50 61 136 0 1 2 pub 1 65 59 70 63 51end data.sort cases by id.save outfile “D:person1.sav”. data list list /id female race ses * schtype (A3) prog read write math science socst.begin data. 147 1 1 3 pub 1 47 62 53 53 61 108 0 1 2 pub 2 34 33 41 36 36 18 0 3 2 pub 3 50 33 49 44 36 153 0 1 2 pub 3 39 31 40 39 51 50 0 2 2 pub 2 50 59 42 53 61 51 1 2 1 pub 2 42 36 42 31 39 102 0 1 1 pub 1 52 41 51 53 56 57 1 1 2 pub 1 71 65 72 66 56 160 1 1 2 pub 1 55 65 55 50 61 136 0 1 2 pub 1 65 59 70 63 52end data.sort cases by id.save outfile “D:person2.sav”.

Now we can use the compare datasets command to compare the two data files. We start with the person2 data file open, and we will compare it to the person1 file. To do this, we specify the person1 data file on the compdataset subcommand of the compare datasets command. The variables subcommand is necessary, and in this example, we will use the keyword all so that all variables in the data files are compared. We will use the save subcommand to create a new variable called mismatchflag in the person2 data set. This variable will have a value of 0 for cases that match and a value of 1 for cases that do not match. If we had any unmatched cases, they would get a value of -1. While it is easy to see which cases do not match in this tiny example data set, it might not be so easy in a larger data set. We can use the frequencies command to show us how many cases matched and did not match.

compare datasets/compdataset “D:tempperson1.sav”/variables all/save flagmismatches = yes varname = mismatchflag. freq var = mismatchflag.

Sometimes it is helpful to have the cases that match saved to one data file and the cases that do not match saved to a different data file. In the next example, we create two new data files using the mismatchdataset and matchdataset options. The mismatchname keyword is used with the mismatchdataset option to name the new dataset. Likewise, the matchname keyword is used with the matchdataset option to name the data set with the matched cases. We use the delete variables command to remove the variable mismatchflag from the person2 data file.

Visit here for more interview questions.