![]() You could merge the data from these two sheets using lookup command (if you are using MS Excel) or maybe you could also use some third party software such as SPSS, stata, R, SAS and so on. Please note that the cases from _parent_index should always be matched and merged from those with the _index or vise-versa (i.e. The two sheets can be merged based on your analysis requirement. Theoretically, the number of cases in your first sheet (default sheet) is always less then or sometimes equal to the next sheet (that contains the repeat group response). And specify the style, name and location for the index worksheet. Apply this utility by clicking Kutools Plus > Worksheet > Create List of Sheet Names. If you go to the next sheet (which should be your first repeat group sheet) you should see a variable named _parent_index. Activate the workbook you want to build worksheets index. This dataset contains a variable named _index. Please note that the first sheet that is generally seen when opening your xls dataset is the main dataset.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |