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

[Crichton, Ronald]

Not a bug.  It works!

I didn't know about it.  I had read only the first few paras of section 9.7 
only and of course it's not mentioned until 9.7.1.  Way down at the bottom of 
the page.  That'll teach me!

-----Original Message-----
From: Ben Pfaff [mailto:address@hidden
Sent: Wednesday, 5 June 2013 3:29 PM
To: Crichton, Ronald
Cc: John Darrington; martin cohen; address@hidden
Subject: Re: Q: Can a pspp file be saved in Excel format?

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
-----------------------------------------------------------------------
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.
-----------------------------------------------------------------------