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
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