I guess you use the GUI. If you look into the manual and look how to
import csv or ods files you avoid this error.
Look for the GET DATA command:
9.4.3 Textual Data Files
GET DATA /TYPE=TXT
âŠadditional subcommands depending on ARRANGEMENTâŠ
When TYPE=TXT is specified, GET DATA reads data in a delimited or fixed
columnar format, much like DATA LIST (see DATA LIST
The |FILE| subcommand is mandatory. Specify the file to be read as a
string file name or (for textual data only) a file handle (see File
The |ENCODING| subcommand specifies the character encoding of the file
to be read. See INSERT
for information on supported encodings.
The |ARRANGEMENT| subcommand determines the fileâs basic format.
DELIMITED, the default setting, specifies that fields in the input data
are separated by spaces, tabs, or other user-specified delimiters. FIXED
specifies that fields in the input data appear at particular fixed
column positions within records of a case.
By default, cases are read from the input file starting from the first
line. To skip lines at the beginning of an input file, set |FIRSTCASE|
to the number of the first line to read: 2 to skip the first line, 3 to
skip the first two lines, and so on.
|IMPORTCASES| is ignored, for compatibility. Use |N OF CASES| to limit
the number of cases read from a file (see N OF CASES
or |SAMPLE| to obtain a random sample of cases (see SAMPLE
The remaining subcommands apply only to one of the two file
arrangements, described below.
â¢ GET DATA /TYPE=TXT /ARRANGEMENT=DELIMITED
â¢ GET DATA /TYPE=TXT /ARRANGEMENT=FIXED
Post by Tara McCoy
Hi - when I try importing a .csv file into PSPP it does not give me
the option to indicate that the first row of data includes the
variable names. It also does not automatically import them as names. I
have uninstalled and re-installed PSPP multiple times while also
creating different .csv files but the variable names still do not appear.
I then tried to import using a .ods (LibreOffice). I was able to get
the titles in (as the checkbox for this appeared); however, some of my
variables in only the first row of select columns are identified as
string variables and removed from just the first row upon importing. I
have checked - rechecked the format properties of these cells to
ensure they are numeric, but the same issue for the same columns
continues to occur.
I'm at a bit of a loss for what to do next. Any suggestions are much
Tara McCoy, PhD
Personality and Identity Lab
Department of Psychology
University of California, Riverside
900 University Avenue
Riverside, CA 92521
Pspp-users mailing list