Real application Assignment
Each and every step should be followed should have clear codes that are organized and that which Follow a clear explanation following each line of codes-No room for typo errors.
1. Write organized, sequential code with no errors for dataset comparisons.
2. Explain each code line followed by hash tag on what it does in clear.
3. The results to be generated on main screen.
4. The output result on screen should only show what are the student ID no that are mismatches and the variables that are effected for each.
For instance student id no1234567 is a mismatch it should display which variable was a mismatch as well that could be for instance how often you eat popcorn?
The mismatch variables could be more than one for each mismatch id on table so all the variables that were effected to be reported?
5. The comparison between two data sets is based on each table to table comparison, each time table to table comparison is made one output table that should contain only mismatched id no and variables that are affected to be reported on screen.
6. A code is already provided to directly Import datasets accdb format to Stata and all the pruning of data set ready for comparisons.
One thing missing in the pruning part is that you should add a code line for finding which ID no was not entered or missing in which data set and what table? Say dataset may have an id no that may not be in DATASET B so your code will find and display such id no missing in each table of the data first along with the data set in which it is missing.
7. For data comparisons each table from each data set needs to be compared at a time and each table should only display the mismatched student id no along with the variables that were affected.
The zip file contains sample data file, the code to start with which has all the prior pruning for data required,(EXCEPT FOR ONE THING THAT YOU WILL ADD- FOLLOWED BY A HASH TAG EXPLANATION OF CODE LINE), an already written data comparison file for a different comparison -( This is just for your review on how you can do this it also includes a line to identify the missing entry id no while pruning data ), an ASGN REQ doc.
IN SHORT-
1. Missing student ID entries indicating on which database set it is missing and in what table is to be reported for each table while comparing two data sets table by table.
2. Mismatches for student id no entries should be displayed for each table to table comparison in datasets along with the variables that were effected and reported as mismatch.
Attachment:- Assignment Files.zip