EpiData-list

Download

epidata-list@lists.umanitoba.ca

December 2020

1 participants
2 discussions

Re: [EpiData-list] Epidata 4.6.0.4 SPSS-Export
by EpiData development and support 15 Dec '20

15 Dec '20

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(a)fifas.de >> >> _______________________________________________ >> EpiData-list mailing list >> EpiData-list(a)lists.umanitoba.ca >> http://lists.umanitoba.ca/mailman/listinfo/epidata-list > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)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(a)fifas.de

1 1

Epidata 4.6.0.4 SPSS-Export
by EpiData development and support 15 Dec '20

15 Dec '20

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(a)fifas.de

1 1