Re: [EpiData-list] Epidata 4.6.0.4 SPSS-Export
Dear Michael,
thank you for this hint! That makes things much easier. If someone nevertheless needs it, I attach a spss syntax, that produces a list of string variables in the datafile and than deletes all leading and ending quotation marks (the first and the last character) in these string variables. It can be included in the spss import syntax.
Best Regards,
Juergen
Am 15.12.2020 um 10:32 schrieb EpiData development and support:
Dear Juergen, this is right, the SPSS-Export doesn't work right. The used SPSS- Command "data list" is a lit bit out of date and could not handle qualifiers for Textvariables.
This is a workaround: Do the SPSS-Export. Afterwards do a second export, the "CSV-Export", and overwrite the existing file. In the Specifications for the CSV-Export you can disable/delete the Quote Character. Greetings Michael
Am 15.12.2020 10:08 schrieb EpiData development and support:
Dear all,
I have a little problem with the SPSS-Export of the Epidata-Files. When you export string variables, you can specify the variable delimiter (e.g. "|") but not the text delimiter. The result is a csv file, that is imported in SPSS with quotation marks at the start and the end of every string variable, even if the variable is empty. I found no way to delete these quotation marks during the spss import process except with a quite complicated macro.
Is it possible to change the SPSS export?
Kind Regards,
Juergen Spiegel
--
Freiburger Institut fuer angewandte Sozialwissenschaft e.V. FIFAS Erasmusstr. 16, D-79098 Freiburg
Telefon: +49-761-288364 Fax: +49-761-2927493 Web: http://www.fifas.de E-Mail: info@fifas.de
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
We have no access to SPSS software.
May I suggest that you try export to Stata and read that into SPSS.
I found this explanation : https://stats.idre.ucla.edu/other/mult-pkg/faq/how-do-i-use-a-stata-data-fil...
An export to Stata with the updated new version of Analysis or Manager will write recent Stata versions.
Best wishes Jens Lauritsen EpiData Association
Den 15. december 2020 10.45.48 CET, EpiData development and support epidata-list@lists.umanitoba.ca skrev:
Dear Michael,
thank you for this hint! That makes things much easier. If someone nevertheless needs it, I attach a spss syntax, that produces a list of string variables in the datafile and than deletes all leading and ending quotation marks (the first and the last character) in these string variables. It can be included in the spss import syntax.
Best Regards,
Juergen
Am 15.12.2020 um 10:32 schrieb EpiData development and support:
Dear Juergen, this is right, the SPSS-Export doesn't work right. The used SPSS- Command "data list" is a lit bit out of date and could not handle qualifiers for Textvariables.
This is a workaround: Do the SPSS-Export. Afterwards do a second export, the "CSV-Export", and overwrite the existing file. In the Specifications for the CSV-Export you can disable/delete the Quote Character. Greetings Michael
Am 15.12.2020 10:08 schrieb EpiData development and support:
Dear all,
I have a little problem with the SPSS-Export of the Epidata-Files. When you export string variables, you can specify the variable delimiter (e.g. "|") but not the text delimiter. The result is a csv file, that is imported in SPSS with quotation marks at the start and the end of every string variable, even if the variable is empty. I found no way to delete these quotation marks during the spss import process except with a quite complicated macro.
Is it possible to change the SPSS export?
Kind Regards,
Juergen Spiegel
--
Freiburger Institut fuer angewandte Sozialwissenschaft e.V. FIFAS Erasmusstr. 16, D-79098 Freiburg
Telefon: +49-761-288364 Fax: +49-761-2927493 Web: http://www.fifas.de E-Mail: info@fifas.de
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
--
Freiburger Institut fuer angewandte Sozialwissenschaft e.V. FIFAS Erasmusstr. 16, D-79098 Freiburg
Telefon: +49-761-288364 Fax: +49-761-2927493 Web: http://www.fifas.de E-Mail: info@fifas.de
participants (1)
-
EpiData development and support