Re: Excell to PSPP direct?

When you save the csv file you must be aware of what character you are using. Last I uses MS Excel, the default character was something funky. Make sure you are using commas on the export, and commas on the import. On 02/14/2014 08:44 AM, Thambu David wrote: > Well ,downloaded Libre Office and im

Re: Re: Excell to PSPP direct?

> > Is it possible for PSPP to directly import files from Excell without > making them CSV-often this does not seem v straightforward > > Importing directly from Excel is not possible. So you have to convert to > *something*. > Something could include CSV, ODT, Gnumeric or HTML. > Will this d

Re: export pspp to libreoffice

Sorry the syntax was lacking: keep should produce 14 variables but I get these 14 and an empty variable when I use the same syntax but for save outfile. save translate /outfile = "C:\users\ftr\documents\data\eb\EB79.4_France_Intercultural_sociodemo.csv" /type csv /replace /missing recode /ke

export pspp to libreoffice

Hi, This is a weird case of exporting in PSPP (latest version, under windows) from a sav file to Libreoffice via a csv file. I want to output 14 variables but - I get 14 AND an empty variable when I save the file with identical variables and read it in PSPP, - When I import it into LibreOffic

Re: Excell to PSPP direct?

Why not save it to CSV (as Darrington suggested)? I choose an ASCII encoding (but you should use an appropriate one for your data but ASCII will represent numbers and most English text), tabs for delimiters (assuming your data do not contain the tab character), and no quotes (press delete in th

RE: Excell to PSPP direct?

Well ,downloaded Libre Office and imported the Excell sheet and saved it. Tried importing to the pspp but failed! Help! Dr Thambu David S Professor and Head Medicine Unit 2 Christian Medical College, Vellore 632004, India From: Alan Mead [m...@iit.edu] Se

Re: Excell to PSPP direct?

Hi, Are there any ideas to get a direct export in Libre/OpenOffice format ? Regards ftr On 14/02/2014 16:38, Thambu David wrote: :-) Thanks alan! I shall give Satya N some time to settle down-mean time i shall try Libre office! regards Thambu From: Al

RE: Excell to PSPP direct?

:-) Thanks alan! I shall give Satya N some time to settle down-mean time i shall try Libre office! regards Thambu From: Alan Mead [m...@iit.edu] Sent: Friday, February 14, 2014 9:12 PM To: pspp-users@gnu.org; Thambu David Subject: Re: Excell to PSPP direc

Re: Excell to PSPP direct?

Thambu, What you're asking is not practical and perhaps impossible. Microsoft's Office formats are extremely complex. I don't know how SPSS reads them but I know it's very brittle. In the past, when I have saved data as an .XLS file using LibreOffice, SPSS has failed to import it. Also, Offic

Re: Excell to PSPP direct?

On Fri, Feb 14, 2014 at 07:30:06PM +0530, Thambu David wrote: Is it possible for PSPP to directly import files from Excell without making them CSV-often this does not seem v straightforward Importing directly from Excel is not possible. So you have to convert to *something*. Something coul

Excell to PSPP direct?

Dear All Is it possible for PSPP to directly import files from Excell without making them CSV-often this does not seem v straightforward It would make implementing this as a SPSS alternate much easier Most students and faculty are looking for a legal free alternate,but this is one area of difficu