Exporting SPSS value labels to a SQL Database

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Exporting SPSS value labels to a SQL Database

Adam Troy
Hello,

Has anyone come up with a solution for pushing/exporting both the variable data and value labels to a SQL database? It appears that only the data carries over which means people trying to chart the data from the database with third-party programs cannot see the variable value labels making the data uninterpretable.

The prevailing solution from my google searches seems to be to just upload two versions of every variable (one with the quantitative data and one with the qualitative label as a string), but that does not seem optimal. Is there another lookup table one should create that links to the database file? A similar question was asked here:

http://stackoverflow.com/questions/8527800/dealing-with-spss-labels-when-exporting-to-a-database

Would appreciate any ideas!

Thanks,

Adam Troy