Exporting Variable Labels to Excel

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Exporting Variable Labels to Excel

Eric Graig-2
I am trying to export data in an SAV file to Excel. I have checked the relevant box in the 'Save As' dialog:

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdsAAADBCAIAAAAIIo0qAAAgAElEQVR4nO2d23Mb2X3nu1K1u5XXfdh9239gXzZ+WFelMihAs1umq1JO4vWWEyfeim2KIDWL2HG4tsdjJr7NUKQIjT2+jMRMfJVEkyI5GnmSmZHEG0iABHgBcUcDjb6j0biDBEhq4lTNPhx0o68gSIIABP1+9SlW4/Q5v3O6CXzxw+k+/cM+AgMDAwProDnGnBybMQTr9tjAwMDAni8DRQYDAwPrFWumyLXcWreHBwYGBvYcWTNFzoTHuz08MDAwsOfImikyv/vVbg8PDAwM7DmyZorM7nyl28MDAwMDe46smSIzvr/p9vDAwMDAniNrpsiU9yXjRtT0wMA0pd/W2soo2kVNDwxMk+qXJk1kp9joisoT1rBTGrds0njAwMDAesOaz1p8OZ+6Z9CoRUXW7JJfnk+RVa/bYacPAwwMDKyj1kyRhX0H4b5q0MhQkanpgdHReig7uoJUFUW0JDX9iU+8Nq54WW8iR76S2tbbDIyOnqbIK6NyrExND2AD09RH1PTAwOjogJFDZd16naujA20NuMHAwMAubM0UuVAoJNe/ZNDITJHrQijJpzooJs1eyg1kD9T0AGY+a6FoNTBNrYxKVSVlbjhSDWlgmlLWgRgZDAys5+wURU64vmjQyEyRFYFoXf6aKLJqahgbmKaUXrUxsfGsBTU9oAhyFe3rm4pWDdFvaQYcDAwMrAt2iiLja39t0KhdiqwW2TMrsjTHoY95QZHBwMCeRWumyJ//IBVf/T9GraRJAOXEwFkV+ZRJhlMVWaotj6XFWQtQZDAwsF61Zor8ybuh2MrnjdvJcw4GAqe+cidpMal+SX1kfmUPGxhodvcb9nfLqpnmun43vbJXL1CpcH081EdgYGBgPWHNFDm19qeE59lZSA0xLxgY2DNuzRSZ8Pxtkf2Xbo+wZQNFBgMDe8YNno8MBgYG1isGigwGBgbWKwaKDAYGBtYrBooMBgYG1isGigwGBgbWKwaKDAYGBtYrBooMBgYG1isGigwGBgbWKwaKDAYGBtYrBooMBgYG1isGigwGBgbWK9ZMkR1jTgAAAKCTmCqy2Q4AAACgw4AiAwAA9AqgyAAAAL0CKDIAAECvAIoMAADQK4AiAwAA9AqgyAAAAL0CKDIAAECvAIoMAADQK4AiAwAA9ArnV+TYw7e3Rq+yKbbrxwAAANAfnEeRYw/fdg99ZumTH1v65MeCP7/V9WMAAADoD86myPjjR56XPoe0GLH62Re7EiaznimrdcrDCBybYZkFO4Zh9oWLu2odz4QNQyb1qy9p1injm7RiGIbZZ4V2+TzHMerLz3c2AEDD9bcedP1pPr3J9bceNDlvZ1Bk/PEjpRbLdCVMloUDybFS1zrbu2/SitlnBX1Jix7a6PMiB9KkBADOyvW3Hlx/68HTkw9PTp4eH58cHZ0c1Y5rteNq9ah6WDs8qB0cVPueSvmwXDooFsuFfCmXK2TFfCaTFQQRnRyzU3e2GFmerOh6mCwJh1aO2dkRTVCpKWE9U1briN2qKZlyu29Y7SN247YjkxM2TTBrnfAZjQepp23So1I0OdRFrepBPYZh2MicpH1n8qmsLG9rAmrFkY7Mum8gV+Z1VGfDwwja8yYF9fJRAIAZjjHnycnTk2Mkx8e12nGtelQ9PEJaXKkcVsr9T6lUKRbK+Xwply2IYk4Qsul0hufSLMu37WmcsYdv90iYzHqmrFabFcMwRUCnjO/m7KowU1WC2SY92lDU7b5hxUbm6kG3vIFqanV/zo7ZJ6asGvn2oBKtHLOeKavaIWcUip7Zp1qs1T8aRuaYxpFyym8dgzqYfdbobGjO2+yIJM31tt39zAO9DFJkFB2rQuNKtVI5LJcPyqX+p1goF5AcZ3KCkE3zGY5LswxHU2w7n49sFiYzONHJf7kkN75JayNka4R1UihnUKKQQhRd6tRKq3GcpEpy73P2xjdBQ7BMZhhkLVP6MVTk1n1ybGbOLg1SK991BVdNtct6ra8jyavqbMwOG5y3dsxoA88DjjGnLMe16tGhLMflw3LpoFSsFJ8D8vlSLlsUM3lByPJ8hmXTDMNRFJNK0e1UZLMweW/qO538l2skpi5zCu2rV9OXtEmR5ZfIiXIaQdNp64rcuk+5pOFwdgTThPY6RXbPDhvUMVNkI+WVdbnDE/fAs4VjzInmjlF0fHBQVclxoVzI9z+5bFEUG3JM0xxJMimCSibINucQMQyTlz/1cToc7di/XCU3shgZzki0UmKoyOazFnqRleNZVKKcaW1x1uJMPjk0e2AdsVvretqYVZgdMYuRZZ1V1TGbtVCfJc+ETTk8mEoGmuAYcx4dHdeqx9Xq0eFBtaKW43y+lM/1P1kxnxFyaV7kWIGhOZJkCIJKJlJ4PNlmRe6FMFmjaPJP/gtd2dNdRpOv7Nnt2qhQc7GuPgaT3/VyZdmJ4S0NZ/JZ3ysfpny10D6Cvj8MFJmeN6rT0pU91WDUk9Ed+6cDzwqOMSeaPj48lOaOSwelYqVQqBTypVy2mM0W+p6MkBPSWY4VGJqnSJZIUolEKh5PRiN4+/Ps9UKYfD7OcXeX4e0TAACY4Rhz1mpovqKGLuWVipVioZLPl/O5YlYsiJm8GRlhd8qG2aZ2lYW+qSuY7aZPyDVr6LtpM6qjLzer2V6EdJbnMiyTpkg2RdAJnERyHA7F2q/IvRAmn4/WFVlxjxr8SAeAM+AYc1arR4cHtUqlWi4foPvACvlyLlvKZgtiJp8Rck0Q5q9htpu+dLb+Mr07ZcNG5rPNW5l68960KbwZllwGPCdyrEBTXIpgkgkyHiOiUTwcigb2I5eSi/rZDZMBALhUHGNOxXxFpVisFPLlfK6UFdG9BzkhnW1Cmt++YbtyY0usv9xy2mxOLy8K6ax38ko9ShpelHZdG7ZhGHbt/uYUqmZeR1ni9PJiev6aqia/fUO6X982ud18kKfCsQJDp8kUSyQpPE5EI4lQKBYMhP17wUtR5KTb/YyGyQAAXCqyIpfLh6VipVAo53PoVrBCRsil+SzPic3ZnLRh9kW0fd+O2SZ9PCdynimbdWqTzXDs4jA2cp/NcJ4pG2ab9GTkvR7jOtjwXIZjfZNWbHguo6mJuhiey3BzI6hTue2p42wCw6RRgJzAyVg0GQ7FA4GIfy+4s7N/KYrMsRnvy9cgTAYAQINjzImWEZdKB9K6tWJWLGQENLsqnupBvVCrcQH5GbrpnqZ4MsUmE1Q8RkTCeDAQ9ftDuzv7Pu/eZSmyWZi8O/6trr8nAADoFo4xJ7qaVyiU87miPHec5tHFLoGh06cyO4QNzfDu6zZsaB6V0DPDGDY8S/E0NT+E2SbWeXp90mqddFM8Q6fR9oZhHWx4luIZOu2+brNe32rUlDwrodfrzwsYmuFbGacZZIolkjQeT0UjiVAwtu8P7+4Gtn17W5s7l6XInEmYvPTJjyXd7q6/LQAA6AqOMWehUJK0GK0hFutazPA0xVEkeyqka8JisV+1WMddTL1kxo5dna1vYNZxF0O6JiyWCVeKkepPrN0dMqiDYVdnGDLlGbdgV2fqrdbWJiyoglTuGreithTJzlzFLOOeVsZpBpGkG/MV+5G93eD2tt+7teNx+y5Rkc3CZO/L17r+tgAAoCs4xpzZbF4Uc5lMVkiLPJ/hWIFl0jTFUySbIhgiSZ9KMrH+qgXDLNdXE5RUMjOIZhUGhwYxbPAOlVy5bpEqoO0V3LDO0KAFFc7INVcTVPLOUH3OYnAGdXF3UJrFQBUSM4PY0F2jjVPHj8dTKjn2+b3enU2Pd2N96xIVmYMwGQAANY4xp0KL03JcnCIYIkklcBKPp/qeaCQRDsWDgYh/L7Szve/d2vV4fBvrm2ur7stVZAiTAQBQ4hhz8rwgaTFLkkyKoCUtJmKxZCyaaAJmYs1b9RrhUCwYiKrkeGPTteZeWV6/XEXmIEwGAECBY8zJMJykxVQySSbwFI4T8VgyFsUjYTwcivc9gf16dOzz7m56tjfWt9bW3CvLrqUnq5euyJ0Pk7uemgUAnh/O8fEkSVrSYgLHk/FYQtLiWDAQDexH+p69vSC61w3JsWvNvbLiWnqy+uiD5SantD2KzLGZ7e99rZNhsmPM+REYGNjl2/kUOZlMSVqMR6N4JByXtDjs94f8e8G+Z2fbj+TYvbGFJiuePFl9/Gjp/fced0KR6XB0+VMf71iYDIoMBtYZO4cio1Ry8RgejcYj4VgoFA0GIpIWB3Z39ne2/X2Pd2tXkmPPyvL60pPVR4+W3n/vcTvz7DVnb+o7HQuTQZHBwDpj51BkDnJRm9O2XNSnYhYmu4c+A4oMBvaM2vkUGTgf7VRkzjxMjj18u70dgSKDgXXGQJE7ifaZGqxnymofkTJN1Hc1SSlvnViYtDaeIEz9YvC9T/y3DoTJakWmpgfkexYHpqnW3mjKRmdqS00PNKvY8Du60tpImng+pS/TAai6Xhlt7RhXRs/cF1j/GyhyJ8E0OT3VSeGk5HUmaedVG1JipLWOhMkKRaamBxQyszJ6ViU8s+g1a6AczMpo618P5xyK6Ri0iiy/1u1sd+9g/WagyJ2kEd4iFPqrSDdn8gQ8zQZ6ut1//A//rgNhckORdbrXiPTk2BBJEDU9MDo6qgtftUKkafWRLuqlpgcGRkcHjMJgtS+KWqEolYP6ToWHgemV6QFpl94zNT0wME0ajlw3znovA6OjTRRZ8Up9WNKrgWmqeZyv3dd4jY5OeQ5A5PvA4MpeN6/s6RW5Sdp5A0W2L3AdmU2WFdn0M6/YUdegRniokiiVB30rheTXHTTiYLXUGRUomilcyR6UG0h5G6ovjblerh55k6NrODEeVb1pw4POp36Xypf6bDSq6McGgtwPdg5FRjd4vbOefGc98cCVeOBKPFjD317DF1fxxdX44kp8YSXW98wvx+aXonNPInOPw795FPrNB8F77wfuvb9/yt1vKPf7KYpsknZeq8hSSnkq9OTxJy83TDZUZFXUqJo8xdQaZCbCzVt9pGug22eoyIrChnpqtE+rvCrdJPU96sapOQ+nK/JHuuhWE9wazjsbng1dNF3/mUJND5x5Kh2s5+wciuwYc06/E5h+ELj9IHD7wf6tt/dvvb1/a3H/zUX/m4v+ny7sPQ/8ZH73x/d3fzS386PZ7TdmfT/8jfcHM1s/uLf5+r3NJqfU6MqeRpHN084bbEgp5f/iL/7uUsPkprMWkiKbTik0VeSmExFN/BhX/ujSFFk9ztYVuXF+9JG7HPprdjU/wI8auqwMlw2/nsCeOTu3It9+EDg6OqnVjqvVo+ph7fBAyrxXPiiX+p9ioVzIl3KNJ0RnOC79+l3PzTueZorcrqBVA5tiVz/74uWFyaZX9mQ5aRSrZgCoehMTRda3UqrSyihmqI8N01zZk6JsM+0zUGSTWQtNj4ZH1+ilhSt7cqE0TJUia3apfKnOhktxpVC1b2B0FCLkvrDzKfLtB4HbDwK12nGtenQoy3H5sFw6KBUrxecAlMtKzOQFIcvzGZZNMwznvOOe+vVZnsaJ6ezcohn8+S3DMDn481ttVeSPPlL/iG/IgP7K3qmKrG/1keGVvSbzpI2x6OcA1AGwkSKbXdnT92h2ZQ8bGGjp7jepdHRUUvCVUQzDBqZJ413abpQBsX6G4+z3vID1qJ1fkd/eR9HxwUFVJceFciHf/+SyRVFsyDFNcyTJTP1q48YvN7oQI3PmYfLqZ19kU2x7FRkMDOyS7LyKvH/r7f1q9ejwoFpRy3E+X8rn+p+siFILihwrMDRHkgxBUDd+uT75C1d3FJm7zDAZFBkMrDN2PkVGV/MOD6W54xJKhFopoLzU2ULfkxFyQjrLsQJD8xTJEkkqkUhN/MJ1/edrXVPkywuTQZHBwDpj51fkRf/BQQ1dyisVK8VCJZ8v53PFrFgQM/k2kll4SZ6VG1nItdf5uRHSKPF2miLZFEEncDIeT17/+dr4zy7/ifVNuKQwGRQZDKwzdm5FfnPRX6lUy+WDUqk+d5zLlrLZgpjJZ4RcuxC8N23YtYV0Vtq+MuXNttH/ueE5kWMFmuJSBJNMkPEYEY3i4z9bee2tlW4q8iWFyV1feAMAzw/n+Hi+ueh/c8FfqRyWS5VisVLIl/O5UlZE9x7khHS2XaS3nDab08uLmnLv5JV62Dy8iF7aJrflXWg7PX9NWae9cKzA0GkyxRJJCo8T0UgiFIq99k/Lr/7jUpNTeumKzF3yTRcAAPQasiKXy4elYqVQKOdz6FawQkbIpfksz4lt5H59xcTIfTaDSjjPlM06tclmOHZxGBu5z2YUJWilRaMEeRiey7R3VAyTRgFyAidj0WQ4FA8EIq/+49L3pp90WZEv9aYLAAB6DaTIP13YK5UO0M0VuWwxKxYyAppdFS+jU2kt28gcY/A0Ho7NzNmlJceNRcgNUz7epy3QFE+m2GSCiseISBgPBqJ+f+j700++e6sjWZ2aE3v4NoTJAPCc4Bhz/nRh7yf3dwuFcj5XlOeO0zy62CUwdPqScF+3Wa9v0TPDGDY8S/E0NT+E2SbWeYZO0zPD2ND87BA2NNN4eXkjIVMskaTxeCoaSYSCsX1/eHc38N3bj7/z5qPuKzLHZtxDn9Er8vKnPk6Ho11/AwEA0EYcY84f39/50dx2trGGWKxrMcPTFEeRbLsgZ+wYZp9JMRTJkinPuAW7OsOQM3bs6qy01zruQntnr1rsVy1SZdeEBbOOuxi5VRtHRZEskaQb8xX7kb3d4Pa2/zu3Hn37px/0hCKbhcl7U98xrJ90uze/8tcazCoDANA7OMacb8z63pj1ZTJZIS3yfIZjBZZJ0xRPkWyKYIgk3UZWX7XKkw+WV9eJJJ1MzAyi14NDgxg2eIdCNe8OYtjgjNwweWeo3kxR2C7weEolxz6/17vz7Tff/4efvN8TisydMUzGHz/SV978yl93/d0GAEBzHGPOH/7G+8MZL89nODYtx8UpgiGSVAIn8Xiq74lGEuFQPBiI+PdCO9v73q1dj8f3Dz95b+zH/9IrinymMBkUGQCeURxjzh/MbL1+b5NheJpiSZJJEbSkxUQsloxFE+0CM7I2+j834VAsGIgq5XhjY/Pvf/wv3/rRP/eKInNnCZNBkQHgGcUx5rx513PzjockmRRBJZNkAk/hOBGPJWNRPBLGw6F43xPYr0fHPu/upmd7Y31rbc39rR/98ytvvNtDitx6mHyqIkPaGAC4bJqnIGqiyM477qlfbSSTZAIncDwZjyUkLY4FA9HAfqTv2dsL7u7s+7x7SI5da+6VFdcrb7z78g9+6+gdReZaDpMNFdnz0udkOb7+1oOnJx+enDw9Pj45Ojo5qh2rno19UAUAoEXQs9mKxXIhX8rlClkxn8lkBUFsnoKoiSLf+NX65C9dk790Tfxi7frP167/bHX8Z6uv/dPKa28tv/rW8qv/uNT3fO/2k+/eevztNz/4h5++jyYrXnnj3T//5vw3Xn+ntxS5xTA5sbqir7P2V5+U/+UnJ09PjpEcy1p8hLS4UjmslAEAaBXpOZlFKeeFmE5neC7NMnwT+TAD6fj/fuXBZ1558JlX3v7MK2//r29KvLz46eeDP/vGwp99Y+FPvz7/p1+f/5Ov3f+Tr8196v/NfWp09pQ8e51XZI7NeF763KlhMuXfP1WRj49Ojo5OarWjqj5PAQAALVMolPP5Uv324bTIcwLLphmaoyj2HIrMwaTieSeCLi2rE7Ngt055GMFwb9LtNgyTvS9fa12R0WQFio4PpTwFZcWDsQEAaJF8TsoIh+SY4Wmao0gmRVDnU2TgfFyaIku5UM0qeF++ZijKSbcbVThVkdHcsSzHaKaiVDoooQdN5UsAALQIWugsPdKXpyk2laKJJJnAU6DInaTxfA3PhA1tNx7AoU5Tjeood7GMb1JaLKN8Tkej3Dp19y/+08Crq/Xy2RHMvsB6pqzWka9f+X1DRf7up/+cYzMss/DV3//iaYqMkiqitDGHKDouFhoPmgIAoEXqCTq5DIueWJai0W0SsVgCFLmTYCiSZRn0hDpBGdvO2TH7bCPIlXexzIIdG5ljBKSwXP2pS/VHLikru3725tInPzZr+cPF1WUk0/ZZgfVMWTHbpEfwvvwFQ1H++psbXAsxcq12VD08OjioHVQOS6XgD16sfze89KCQzRazYqEDiJk9pw27tpg32OV7/YrtdZ/v5hXb69sZgwqNOsKDa+Z1mne0PXXlytReViyIiy+hjQsf0TunDgboP4R0Ns2LkhwzyQSJ40QsikfCcVDkToKd6Ql1mgfcNV7qomnWM/WXV76x9KmPIyV99McfD75+tS7okrKbzSb/9PNf4FpQ5Gq1fmdFuRT8wYvYi68HC/lyLvvwGnZlypfLCPkOIKR3p2zYyLxBd4L3ps1205c+fSSt1DTsSPDetA0/yAh5340rtuGXpoZfwlrr8ZTxzL9ku7HbmRMIdBfDBW8YhuFxIhpNhMOxYCACV/Y6emUPxblyOCyHvXrY2RH07FGWWbBLjxxVyrQyoKZXXlsYsGj0dPovP8/ghDIMX/38fzebTT5VkQ8Pa2i+orT/xosvvrGH8r9mi9u+Bz6vKolAPV/AltNmuzZsQyWLN+ob22bl+jQEBhkKbNeGbdjwvKjPR4BSG2xtTkl/jbu2Wl/5JpoKsjm9vKhPaqDvSGZ++MqNLbFRTTfI9JZTmma6Ns+LaX77hvRaPkCDxAr89g3btXldUgagLzGS41RMkmO/P3QORYblAue+xRtjmQW7dcRuVT7m2TbpEeRJBpUiN+Jo26RH8EzYZPmes6sCau9XPmUotauffTF+72tyFz8ymU32vnytFUVGN1cU33FgL/1Wk6SA80zZUO4AdnEYk1IG6DesU54m5eo0BHJ2gIZzz5QNw4bnDPIRKJ0076LRkaETdUeNMShGxXmmbPbFzUmbbdKnrmCb9GR4TtyctGH2RW5uBLMvKtvqEyugtpuTtranVAB6FqUcKxNe7PuDuzv751Bkh265QO35Wy6Asgvm86VctiCKOUHI1m/xZpvd4o0hMVXGxWZX9qRH9GOYfcQuRcRzdnmCo3FnhVkap8blu//5x/Z6XL1gdtPFd//znzdXZPQtVCodFN75v9hLD3PqJAXKYB/9AmjMg6s33O4bhuX1DTmm9DS+nOSroA3nutkepXOzLrR7dU70HTX+HafdzaKvYDjLpJm20h8g8DyA3heahBdoEfC5FVl5f2pVXi5QOSyXD8ql/qdYKBfy0j2FQjbNZzguzTIc3fQW70u5+y3l217/gnGMLLNy7XNoPYjZbLLhYuvVz74o/8vlr6Ds9us2201fOivUE8YIDJ2mZoaxq/dpiqcpfuYqNjTDUa5Jq2VyndRuuMzKZ+wYNjxDchR5fwizXXdxyBtN8evjNuv4psq5ojuE0rlpF5q9Oif6jjT+10lOWV8/AH0FylW/EQZ5Q51qnCv7BZ4HUgTTkONgdN8f2t0NbPv2tjZ3zqfIshzX9Ku3ipXic0A+X2rcxMJnWDbNMBxFMakU3WlF5tjMv/+93/vKf/0vp4jyp1+IPXybYzO7499qXlOJ/C+vr/gU80J6e9KG2SZ9PCcw9PwQhlnGPam1CQtmnyGYFDF7FbOOrzGptQmLZcJFaDfWVk3K7w5hg7Nkik3dtWOYdXyNIVMsQu0cu3qXSa1NWFAvhGfcIpVIzk270O/VO1F31BgDMXsVs88QjRIN8oHXD8EyMfuqFR0RmWJnBjHLa556NZRYQeFqZlDVF9D3JBOUKv/QTsDn29va3HZveM+nyPJygaq0equiWL1VyPc/uWxRFBtyTNNc/Ul4CbILioyIPXx75dMvNFfY3fFvUf79ZemujNYVWRRzYiYrCGKaz7DsvDx9YnnNTSTpZIJa+b4FlQz+mkwmqMTyuOWF8RWc1Gwsm5XHpTQEX7o6KDmRkZxbLC9I/n99tT6CL83I3S0370LZESpXOzHsSObOlyyvLqtKkgkqgc8MYlfv4NIh193VS+58STpNL4yv4KTkp9FdMkElcNerL9TrA88J8RihTAe37dvb2trxuL3rrs3zKvJxrXpcraLlAio5zudL+Vz/kxXzGSGX5tGvdo4kGYKgkokUHk92TZE5NkP59w2fYqGZoNgavXpWRUZazDVWfLJkiiGSdDJB4vFUPEb0PbHHr77wxbvtd/vLwRe+u9r1owM6SSSCh0MxOf/Q1uaO2+1dd3lWVzfOp8iNxxuguWO0mLZQKaC81NlC35MRckI6y7ECQ/MUyRJJKpFIxePJaATvpiIj/D+83vq8RIuKzLI8ehIKmaIJgkomyASewuNEPJaIRvBI+Lng0bdf+KNvL7fRYTj0qy/80fceheJdPzSgkwQDUc1khcvlWV1ZX3qydl5FRvMVNXQpr1SsFAuVfL6czxWzYkHM5NtCxndTup8Tw7ArU75cS62EByO2mz6hpcrnRqgvSU9TJJsi6AROIjkOh2LdV2SOzeCPH61+9sU2KjJFMZIWp3CcwONJSYvjoWAsGIgCANAi/r3GpTz3hte15lldXV9eWnv8aOV8iowWcFUq1XL5AF2EL+TLuWz9ARoZIdcWpNVV2YyQE+avYdJ2660uD3SXAU1xKYJJJsh4jIhG8XAoGthvtuimo0/jpMPR1mcnTlVkgiAlLU7EYrhCiyP7/rDfHwIAoEV2d/brkxUb3nWXZ3VlY2lp7fGj5Q/ef3I+RVbMV1SK6OFfuVJWRPce5Nq1vAWtw/LyonJbs7BLszCq8dJkTVa7QDd9kSmWSFJ4nIhGEqFQLBgI+/eCvaLIiMD0D1u/jmemyGjdS7yuxfFwOBYKRiUtDu7tBnZ39gEAaBGfd29rE13Kk+T48fIH7z85dw4ReQFXqdh4+Je8gKtda1uUi6q4uRHMaGFXs4VRujVZbVx3w6CHhBCMctGNfy+403TRTXeeWJ9YXVn7q09eRI1+fLcAABhASURBVJE5WDgPAJfPufPsyQu4pHVrqgVc7VISxRquxjKuUx+/01io1fQxPheEpnh0W2H8LItuuqPIHJthcML39397EUUGAKA3cYw50dW8QqGczxXlueM0jy52CQydbgv0+qTVOumm+EbJzDCGDc9SPE3ND2G2iXW+UbO+MIqXW9Ezw9jQfLsGo4FMsUSSVt3l3cKim64pMiLym1+fdQaj6+82AACa4xhzFgolSYvRGmKxrsUMT1McRbJtgXRNWCwTrhTTKJmxY1dn6xuYddzFuMatqIQi2ZmrmGXcI7ciXRMWzDruYsiUZ9yCXZ1h2jUwimSJJN2Yr0C3FW77vVs7HrevdxWZa23JtRI2xXZ9zAAANMEx5sxm86KYy2SyQlrk+QzHCiyTpimeItkUwRBJui0kV65bLNdXE1SjJCEt7BocGsSwwTsUkaTvDsrrx66vJqh6HbR9Z6i+a3CmXaNC4PGUSo59fq93Z9Pj3Vjf6mlF5tgMm2JbX0hN+fe7PmAAAJrgGHMqtDgtx8UpgiGSVAIn8Xiq74lGEuFQPBiI+PdCO9v73q1dj8e3sb65turudUVGtLLkGhQZAHofx5iT5wVJi1mSZFIELWkxEYslY9FEW8B01i7PFycciqEbvRtyvLHpWnOvLK8/G4rMtbbkGhQZAHocx5iTYThJi6lkkkzgKRwn4rFkLIpHwng4FO97Avv16Njn3d30bG+sb62tuVeWXUtPVp8ZRUY0X3INigwAPY5jzEmStKTFBI4n47GEpMWxYCAa2I/0PXt7QXSvG5Jj15p7ZcW19GT10QfLz5gic02XXIMiA0CP4xhzJpMpSYvxaBSPhOOSFof9/pB/L9j37Gz7kRy7N7bQZMWTJ6uPHy29/97jZ0+ROfMl16DIANDj1JfUxvBoNB4Jx0KhaDAQkbQ4sLuzv7Pt73u8W7uSHHtWlteXnqw+erT0/nuPT8mz1/V/XnP0S65BkQGg94EltedbBtnriszpllyDIgMA0K88A4rMqZdcgyIDANCvPBuKjEBLrkGRAQDoV54lRebYTMq3zeBE14cBAABwGTxjiqynxdn0ro8TAJ4r4Mpe317Zaw5SW54T03xWSOfETD4rFnLZYj5fKhbKpWKlXD4ARQaAToJu8Hp68uHJydPj45Ojo5Oj2jHKhVo9rB0e1A4Oqn0PSr9dLJYL+VIuV8iK+UwmKwjis33326k4xpxmcixkiuXywUGlCooMAJ3EMeY8OXl6cozk+LhWO65Vj6qHR0iLK5XDSrn/QdkF8/lSLlsQxZwgZNPpDM+lWZZvokj9oMiGcry8nRr4u4Vcvnx4UNMc/5wds88K8jZmnfIwUuoBaRuBStz0vF1dfnH0fZmVm9XsPCyz0PbzcMYB+Catjf9dK+ezx4+oX0GKjKJjVWiMMu+VD8ql/qdYKBeQHNefEJ3huDTLcDTF9rkiIzlm2KxSjl94afbKl+fzhUq1eqQ5fs+EDaVvQR/ISfvIHCMoyzV0UhN7WpG7PZL2K3K3j6hfcYw5ZTmuVY8OZTkuH5ZLB6VipfgcgHJZiZm8IGR5PsOyaYbhKIpJpeg+V2Qkx5/46sKSl5Dl+A9HfvPiV+bzxYNa7Vhz/KxnympfQBv2CZ9nwoY+5HN2KSuXdcRuxTBsZNZ9w2L55jdQNhhNYi4pZxdCqebytmfCpqys8Yy0wLyOsqRZ16xnymofsat3NXFrnViYtDayimncItXTpx1rlKuHrfkO0zc3OaL6eZgzOi7N4Bsl1hG7FbPPCq30oj80TYnmiLr+Tu4nHGNONHeMouODg6pKjgvlQr7/yWWLotiQY5rm6k/CS5B9rshZscByuSt/M/8/vrzwwWYSyfELL82t+5la7fj46ESryMyCHRuZYwSkxezsiHXCJxeynimrMoWidcotqacypFJOfXBK3WR8k1ZZ2VFJC55VdRqiY58VNDWNu0ZtlU5MulZtGLllZ0ckaa63NThGVY/1I6rX0TVv9Kg8IvV5UA3AePDqk9OsF+1J0Hs2LAHaiGPMeXR0XKseV6tHhwfVilqO8/lSPtf/ZEWUWlDkWIGhOZJkCIJKJlJ4PNnnipzLFrl0/sUvz1/5m4UrX76vkeOTk6f645+z2yY9vkmrJCvWKY8icJY/pVrdbJq5thFiK1Pe1uuqNJrTqpu6DqaaRamPYXbYrGv9l0GTrjUberf6xL0GHUmCyBl/PajDUsVRK4+ofh6MTqlm8MrfHw0lNeml8Y2o82xQAop8OTjGnGj6+PBQmjsuoUSolQLKS50t9D0ZISeksxwrMDRPkSyRpBKJVDyejEbwPldkNHe84iMHvrpo+/J9jRw/ffqh/vg9Ezb7bP2qDsv4Jq0jc7Mjit+/5oqs0ykZtFdWKHZ2BFMHkgaeZ4cN6pgpsknXJmJk3LWBIhu5lSXP+HeAuSLrm5+uyJpJGN3g9YrcpBfVSdB71k/4gCJfAo4xZ62G5itq6FJeqVgpFir5fDmfK2bFgpjJX5CMsDslTW6NLOQu7rDh2XfTZrvpEy7qU0ijxNtpimRTBJ3ASSTH4VCszxVZvu+YTRcGRhc1cvzhh/+qP37WM2W3qmZ+MaPf0QazFuof4CqfzILdOmK31vW08ct6dsQsRpYFUVXHbNbCpOsmYqTvWqvIOreeCZtSbY2DcfNZC31z41kL5XnQ7DUcfKM740EazxqZzJYYjgRoI44xZ7V6dHhQq1Sq5fIBug+skC/nsqVstiBm8hkhdxGE9O6UDbPd2M0IOSH9YAS7MuXNXtBnw7n3ps1205e+qEOeEzlWoCkuRTDJBBmPEdEoHg5FA/uRPldkJMcHlerhQQ1dylPK8e9+9zsDRZY+2/WXUlzGGSoyPW/HTrmyh5izK35HMwvS1bYRuy5aVHnW1jn7lT2NGJl3bbChcztnl3/Yq+/6QG7VV/b0AbKmeZMjUpx8xV7d4LnGtT6bVfo2MupFN3XT9Mqe5oi6/k7uJxxjTsV8RaVYrBTy5XyulBXRvQc5IZ29COktp83m9PIieundWvRuiUI66528Uv//Di/Wqw1fG1aU1Avrla7N86KQzqbnr2lbKZyfG44VGDpNplgiSeFxIhpJhEKxYCDs3wv2uSLLclytHunl+N/+7d9ghUgXgTj0OURW5HL5sFSsFArlfA7dClbICLk0n+U58SJwcyOYfVFb6JmyWac22QzHLg5jI/fZDOeZsqENuYRdHMZsk54Mz4mbkzbMvii34jnxvh0bnssoSy4Cw6RRgJzAyVg0GQ7FA4GIfy+4s7Pf54rcCqpjbmpdP6I+AxT5OcQx5kTLiEulA2ndWjErFjICml0VL+jf7IqO6QVt3R1QKlcKa+P1XpriyRSbTFDxGBEJ48FA1O8Pocx7/azIAAD0GuiXqxQdF+W54zSPLnYJDJ2+CPT6pNU66aZ4VeHMMIYNz1I8Tc0PYbaJdV6uRlNbE1ZViarV0Pypzs8BmWKJJI3HU9FIIhSM7fvDu7uBbd/e1uYOKDIAAJ3DMeYsFEqSFqM1xGJdixmepjiKZC8CmfKMWzDLuIciWTI1exXDLOMecsaOXZ2lSJacsWOYddzFkK4Ji2XClWLIlGfcYh13MWRq9ipmHXcx9WqWibW1CQuqnPKMW7CrM41WFxwkkaQb8xX7kb3d4Pa237u143H7QJEBAOgcjjFnNpsXxVwmkxXSIs9nOFZgmTRN8RTJpgiGSNIXJJmYGZSmGiyvrqtKBocGMWzwDpVcuW6xXF9NUMnE+qsW66srFJGkkyvXLfV2Q3cTFJGkk3eG6gWDM/UKluurCeqCI8TjKZUc+/xe786mx7uxvgWKDABA53CMORVanJbj4hTBEEkqgZN4PNX3RCOJcCgeDET8e6Gd7X3v1q7H49tY31xbdYMiAwDQORxjTp4XJC1mSZJJEbSkxUQsloxFE31POBQLBqIqOd7YdK25V5bXQZEBAOgcjjEnw3CSFlPJJJnAUzhOxGPJWBSPhPFwKN73BPbr0bHPu7vp2d5Y31pbc68su5aerIIiAwDQORxjTpKkJS0mcDwZjyUkLY4FA9HAfqTv2dsLonvdkBy71twrK66lJ6uPPlgGRW7wB1+8CwBAK1xEkZPJlKTFeDSKR8JxSYvDfn/Ivxfse3a2/UiO3RtbaLLiyZPVx4+W3n/vMSiySpG7PgYA6H0u8klBqeTiMTwajUfCsVAoGgxEJC0O7O7s72z7+x7v1q4kx56V5fWlJ6uPHi29/97j/s+zd6Y1e6DIANAKF/ykQC5qMyAXtSoXNSgyALQCfFK6Qj8o8plyUcP7DABaAT4pXaEfFPlMuajR+0z5eBHDTJqXwTmeYGLWpBVXF3xgymU8IahJ6lJ5L4ZhQz+6ceYTZf7Y6BbanicjdfNj0R+UwXP9myRybVOS7Iv8E0GRu0I/KPKZclH/wRfvKvN0KHO+XTagyKco8gV6bFEf29hvq4ps7rztqbXb6wcUuSv0gyKfKRd1XZGN3qaaFMiG6aUvnItame202bPVEfJQT01ZrXciPRTfa5hbmlN/XOVn7aufW9hKF82ySmvPrZRM2sCV/KB6KVG3231Dn2PbNHG1wrPy6PRONHmsNRmpz5EY2/AtVH+3KA5KmUNW70HZi1na70t9y+nTe8OVPbiyd05FPlMuavQ+kzJQND4nximQzR+ues5c1EYfj1Pdtp6yWp9ouZE4Sp9bWplzxGozSDLSSnZn86zSqqPQDNuoslHGKeMc2+oBqDwbnDqNE8M81ia5xo3/iU161CW7Mnggr/nZaDKkZqnB2/GW05+Wi9/99vTkw5OTp8fHJ0dHJ0e1Y5QLtXpYOzyoHRxU+x6UfrtYLBfypVyukBXzmUxWEMT+v/vtTLmole8zKYRRzmAgq3+cNOml25KL2uDjYe5WrY9qV5oEqSYP3na7b1iNIiyE3NY64UPjb/waMEzfZ9RFk6zSyl6ksyR9/nWVDRT5tAGYJUXlzMPDxpnU57E+V2LsRo9GCWH1imzowexR64Zvy8t4y+lPywVXiJycPD05RnJ8XKsd16pH1cMjpMWVymGl3P+g7IL5fCmXLYhiThCy6XSG59Isyzv6eIWI44y5qPXvM4Wi6QIcfXrpC+eiVge8xlmTGz7lOPfUlNVNEy3LnzdttlbPlNU6NTdhQyppnVho/Ko1VOQmXZgfhbEi6yq3pMjmv9xbVOTGXumEqBT5vImxuQsocrPc4UZvy8t7yylPy8UVGUXHqtAYZd4rH5RL/U+xUC4gOa4/ITrDcWmW4WiK7XNFPlMu6j/44l1VnlPzFMgcq0sv7dEmM1a9m1vLRd34HS17M3ernXlonrLaKNHyvHluaenwbVarNB77iF0p4q1kdzbPKq3+nKuSSRtWPl2RDQeg9qw9dTonzfJY6/23kBjb5DBbmLWQz0aT3OFGb8vLeMvpT8sFFVmW41r16FCW4/JhuXRQKlaKzwEol5WYyQtCluczLJtmGI6imFSK7nNFPlMuavQ+a1wA0V+EUaRA5tTppaX3uukkQIu5qOuz2NYRe2tX9lpJWa13ou0OM0667JmwYQ3Naki2XpGbdHHqydEnkzZIFH2aIhu20ntWnTojJ9o81oqM1OdLjK07TEWac50i6z0YvFWkIen/9Zf3ltOclgsqMpo7RtHxwUFVJceFciHf/+SyRVFsyDFNc/Un4SXIPlfkM+Wihnt6AKAVLqzIx7XqcbV6dHhQrajlOJ8v5XP9T1ZEqQVFjhUYmiNJhiCoZCKFx5N9rsitcOr7DNNZ1w8NALrIBRUZTR8fHkpzxyWUCLVSQHmps4W+JyPkhHSWYwWG5imSJZJUIpGKx5PRCN7PitzJ9xkAPD9cWJHRfEUNXcorFSvFQiWfL+dzxaxYEDP59pLx3bTZbvqEnGa7SbXLRkijxNtpimRTBJ3ASSTH4VAMFFn1PgMAoBUuosjV6tHhQa1SqZbLB+g+sEK+nMuWstmCmMlnhFx7Ebw3bbabvnRWs92k2mXDcyLHCjTFpQgmmSDjMSIaxcOhaGA/AooMAEDncIw5FfMVlWKxUsiX87lSVkT3HuSEdLa9pLecNpvTy4va7flr9VnI4UV519bmlM12bdjWKL8MOFZg6DSZYokkhceJaCQRCsWCgbB/LwiKDABA55AVuVw+LBUrhUI5n0O3ghUyQi7NZ3lObC+cZ8qmvApkndpkM5xnymad2mQzPCfet2PDc/USj2fKhtkmPRmO9U1aseG5TNvHw3Miw6RRgJzAyVg0GQ7FA4GIfy+4s7MPigwAQOdwjDnRMuJS6UBat1bMioWMgGZXxbb3qL013mQRpuaeSE69YKe90BRPpthkgorHiEgYDwaifn8IZd4DRQYAoHOge1Kl6Lgozx2neXSxS2DodHuh1yet1kk3xSu36ZlhbGheX23D1ajsvm6zXt9q+3ik+Qoaj6eikUQoGNv3h3d3A9u+va3NHVBkAAA6h2PMWSiUJC1Ga4jFuhYzPE1xFMm2F9I1YbFMuFKMcpt0TVgw67iLIVOecQt2dYZBu9bWtOVtHw9FskSSbsxX7Ef2doPb237v1o7H7QNFBgCgczjGnNlsXhRzmUxWSIs8n+FYgWXSNMVTJJsiGCJJt5fkynWL5fpqgtJu3xmqz1kMzsi7VpbHLZahQUuj/DLA4ymVHPv8Xu/Opse7sb4FigwAQOdwjDkVWpyW4+IUwRBJKoGTeDzVReJLr73wwmvLMeJSe4lGEuFQPBiI+PdCO9v73q1dj8e3sb65turuZ0W+3Zp1fZwA8PzgGHPyvCBpMUuSTIqgJS0mYrFkLJpoL/o1txiGmVWOPvr+C3/0/ccRvO3DUBIOxYKBqEqONzZda+6V5fU+V2TutFzUoMgA0EkcY06G4SQtppJJMoGncJyIx5KxKB4J4+FQvO8J7NejY593d9OzvbG+tbbmXll2LT1Z7XNFbi7HB5UqKDIAdBLHmJMkaUmLCRxPxmMJSYtjwUA0sB/pe/b2guheNyTHrjX3yopr6cnqow+W+1yRm8vx4UFNr8is7115QuOhr1O5qKNr9+6txc6U+dSkSSuuTq1j6pzZe3jGcV7WGWMSy/du3b59+x3X6r17a9HI6llPINAVHGPOZDIlaTEejeKRcFzS4rDfH/LvBfuenW0/kmP3xhaarHjyZPXxo6X333vc54rcXI6r1SONIrPRtXu33t1GN5NH1+7dmlmOdiQXdY8pctsbXvYZ652BAc1BqeTiMTwajUfCsVAoGgxEJC0O7O7s72z7+x7v1q4kx56V5fWlJ6uPHi29/97jPs+zd/v27eZyXKsdGyiy0Qc7tjyDouZbD/fQy3vLCXkX2paDa1RH2VZfWeMQ9SsHeiyTWL5X/zIwcysP1cjVuw/v3VI20Tipd0fjKMy8ffu2PEKl82hk9d7Ddx/eqruSw9Jb6n41bfVHp0d2pWyuPRCjOlLzvfqobr3ri6hiZLPTBfQOkIvajD7PRX379u3mcnx8dKKftdh+WP+ob+viL5bZe3jr3W1GUJTUpVMp5dsPbymnO5pU1jjUK/KpbhVNFK5u3XroQ05uPfQZOKm39f1W0r56WwPnyKf+wKUfEyyz91D9S0J/dPp/Det7V9O1wTnR1VF5UI5EOg/KuQvN6QKAZ51+UOTmcnxy8tTsyh6Kwm6pZjCQUtfVZ/uhpJhINRSzz/qYTlNZ79BUkc3dqsVR7UoaNgrJ9U4UgqsKpTXOm3xDyHLJGWmf/nQZ+Nd1bXQgxsPTHr6syL7fNvkvAMAzTT8ocnM5fvr0w+b3WsiKdksXDyJJksVIqVB6DCqrHRoFvHVFNv3hL8e5elc6RTab8eAUOtg0AD+DIhueLtNDkLo2a2U4PM5ckWGyAuhX+kGRm8vxhx/+q3YeWdIFTprHrIuFFAjLQR/L7D289+7De9rLgHIrlVtNZZ1D7SyB7M3crXbmQelKP2uhdoLa7izPKFVVH4A3U+QmsxZGp0tDTNe1vpW+juqUms1amP8XAOCZph8Uubkc/+53v9PHyPL1Jflnb+M60sN3H95qfM63H95S/ehuek1JWVnvUNaX+iz2vXcftnZlL0rvGrlq6cqe3J18sU7rXK/IaDJHfWXP4OvH6HRJu+pfS5quDVuZDY8zUWS4sgf0Mf2gyKfmom4+awEAANAj9IMit2KX1FfXDx8AgH7imVdkAACAvgEUGQAAoFcARQYAAOgVQJEBAAB6BVBkAACAXgEUGQAAoFcARQYAAOgVQJEBAAB6BVBkAACAXgEUGQAAoFcARQYAAOgVQJEBAAB6BVBkAACAXuH/A+ioZ6uesfUdAAAAAElFTkSuQmCC" alt="">

and while the variable names come down, the variable labels do not. Is anyone aware of a work a round. I have some 75 survey items set up as variable labels and I do not, in a major way, want to re-type them all once the export is done.

Thanks,

Eric
Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

Dale

I do not think you can do this.  I have tried various things and not found a fix.   The best I was able to do was save the labels by creating new variables with eh lables.

 

Dale

 

 

Dale Pietrzak, Ed.D., LPCMH, CCMHC

Director, Office of Academic Evaluation and Assessment

University of South Dakota

Slagle Hall Room 102

414 East Clark Street

605-677-6497

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Erik
Sent: Tuesday, March 05, 2013 3:00 PM
To: [hidden email]
Subject: Exporting Variable Labels to Excel

 

I am trying to export data in an SAV file to Excel. I have checked the relevant box in the 'Save As' dialog:

<img id="_x0000_i1025" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdsAAADBCAIAAAAIIo0qAAAgAElEQVR4nO2d23Mb2X3nu1K1u5XXfdh9239gXzZ+WFelMihAs1umq1JO4vWWEyfeim2KIDWL2HG4tsdjJr7NUKQIjT2+jMRMfJVEkyI5GnmSmZHEG0iABHgBcUcDjb6j0biDBEhq4lTNPhx0o68gSIIABP1+9SlW4/Q5v3O6CXzxw+k+/cM+AgMDAwProDnGnBybMQTr9tjAwMDAni8DRQYDAwPrFWumyLXcWreHBwYGBvYcWTNFzoTHuz08MDAwsOfImikyv/vVbg8PDAwM7DmyZorM7nyl28MDAwMDe46smSIzvr/p9vDAwMDAniNrpsiU9yXjRtT0wMA0pd/W2soo2kVNDwxMk+qXJk1kp9joisoT1rBTGrds0njAwMDAesOaz1p8OZ+6Z9CoRUXW7JJfnk+RVa/bYacPAwwMDKyj1kyRhX0H4b5q0MhQkanpgdHReig7uoJUFUW0JDX9iU+8Nq54WW8iR76S2tbbDIyOnqbIK6NyrExND2AD09RH1PTAwOjogJFDZd16naujA20NuMHAwMAubM0UuVAoJNe/ZNDITJHrQijJpzooJs1eyg1kD9T0AGY+a6FoNTBNrYxKVSVlbjhSDWlgmlLWgRgZDAys5+wURU64vmjQyEyRFYFoXf6aKLJqahgbmKaUXrUxsfGsBTU9oAhyFe3rm4pWDdFvaQYcDAwMrAt2iiLja39t0KhdiqwW2TMrsjTHoY95QZHBwMCeRWumyJ//IBVf/T9GraRJAOXEwFkV+ZRJhlMVWaotj6XFWQtQZDAwsF61Zor8ybuh2MrnjdvJcw4GAqe+cidpMal+SX1kfmUPGxhodvcb9nfLqpnmun43vbJXL1CpcH081EdgYGBgPWHNFDm19qeE59lZSA0xLxgY2DNuzRSZ8Pxtkf2Xbo+wZQNFBgMDe8YNno8MBgYG1isGigwGBgbWKwaKDAYGBtYrBooMBgYG1isGigwGBgbWKwaKDAYGBtYrBooMBgYG1isGigwGBgbWKwaKDAYGBtYrBooMBgYG1isGigwGBgbWK9ZMkR1jTgAAAKCTmCqy2Q4AAACgw4AiAwAA9AqgyAAAAL0CKDIAAECvAIoMAADQK4AiAwAA9AqgyAAAAL0CKDIAAECvAIoMAADQK4AiAwAA9ArnV+TYw7e3Rq+yKbbrxwAAANAfnEeRYw/fdg99ZumTH1v65MeCP7/V9WMAAADoD86myPjjR56XPoe0GLH62Re7EiaznimrdcrDCBybYZkFO4Zh9oWLu2odz4QNQyb1qy9p1injm7RiGIbZZ4V2+TzHMerLz3c2AEDD9bcedP1pPr3J9bceNDlvZ1Bk/PEjpRbLdCVMloUDybFS1zrbu2/SitlnBX1Jix7a6PMiB9KkBADOyvW3Hlx/68HTkw9PTp4eH58cHZ0c1Y5rteNq9ah6WDs8qB0cVPueSvmwXDooFsuFfCmXK2TFfCaTFQQRnRyzU3e2GFmerOh6mCwJh1aO2dkRTVCpKWE9U1briN2qKZlyu29Y7SN247YjkxM2TTBrnfAZjQepp23So1I0OdRFrepBPYZh2MicpH1n8qmsLG9rAmrFkY7Mum8gV+Z1VGfDwwja8yYF9fJRAIAZjjHnycnTk2Mkx8e12nGtelQ9PEJaXKkcVsr9T6lUKRbK+Xwply2IYk4Qsul0hufSLMu37WmcsYdv90iYzHqmrFabFcMwRUCnjO/m7KowU1WC2SY92lDU7b5hxUbm6kG3vIFqanV/zo7ZJ6asGvn2oBKtHLOeKavaIWcUip7Zp1qs1T8aRuaYxpFyym8dgzqYfdbobGjO2+yIJM31tt39zAO9DFJkFB2rQuNKtVI5LJcPyqX+p1goF5AcZ3KCkE3zGY5LswxHU2w7n49sFiYzONHJf7kkN75JayNka4R1UihnUKKQQhRd6tRKq3GcpEpy73P2xjdBQ7BMZhhkLVP6MVTk1n1ybGbOLg1SK991BVdNtct6ra8jyavqbMwOG5y3dsxoA88Dj">

 

and while the variable names come down, the variable labels do not. Is anyone aware of a work a round. I have some 75 survey items set up as variable labels and I do not, in a major way, want to re-type them all once the export is done.

Thanks,

Eric

Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

David Marso
Administrator
In reply to this post by Eric Graig-2
AFAIK there is no such option to Export Variable Labels to Excel, never has been and probably never will be!!!
OTOH: You could use either Python or Basic Scripting to enumerate the metadata and spit it out but I am somewhat confused as to what you expect the final file to look like (I will not elaborate on specifics of either scripting method  -TINSTAAFL-)!

Maybe you would care to enlighten us?

Also, you seem to have posted raw image data?  How did that come about?
--
Eric Graig-2 wrote
I am trying to export data in an SAV file to Excel. I have checked the
relevant box in the 'Save As' dialog:

and while the variable names come down, the variable labels do not. Is
anyone aware of a work a round. I have some 75 survey items set up as
variable labels and I do not, in a major way, want to re-type them all once
the export is done.

Thanks,

Eric
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

Jon K Peck
In reply to this post by Eric Graig-2
That checkbox says VALUE LABELS, not VARIABLE LABELS.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        Erik <[hidden email]>
To:        [hidden email],
Date:        03/05/2013 02:03 PM
Subject:        [SPSSX-L] Exporting Variable Labels to Excel
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




I am trying to export data in an SAV file to Excel. I have checked the relevant box in the 'Save As' dialog:



and while the variable names come down, the variable labels do not. Is anyone aware of a work a round. I have some 75 survey items set up as variable labels and I do not, in a major way, want to re-type them all once the export is done.

Thanks,

Eric
Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

Hart, Kimberly (hartkb)
In reply to this post by Eric Graig-2
Inelegant, but you could copy the labels from the data view in SPSS and paste (transpose) into the excel file. Subject to error, but maybe worth a try. 

Sent from my iPhone

On Mar 5, 2013, at 4:02 PM, "Erik" <[hidden email]> wrote:

I am trying to export data in an SAV file to Excel. I have checked the relevant box in the 'Save As' dialog:


and while the variable names come down, the variable labels do not. Is anyone aware of a work a round. I have some 75 survey items set up as variable labels and I do not, in a major way, want to re-type them all once the export is done.

Thanks,

Eric
Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

elle lists
In reply to this post by Eric Graig-2

If you export the .sav file as an Excel 2007-2010 .xlsx file the dialog box allows saving value labels (instead of data values) as well as variable names to the exported Excel spreadsheet file. But note that the export option does not permit saving both value labels and data values in the same exported file.

 

If you want data values and value labels (with variable names) in the same Excel file, two Excel files need to be generated from SPSS then merged.

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Erik
Sent: Tuesday, March 05, 2013 11:00 AM
To: [hidden email]
Subject: Exporting Variable Labels to Excel

 

I am trying to export data in an SAV file to Excel. I have checked the relevant box in the 'Save As' dialog:

 

and while the variable names come down, the variable labels do not. Is anyone aware of a work a round. I have some 75 survey items set up as variable labels and I do not, in a major way, want to re-type them all once the export is done.

Thanks,

Eric

Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

David Marso
Administrator
Noting OP history:
http://spssx-discussion.1045642.n5.nabble.com/Case-source-is-tc5714768.html
OP claims to have been using SPSS for years.
I would somehow presume (perhaps in error) that he knows the difference between VARIABLE LABELS and VALUE LABELS.
If original posting request is correct (Variable Labels) then carry on with the train wreck by applying python or Basic Scripting.  I am having difficulty envisioning what the excel header is going to look like or the utility of such.

elle lists wrote
If you export the .sav file as an Excel 2007-2010 .xlsx file the dialog box
allows saving value labels (instead of data values) as well as variable
names to the exported Excel spreadsheet file. But note that the export
option does not permit saving both value labels and data values in the same
exported file.



If you want data values and value labels (with variable names) in the same
Excel file, two Excel files need to be generated from SPSS then merged.





From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Erik
Sent: Tuesday, March 05, 2013 11:00 AM
To: [hidden email]
Subject: Exporting Variable Labels to Excel



I am trying to export data in an SAV file to Excel. I have checked the
relevant box in the 'Save As' dialog:





and while the variable names come down, the variable labels do not. Is
anyone aware of a work a round. I have some 75 survey items set up as
variable labels and I do not, in a major way, want to re-type them all once
the export is done.

Thanks,

Eric
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Exporting Variable Labels to Excel

elle lists
Thanks, David.  I thought Erik meant "value labels" since there's no SPSS
export option for "variable labels" but may have misinterpreted his message.



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Marso
Sent: Tuesday, March 05, 2013 3:28 PM
To: [hidden email]
Subject: Re: Exporting Variable Labels to Excel

Noting OP history:
http://spssx-discussion.1045642.n5.nabble.com/Case-source-is-tc5714768.html
OP claims to have been using SPSS for years.
I would somehow presume (perhaps in error) that he knows the difference
between VARIABLE LABELS and VALUE LABELS.
If original posting request is correct (Variable Labels) then carry on with
the train wreck by applying python or Basic Scripting.  I am having
difficulty envisioning what the excel header is going to look like or the
utility of such.


elle lists wrote

> If you export the .sav file as an Excel 2007-2010 .xlsx file the
> dialog box allows saving value labels (instead of data values) as well
> as variable names to the exported Excel spreadsheet file. But note
> that the export option does not permit saving both value labels and
> data values in the same exported file.
>
>
>
> If you want data values and value labels (with variable names) in the
> same Excel file, two Excel files need to be generated from SPSS then
merged.
>
>
>
>
>
> From: SPSSX(r) Discussion [mailto:

> SPSSX-L@.UGA

> ] On Behalf Of
> Erik
> Sent: Tuesday, March 05, 2013 11:00 AM
> To:

> SPSSX-L@.UGA

> Subject: Exporting Variable Labels to Excel
>
>
>
> I am trying to export data in an SAV file to Excel. I have checked the
> relevant box in the 'Save As' dialog:
>
>
>
>
>
> and while the variable names come down, the variable labels do not. Is
> anyone aware of a work a round. I have some 75 survey items set up as
> variable labels and I do not, in a major way, want to re-type them all
> once the export is done.
>
> Thanks,
>
> Eric





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email
me.
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Exporting-Variable-Labels-to-E
xcel-tp5718380p5718392.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list of
commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD