[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Q: Can a pspp file be saved in Excel format?
From: |
Ben Pfaff |
Subject: |
Re: Q: Can a pspp file be saved in Excel format? |
Date: |
Tue, 4 Jun 2013 22:28:41 -0700 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
Adding FIELDNAMES should include variable names. If that doesn't work,
it's a bug.
On Wed, Jun 05, 2013 at 05:26:01AM +0000, Crichton, Ronald wrote:
> TRANSLATE works fine but you don't get headings on the fields. However, if
> you use /keep and list the variables you are interested in then you will be
> able to copy and paste the variables names into excel (data > Text to
> Columns). This works for me:
>
>
> save translate
> /outfile = 'P:\Xfer\2013_OUT.txt'
> /keep = e313 e307 eftsl e490 Year Type
> /type = TAB
> /replace.
>
>
>
> -----Original Message-----
> From: address@hidden [mailto:address@hidden On Behalf Of John Darrington
> Sent: Wednesday, 5 June 2013 3:10 PM
> To: martin cohen
> Cc: address@hidden
> Subject: Re: Q: Can a pspp file be saved in Excel format?
>
> On Tue, Jun 04, 2013 at 05:36:23PM -0700, martin cohen wrote:
> I have some old (created circa 2001) spss files that pspp can read ?just
> fine.
>
> I would like to be able to save them as Excel (.xls) files for display
> purposes.
>
> Saving in csv format would also be OK.
>
> However, I do not see any way to do this, either with "save as" or
> "export".
> ?
> Is there any way to do this?
>
>
> Excel is not something that pspp deals with. It can import from other
> spreadsheet formats (but cannot currently export to them).
>
> However, you can save as a CSV file. See Section 9.7 of the manual (SAVE
> TRANSLATE).
>
>
> J'
>
>
> --
> PGP Public key ID: 1024D/2DE827B3
> fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3 See
> http://keys.gnupg.net or any PGP keyserver for public key.
>
>
> CIT is the ACT Large Training Provider of the Year.
> Subscribe to CIT Industry Connection - CIT's free, bi monthly publication:
> http://cit.edu.au/industry_business/industry_connection/
> -----------------------------------------------------------------------
> This email, and any attachments, may be confidential and also privileged. If
> you are not the intended recipient, please notify the sender and delete all
> copies of this transmission along with any attachments immediately. You
> should not copy or use it for any purpose, nor disclose its contents to any
> other person.
> -----------------------------------------------------------------------
>
> _______________________________________________
> Pspp-users mailing list
> address@hidden
> https://lists.gnu.org/mailman/listinfo/pspp-users