Using SPSS syntax, does anyone know how to import variables and variable labels from an .xls worksheet (containing the dummy file structure info) into to the Variable View tab in a .sav file? Many thanks!
Hi Maria,
First of all I am a little bit confuse why are you using SPSS syntax, not its menu system. However, may be this syntax can be used:
GET DATA /TYPE=XLSX
/File = ' ... please write down the file location and file name to be read ...'
/Sheet = Name '... sheet 1 if your like to import from this sheet ...'
/CellRange = Full
/ReadNames = On (Note: the variable name has ti put in the first row)
EXECUTE. (Please do not forget to write DOT (.) at the end of command)
Best wishes.
Hullo, I do not have the data in the .xlsx worksheet. What I have in multiple tabs are list of variable names and variable labels. Using your approach all my dummy file structure containing only the variables (sans data) and their labels end up in the Data View tab which will entail the extra step of moving them into the Variables View tab.
The best way so far I have tried is to convert the multiple tabs into separate .txt files. With text files there is the sub-command /Variables var list which produces the output I am after. I would like to know if someone has done this with .xls worksheet.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS