First time posting. Got a very simple query I hope a kind soul can help me with. I did search but didn't find anything.
Just got the huge World Value Survey. Initially imported it into SPSS as that's what I'm used to, and noted down all the variable names and labels. But then realised SAS was better for data exploration visually. However when I put it into SAS I don't get an easy way to view both column names and labels, they're all just V1 V2 V3 V4. The only way for me to check what these 1000+ variables are is by right clicking each to get column info it seems, and that's just not practical.
Could anyone please tell me how to view the labels (Which it has) in a more intuitive way e.g. labels instead of column names in the data table, or by the columns section on the side?
Hopefully my picture makes it clear.
Thanks for your time.
Use SPSS labels for column names should be the default when opening the file directly from within JMP.
Can you check your preferences to ensure the display SPSS labels check box is enabled?
That's great, thank you. It works just fine for one of the files. For the other (less than half the size) file, I get an error "insufficient error to open file." I understand from some googling that may be to do with long string names. But in any case, that's not necessarily the main issue.
I actually downloaded separate files for the World Values Survey, the JMP ones and the SPSS ones, so I shouldn't actually need to import; indeed, if there's a way, I'd just like to know how to display SAS JMP labels in such a way that they're visible without accessing column info.
Is that possible? Again, the picture in my original post should help.
Preparing a dataset for analysis is an arduous process. Besides recoding and cleaning variables, a diligent data analyst also must assign variable labels and value labels, unless they choose to wait until after your output is exported to Microsoft Word. Unfortunately, that option only leaves additional opportunity for error and confusion, not to mention the inefficiency of editing tables in Microsoft Word. Who among us have not been frustrated while wrestling with Microsoft Word?