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

[Crichton, Ronald]

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