![]() I urgently need your help on how to retrieve the lost sheets. Now I can't see the other sheets and opening the excel workbook, the sheets ate all missing. I tried to export data from excel to SPSS, in the process the sheet that was read was the data dictionary. Both are pretty outdated but they basically get the job done. It was a lot of work (and computing time) but still very manageable (and profitable for me as it made me 3 monthly salaries in a week).Īlso see Adjust String Lengths before Merging Files and Merge Many Data Files. I recently worked on a similar problem involving 52 inconsistently coded SPSS data files. sav files -which may require things like adjusting string lengths. ![]() sav files with GET TRANSLATE as pasted from SPSS menu. If you master some Python, you could use os.walk for collecting all paths to all workbooks and have SPSS loop over them and convert them to. That's a lot of workbooks but each one holding a single sheet renders the structure of the problem fairly simple.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |