[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Pspp-users Digest, Vol 50, Issue 2

From: Ferguson, Douglas A
Subject: RE: Pspp-users Digest, Vol 50, Issue 2
Date: 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
(843) 608-8008

-----Original Message-----
From: address@hidden on behalf of address@hidden
Sent: Sat 6/5/2010 12:01 PM
To: address@hidden
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..."

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: address@hidden (Ben Pfaff)
Subject: Re: How to open an excel file?
To: Kausik Chatterjee <address@hidden>
Cc: address@hidden
Message-ID: <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
>     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 <address@hidden>
Subject: Re: Matching 2 files...Simple Question?
To: Clarry <address@hidden>
Cc: address@hidden
Message-ID: <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.

        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 
          working dataset.  Additionally, create two new variables, FROM1 and 
          which indicate the source of each observation.

        match files 


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). . . 
     /IN=var name 
     /BY=var list 
     /DROP=var list 
     /KEEP=var list 
     /FIRST=var name 
     /LAST=var name 
     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 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 :


Pspp-users mailing list

End of Pspp-users Digest, Vol 50, Issue 2


reply via email to

[Prev in Thread] Current Thread [Next in Thread]