Export Output (.spv) to a TXT file creates blank first row.

Technote (troubleshooting)


Problem(Abstract)

When exporting an SPSS Output file to TXT, a blank line is created in the first row of the exported Text (.txt) file.

Symptom

Launch Statistics 19, run an analysis with tables. Export the SPSS Output table to a TXT (Text) file.
The first row of the text file is blank. This causes issues when the text file is used programmatically as an import file and the first row is blank. The text files have to be manually edited to remove the first blank line before they can be used.


Cause

Unknown.

Resolving the problem

This issue should be platform independent; however, it has been verified, tested, and resolved in Statistics 21 Fix Pack 1, on a Windows Platform only.

[Work Around]

Using OMS to export the Text (.txt) file will NOT create a blank line in the first row.

Here is a Syntax Example using one of our shipped sample files (Employee data.sav).


* Get and Open a sample dataset Employee data.sav.
GET
FILE='C:\Program Files\IBM\SPSS\Statistics\19\Samples\English\Employee data.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.


* OMS.
OMS
/SELECT TABLES
/IF COMMANDS=['Frequencies'] SUBTYPES=['Frequencies']
/DESTINATION FORMAT=TEXT
OUTFILE='C:\Program Files\IBM\SPSS\Statistics\19\Samples\English\Text.txt'.

FREQUENCIES VARIABLES=salary
/ORDER=ANALYSIS.

OMSEND.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics

Software version:

19.0

Operating system(s):

Platform Independent

Reference #:

1634953

Modified date:

2013-04-19

Translate my page

Machine Translation

Content navigation