Re: Pspp-users Digest, Vol 140, Issue 17/Sample Export Code

[ftr public]

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

On 30/01/2018 05:11, Aj Hollenbach wrote:

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

On Tue, Jan 30, 2018 at 12:00 AM, <address@hidden> wrote:

Send Pspp-users mailing list submissions to
        address@hidden

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
        address@hidden

You can reach the person managing the list at
        address@hidden

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."

Today's Topics:

   1. Re: Importing Data (Tara McCoy)
   2. Exporting Dataset into Excel or CSV File (Aj Hollenbach)


---------- Forwarded message ----------
From: Tara McCoy <address@hidden>
To: John Darrington <address@hidden>
Cc: "address@hidden" <address@hidden>
Bcc: 
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 <address@hidden> wrote:

On Sat, Jan 27, 2018 at 09:32:31AM -0600, Tara McCoy wrote:
     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 ----------
From: Aj Hollenbach <address@hidden>
To: address@hidden
Cc: 
Bcc: 
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
address@hidden
https://lists.gnu.org/mailman/listinfo/pspp-users

_______________________________________________
Pspp-users mailing list
address@hidden
https://lists.gnu.org/mailman/listinfo/pspp-users