The Excel dataset labeling workbook allows users to specify value codes and labels for their variables. If your dataset is text-based, you'll need to convert it to numeric values in order for the workbook to apply properly. If you have problems with the dataset labeling workbook, please contact Customer Service.
Note: This workbook will export the definitions of any user-defined variables you've made in the application, which makes it simple to adjust multiple UDVs at once.
This column is required and should match the variable codes as seen in the first row of your dataset. If you export a pre-filled copy of the workbook as shown above, your codes will already be exact matches and you only have to edit the remaining columns as needed.
The variable label is what you see as the "Name" on the Variables page, as well as in your crosstabs and charts. Shorter names tend to come across well.
If the variable is discrete, list the numeric value codes here. If the variable is open-ended (i.e., an "other, please specify" question) or continuous ("How many minutes do you spend texting each day?"), leave Column C blank.
Each numeric value should have a label specified in Column D. If the variable is open-ended or continuous, leave Column D blank.
You can do this for all variables in your dataset, or just the ones you want.
A variable can belong to one category at a time, have up to three missing values, or be included in an MRV.
Last Updated: 7/11/2019