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

[Ferguson, Douglas A]

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: 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
        address@hidden

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
        address@hidden

You can reach the person managing the list at
        address@hidden

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:
        
http://www.gnu.org/software/pspp/manual/html_node/GET-DATA-_002fTYPE_003dGNM.html#GET-DATA-_002fTYPE_003dGNM

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 
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
address@hidden
http://lists.gnu.org/mailman/listinfo/pspp-users


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

<<winmail.dat>>