Exporting data from CSPro to Stata: variable names too long
Posted: June 20th, 2019, 12:29 pm
Dear CSPro users,
I have a survey data set collected using CSPro by a third party that I want to export to Stata for analysis, but the CSPro datafile contains a large (probably +100) number of variables that have more than 32 characters. Since Stata does not allow variable names of this length, I am not sure how to export the data to Stata.
Changing all the variable names by hand in the CSPro dictionairy seems like a very inefficient solution. I've tried exporting the data to SPSS so as to copy the variable names into the labels and reducing the variable name length using syntax. However, this strategy has so far not worked, because whenever I try to copy the variable names manually from the SPSS Data Viewer, the program crashes. Possibly this happens because the number of variables is huge (over 80 000) ? (This is another problem that needs to be solved later since I am using Stata/SE 15, which allows for only 32 000 variables).
I am completely new to both CSPro and SPSS and therefore have no clue of how to tackle this issue. Any help would be greatly appreciated!
I have a survey data set collected using CSPro by a third party that I want to export to Stata for analysis, but the CSPro datafile contains a large (probably +100) number of variables that have more than 32 characters. Since Stata does not allow variable names of this length, I am not sure how to export the data to Stata.
Changing all the variable names by hand in the CSPro dictionairy seems like a very inefficient solution. I've tried exporting the data to SPSS so as to copy the variable names into the labels and reducing the variable name length using syntax. However, this strategy has so far not worked, because whenever I try to copy the variable names manually from the SPSS Data Viewer, the program crashes. Possibly this happens because the number of variables is huge (over 80 000) ? (This is another problem that needs to be solved later since I am using Stata/SE 15, which allows for only 32 000 variables).
I am completely new to both CSPro and SPSS and therefore have no clue of how to tackle this issue. Any help would be greatly appreciated!