![]() ![]() ![]() This includes my solution and suggests an alternative (that may not work with PSPP): The value labels could be done similarly but I'd have to see the spreadsheet to devise the correct formula(s). You could paste 200 rows of Column C, add "Execute." and create the 200 variable labels very easily. If A1 = V1 and B1 = Beschriftung then this would generate:Īnd if you paste that into a syntax window, add the line "Execute." and run it, it would label this variable. (Note that there are single quotes, inside the double quotes, around B1 because it's a string.) If column A contained the spss variable name (maybe "V1") and column B contained the variable label, then into cell C1 I would insert: ![]() An added advantage of doing it this way is that you easily fix an error by fixing the syntax and re-running it.Īlso, if you have the information in a spreadsheet, I would try to generate the syntax using formulas in the spreadsheet. I think that will be MUCH quicker than individually clicking and editing these values using the graphical user interface.Ī lot of people are scared of syntax, but it's not so hard. Maybe someone else will have a great idea.īut to make it as quick as possible, I'd recommend that you generate syntax and execute that syntax. I find applying labels to be very time-consuming, so maybe that's bad news for you. And, I guess, ideally you'd want those numeric variables to have sensible value labels. Of course, that solves the labeling in a way, but when you import your data into PSPP, you then have to write a bunch of syntax to change those strings (of numeric variables like Likert responses) into numeric values to be used in analysis. And I guess if you had your labels in a spreadsheet you could probably arrange to use INDEX/MATCH to replace the codes with response strings that would be clear to anyone looking at the data. So, the Sex variable might have values: 'male', 'female', 'non-binary', etc. I guess the other way to deal with this is to not use codes, in favor of response strings, in the dataset. Labeling data is so important and such an improvement in the SAV file format (over, say, SQL or CSV). I don't think there is, and that's a shame. Good luck, however, remembering what the five responses 1, 2, 3, 4, 5 mean.Įlio ninja'd me last night because I spent a few minutes googling whether there was a way to import a code book. You should rename/label, but it's fairly easy to remember that V3 is sex. Yes, but variable labels aren't always that big a deal value labels can be more critical. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |