Discussion:
Pspp-users Digest, Vol 140, Issue 17/Sample Export Code
(too old to reply)
Aj Hollenbach
2018-01-30 04:11:24 UTC
Permalink
Greetings,

To follow-up on the question concerning how to export to CSV, here is a
sample of the code that I tried to use to run a "save translate" into CSV.
Appreciate any guidance on how I should modify this code.

Thanks,
Allen

SAVE TRANSLATE
/OUTFILE={’TestCSVfile’}
/TYPE=CSV
Send Pspp-users mailing list submissions to
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnu.org/mailman/listinfo/pspp-users
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."
1. Re: Importing Data (Tara McCoy)
2. Exporting Dataset into Excel or CSV File (Aj Hollenbach)
---------- Forwarded message ----------
Date: Sun, 28 Jan 2018 15:09:43 -0600
Subject: Re: Importing Data
Hi John,
I tried it with the two most recent versions, I believe from November 2017
and Jan 2018. I used the Windows installers. Any ideas for what might be
going wrong?
On Saturday, January 27, 2018, John Darrington <
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.
It does for me! Which version are you using?
J'
--
Avoid eavesdropping. Send strong encrypted email.
PGP Public key ID: 1024D/2DE827B3
fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3
See http://sks-keyservers.net or any PGP keyserver for public key.
--
Sent from Gmail Mobile. I apologize for any errors or typos.
---------- Forwarded message ----------
Date: Mon, 29 Jan 2018 19:56:41 +0700
Subject: Exporting Dataset into Excel or CSV File
Greetings PSPP Users,
I am attempting to export my data set to an Excel or CSV file but cannot
seem to figure out the syntax or find a pathway for this within the GUI. I
would greatly appreciate any recommended syntax for the export process.
Thanks and Regards,
Allen Hollenbach
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
Ben Pfaff
2018-01-30 04:25:12 UTC
Permalink
As a place to start, remove { and } from the syntax.
Post by Aj Hollenbach
Greetings,
To follow-up on the question concerning how to export to CSV, here is a
sample of the code that I tried to use to run a "save translate" into CSV.
Appreciate any guidance on how I should modify this code.
Thanks,
Allen
SAVE TRANSLATE
/OUTFILE={’TestCSVfile’}
/TYPE=CSV
Send Pspp-users mailing list submissions to
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnu.org/mailman/listinfo/pspp-users
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."
1. Re: Importing Data (Tara McCoy)
2. Exporting Dataset into Excel or CSV File (Aj Hollenbach)
---------- Forwarded message ----------
Date: Sun, 28 Jan 2018 15:09:43 -0600
Subject: Re: Importing Data
Hi John,
I tried it with the two most recent versions, I believe from November 2017
and Jan 2018. I used the Windows installers. Any ideas for what might be
going wrong?
On Saturday, January 27, 2018, John Darrington <
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.
It does for me! Which version are you using?
J'
--
Avoid eavesdropping. Send strong encrypted email.
PGP Public key ID: 1024D/2DE827B3
fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3
See http://sks-keyservers.net or any PGP keyserver for public key.
--
Sent from Gmail Mobile. I apologize for any errors or typos.
---------- Forwarded message ----------
Date: Mon, 29 Jan 2018 19:56:41 +0700
Subject: Exporting Dataset into Excel or CSV File
Greetings PSPP Users,
I am attempting to export my data set to an Excel or CSV file but cannot
seem to figure out the syntax or find a pathway for this within the GUI. I
would greatly appreciate any recommended syntax for the export process.
Thanks and Regards,
Allen Hollenbach
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
ftr public
2018-01-30 08:35:00 UTC
Permalink
Hi Allen,

A first look into the Help can help you, as well as a copy of the error
message PSPP generates for those on the list who answer.

Did you replace the text {’TestCSVfile’} with the path and the name of
the csv file ?  such as in

/outfile= "c:\documents\datafile.csv"

If you want to get columns with the variable names you add

/fieldnames


HTH
ftr
Post by Aj Hollenbach
Greetings,
To follow-up on the question concerning how to export to CSV, here is
a sample of the code that I tried to use to run a "save translate"
into CSV. Appreciate any guidance on how I should modify this code.
Thanks,
Allen
SAVE TRANSLATE
        /OUTFILE={’TestCSVfile’}
        /TYPE=CSV
Send Pspp-users mailing list submissions to
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnu.org/mailman/listinfo/pspp-users
<https://lists.gnu.org/mailman/listinfo/pspp-users>
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."
   1. Re: Importing Data (Tara McCoy)
   2. Exporting Dataset into Excel or CSV File (Aj Hollenbach)
---------- Forwarded message ----------
Date: Sun, 28 Jan 2018 15:09:43 -0600
Subject: Re: Importing Data
Hi John,
I tried it with the two most recent versions, I believe from
November 2017 and Jan 2018. I used the Windows installers. Any
ideas for what might be going wrong?
On Saturday, January 27, 2018, John Darrington
     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.
It does for me!  Which version are you using?
J'
--
Avoid eavesdropping.  Send strong encrypted email.
PGP Public key ID: 1024D/2DE827B3
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See http://sks-keyservers.net or any PGP keyserver for public key.
--
Sent from Gmail Mobile. I apologize for any errors or typos.
---------- Forwarded message ----------
Date: Mon, 29 Jan 2018 19:56:41 +0700
Subject: Exporting Dataset into Excel or CSV File
Greetings PSPP Users,
I am attempting to export my data set to an Excel or CSV file but
cannot seem to figure out the syntax or find a pathway for this
within the GUI. I would greatly appreciate any recommended syntax
for the export process.
Thanks and Regards,
Allen Hollenbach
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
<https://lists.gnu.org/mailman/listinfo/pspp-users>
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
Loading...