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 files.
Douglas A. Ferguson, Ph.D.
Professor
College of Charleston
(843) 608-8008
-----Original Message-----
From: pspp-users-bounces+fergusond=cofc....@gnu.org on behalf of
pspp-users-requ...@gnu.org
Sent: Sat 6/5/2010 12:01 PM
To: pspp-users@gnu.org
Subject: Pspp-users Digest, Vol 50, Issue 2
Send Pspp-users mailing list submissions to
pspp-users@gnu.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.gnu.org/mailman/listinfo/pspp-users
or, via email, send a message with subject or body 'help' to
pspp-users-requ...@gnu.org
You can reach the person managing the list at
pspp-users-ow...@gnu.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."
Today's Topics:
1. Re: How to open an excel file? (Ben Pfaff)
2. Re: Matching 2 files...Simple Question? (John Darrington)
----------------------------------------------------------------------
Message: 1
Date: Fri, 04 Jun 2010 21:11:50 -0700
From: b...@cs.stanford.edu (Ben Pfaff)
Subject: Re: How to open an excel file?
To: Kausik Chatterjee <kausikchatter...@gmail.com>
Cc: pspp-users@gnu.org
Message-ID: <87k4qe3ypl....@benpfaff.org>
Content-Type: text/plain; charset=utf-8
You can use GET DATA/TYPE=GNM to read the Gnumeric file:
http://www.gnu.org/software/pspp/manual/html_node/GET-DATA-_002fTYPE_003dGNM.html#GET-DATA-_002fTYPE_003dGNM
Kausik Chatterjee <kausikchatter...@gmail.com> 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 <b...@cs.stanford.edu> wrote:
>
> Kausik Chatterjee <kausikchatter...@gmail.com> writes:
>
> > I have just downloaded PSPP and at it's face value the programme looks
> great.
> > But how do I open an excel file in PSPP? I would really appreciate your
> help
> > 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
------------------------------
Message: 2
Date: Sat, 5 Jun 2010 10:23:51 +0000
From: John Darrington <j...@darrington.wattle.id.au>
Subject: Re: Matching 2 files...Simple Question?
To: Clarry <clarry...@gmail.com>
Cc: Pspp-users@gnu.org
Message-ID: <20100605102351.ga7...@cellform.com>
Content-Type: text/plain; charset="us-ascii"
All the subcommands except /FILE and /BY are optional (as indicated in the
manual).
/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
otherwise".
For example try the following snippet.
* Create file1.
new file.
data list notable list /code * x *.
begin data.
90 0
91 1
92 2
93 3
end data.
save outfile='file1'.
* Create file2.
new file.
data list notable list /code * y *.
begin data.
92 22
93 23
94 24
95 25
96 26
end data.
save outfile='file2'.
* clear the working dataset
new file.
* Join file1 and file2 on their CODE variable, and leave the result in
the
working dataset. Additionally, create two new variables, FROM1 and
FROM2
which indicate the source of each observation.
match files
/file='file1'
/in=from1
/file='file2'
/in=from2
/by=code.
list.
On Fri, Jun 04, 2010 at 06:01:28AM -0700, Clarry wrote:
Hi,
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:
MATCH FILES
/{FILE,TABLE}={*,???file-name???}
/RENAME=(src names=target names). . .
/IN=var name
/BY=var list
/DROP=var list
/KEEP=var list
/FIRST=var name
/LAST=var name
/MAP
but have no idea what to do with IN, BY, DROP, etc. Or the conventions
used.
If someone uses the parameters required to match one variable (let's call
it
"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
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url :
http://lists.gnu.org/archive/html/pspp-users/attachments/20100605/cf2c5d80/attachment.bin
------------------------------
_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org
http://lists.gnu.org/mailman/listinfo/pspp-users
End of Pspp-users Digest, Vol 50, Issue 2
*****************************************
<<winmail.dat>>
_______________________________________________ Pspp-users mailing list Pspp-users@gnu.org http://lists.gnu.org/mailman/listinfo/pspp-users
