Support Forums : SPSS export response max out

Hi,

I just tried to download the SPSS syntax for my survey (6400 respondents) and did not get a complete file - the syntax ended around 5600 respondents or so, and, along with missing a few hundred responses did not have the variable label information (the bit below “END DATA”).

There don’t appear to be any facilities to filter SPSS exports to reduce the file size and download in several sections, then merge in SPSS. Any kind of filter here would be an easy work around.

Survey name: Travellers’ Pulse

This issue is different from the 80 column max out (which is solved in another post on this forum).

Many thanks,

Adam

I’d like to inform you there is a new library to native export to SPSS format - SPSS XPorter version 1.6

Features
* can export data to any SPSS versions (since v10)
* allows to use UTF-8 to painless export any texts
* allows to use all the main SPSS variable types (Unlike pmStation, wich does not support date variables)
* supports long variable names, labels and values
* uses data compression
* is highly optimized for speed (up to 10 times)
* is designed for minimal memory usage
* adds missing values to variable
* uses defined value labels for variable’s value (both numeric, so does string)
* supports line by line mode (as pmStation library) and batch mode
* is developed for easily moving from old and non-stabile pmStation library. (There is an adapter class, using it helps you not to rewrite the code)
* is developed with using non-blocking multithreaded architecture
* supports progress listener
* can be configured on-the-fly

Supported variable types

* NUMERIC;
* COMMA;
* DOT;
* DOLLAR;
* STRING;
* DATE (different formats).

If you are interested in it, do not hesitate to contact me at nikonoff@mail.com

Christian,

Could this be (part of) the explanation of why I get strange errors when including multiple files containing many SPSS-macro's? (possibly thousands of lines of syntax alltogether)

The error I encounter does not appear to be associated with any specific macro, they work fine one-by-one. SPSS states something like “text not recognized as an SPSS command, line xxxx, text encountered DEFINE” Also, since I can change the order in which I execute the syntax/load the macro's and the error always comes near the (next to) last files I run I suspect something else is going on. Replacing the INCLUDE statement for some of the first files I run with INSERT was nescessary just to keep on going but does not offer real confidence for future expansion in functionality.

Any further knowledge on the character limit that you can share is more than welcome!

Alex

Christian Vanek said: [edited]

This has happened to me a few times too. The data is there, but the SYNTAX Editor in SPSS has a character limit. (I can’t tell you how long it took me to figure this out…)

I like SPSS, but I have to say their file formats are… “interesting”.

Cheers,

-Christian