Re: Q: Can a pspp file be saved in Excel format?

[Ben Pfaff]

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