[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Pspp-users Digest, Vol 50, Issue 2
Ferguson, Douglas A
RE: Pspp-users Digest, Vol 50, Issue 2
Sat, 5 Jun 2010 14:55:26 -0400
I recommend saving from Excel to a CSV file and then importing text to PSPP,
but I have learned (the hard way) to convert all commas in Excel to semi-colons
first, because in an online survey, open-ended responses sometimes accumulate
stray commas from user input -- and your columns get all messed up with CSV
Douglas A. Ferguson, Ph.D.
College of Charleston
From: address@hidden on behalf of address@hidden
Sent: Sat 6/5/2010 12:01 PM
Subject: Pspp-users Digest, Vol 50, Issue 2
Send Pspp-users mailing list submissions to
To subscribe or unsubscribe via the World Wide Web, visit
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."
1. Re: How to open an excel file? (Ben Pfaff)
2. Re: Matching 2 files...Simple Question? (John Darrington)
Date: Fri, 04 Jun 2010 21:11:50 -0700
From: address@hidden (Ben Pfaff)
Subject: Re: How to open an excel file?
To: Kausik Chatterjee <address@hidden>
Content-Type: text/plain; charset=utf-8
You can use GET DATA/TYPE=GNM to read the Gnumeric file:
Kausik Chatterjee <address@hidden> writes:
> Thank you for your advice. I have downloaded Gnumeric and saved the file in
> Gnumeric xls format. However, I still cannot open it in PSPP. I am sure there
> is a simple solution for it. I sincerely apologise for my ignorance.
> Kind regards
> Dr Chatterjee
> On 4 June 2010 00:20, Ben Pfaff <address@hidden> wrote:
> Kausik Chatterjee <address@hidden> writes:
> > I have just downloaded PSPP and at it's face value the programme looks
> > But how do I open an excel file in PSPP? I would really appreciate your
> > on this matter.
> PSPP cannot read Excel files directly. Â You will have to convert
> your Excel file into another format first. Â There are at least
> two ways to do this. Â You can save the file in a delimited text
> format, which PSPP can read. Â Or you can open the Excel file in
> Gnumeric, save it in Gnumeric format, and then read the Gnumeric
> file in PSPP.
> "Mon peu de succÃ¨s prÃ¨s des femmes est toujours venu de les trop aimer."
> --Jean-Jacques Rousseau
> Dr K Chatterjee
> Consultant Physician
> Countess of Chester Foundation Trust
"Note that nobody reads every post in linux-kernel. In fact, nobody who
expects to have time left over to actually do any real kernel work will
read even half. Except Alan Cox, but he's actually not human, but about
a thousand gnomes working in under-ground caves in Swansea." --Linus
Date: Sat, 5 Jun 2010 10:23:51 +0000
From: John Darrington <address@hidden>
Subject: Re: Matching 2 files...Simple Question?
To: Clarry <address@hidden>
Content-Type: text/plain; charset="us-ascii"
All the subcommands except /FILE and /BY are optional (as indicated in the
/FILE indicates the sources you want to match. /BY indicates the variable (which
should exist in both sources) upon which you want to perform the match.
The optional /IN subcommand, according to the manual "... creates a numeric
variable ... which
takes the value 1 ... if the input file contributed to that case, and 0
For example try the following snippet.
* Create file1.
data list notable list /code * x *.
* Create file2.
data list notable list /code * y *.
* clear the working dataset
* Join file1 and file2 on their CODE variable, and leave the result in
working dataset. Additionally, create two new variables, FROM1 and
which indicate the source of each observation.
On Fri, Jun 04, 2010 at 06:01:28AM -0700, Clarry wrote:
I am very new to PSPP and have no knowledge of Syntax, although i can see
the logic of something once shown.
I have looked at the manual, at this:
/RENAME=(src names=target names). . .
but have no idea what to do with IN, BY, DROP, etc. Or the conventions
If someone uses the parameters required to match one variable (let's call
"CODE") from File 1 to the same variable in File 2 then rename the new file
File 3, I would be able to adapt.
PGP Public key ID: 1024D/2DE827B3
fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3
See http://pgp.mit.edu or any PGP keyserver for public key.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: Digital signature
Pspp-users mailing list
End of Pspp-users Digest, Vol 50, Issue 2
|[Prev in Thread]
||[Next in Thread]|
- RE: Pspp-users Digest, Vol 50, Issue 2,
Ferguson, Douglas A <=