CSPro Users Forum

Dear users, I am trying to export the CSPro data to Stata using the adjusted dictionary with shortened variable names. I opened CSPro, chose the Export tool, chose the adjusted dictionary with shortened variable names when prompted to select a file, selected the full dictionary to be exported (one f...

For those with the same issue: I managed to make the copy pasting work by cleaning the clipboard before copying the data in Excel, and by copying using the 'copy' button in the right click menu instead of Ctr+C. (Not sure if any of these were the actual problem)

Thank you for the answer. I am trying to apply the solution, having used the macro to copy paste all variable names and labels in excel. I have then shortened the variable names as per your suggestion in another sheet, and copy pasted these shortened names into the information copied from the dictio...

Hi all, a while ago I posted about our problem of exporting a dataset with variables over 32 characters long to Stata. The survey is split in two parts, and the problem of variable names being too long occurs only in part 2 of the survey. Dictionary 1 gives the structure of the data collected in par...

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...