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: [email protected] > [mailto:[email protected]] On Behalf Of > John Darrington > Sent: Wednesday, 5 June 2013 3:10 PM > To: martin cohen > Cc: [email protected] > 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 > [email protected] > https://lists.gnu.org/mailman/listinfo/pspp-users _______________________________________________ Pspp-users mailing list [email protected] https://lists.gnu.org/mailman/listinfo/pspp-users
