Jessie Braden | 1 Nov 20:15 2011
Picon

export entire data table

Hi everyone,

 

I just started using PSPP (and I’m not a programmer). I’d like to export my entire data table to a format I can use in Excel. I read in the archives that you can export an output table to .csv but I don’t see an option to export the whole data table.

 

I tried exporting the data table as a .por file but I get an error. It says, “error: creating temporary file C:\Program Files\PSPP\test;.por.tmpOOIp1n: Permission denied.”

We have to have an admin login to install programs so I wonder if I can’t even write to the C:\Program Files folder. Any thoughts?  I also tried going through the syntax editor and doing EXPORT (calling it a .csv file) but I got the same error.


Somehow, though, the other day I did manage to create a .por file. However it was really small and came through totally jumbled when I tried to open it in Excel using the Text Import Wizard. Using Excel 2010 and PSPPIRE 0.7.5-g70514b.

 

Finally I tried selecting the whole table and simply Copy->Paste. This is almost works except I consistently lose about 8 rows of data  (from the middle of my dataset). And the headers don’t copy over. Our dataset only has 145 rows of data so far but we have 427 variables (huge survey). It won’t let me Copy from Variable View (I could grab the column headers that way and transpose in Excel).

 

Any thoughts? We really need to get this data table into Excel for a project partner.

 

Thank you,

Jessie

_______________________________________________
Pspp-users mailing list
Pspp-users <at> gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users
Ben Pfaff | 2 Nov 06:10 2011
Picon

Re: export entire data table

Jessie Braden <jbraden <at> prattcenter.net> writes:

> I tried exporting the data table as a .por file but I get an error. It says,
> “error: creating temporary file C:\Program Files\PSPP\test;.por.tmpOOIp1n:
> Permission denied.”
>
> We have to have an admin login to install programs so I wonder if I can’t even
> write to the C:\Program Files folder. Any thoughts?  I also tried going
> through the syntax editor and doing EXPORT (calling it a .csv file) but I got
> the same error.

What directory did you tell PSPPIRE to put the file into?  If it
isn't C:\Program Files\PSPP, then this sounds like a bug.

What syntax did you use?

> Somehow, though, the other day I did manage to create a .por file. However it
> was really small and came through totally jumbled when I tried to open it in
> Excel using the Text Import Wizard. Using Excel 2010 and PSPPIRE
> 0.7.5-g70514b.

A .por file contains text but it isn't plain text.  I wouldn't
expect that it would import sensibly in anything that doesn't
specifically understand the .por format.

> Finally I tried selecting the whole table and simply Copy->Paste. This is
> almost works except I consistently lose about 8 rows of data  (from the middle
> of my dataset). And the headers don’t copy over. Our dataset only has 145 rows
> of data so far but we have 427 variables (huge survey). It won’t let me Copy
> from Variable View (I could grab the column headers that way and transpose in
> Excel).

Hmm.  I tried a bunch of copy and paste of large table data just
now (over 900 rows, hundreds of columns) and couldn't reproduce a
problem like that.  A few programs that I pasted into did lose
some rows, but always at the end.  I didn't have any trouble with
the headers.

I think that your best bet is probably to export the output to
.csv format.  This works OK for me with the latest PSPPIRE; just
select CSV format from File|Export in the Output window.

You'll probably want to upgrade from 0.7.5 to the latest version
though.  I don't know where to get an up-to-the-minute latest
version for Windows.

My test platform is GNU/Linux.  I hear that there are Windows
specific bugs; perhaps this is one.
--

-- 
Ben Pfaff 
http://benpfaff.org

_______________________________________________
Pspp-users mailing list
Pspp-users <at> gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users
John Darrington | 2 Nov 19:05 2011
Picon

Re: export entire data table

On Tue, Nov 01, 2011 at 10:10:05PM -0700, Ben Pfaff wrote:

     I think that your best bet is probably to export the output to
     .csv format.  This works OK for me with the latest PSPPIRE; just
     select CSV format from File|Export in the Output window.

If I read Jessie's message correctly, she's trying to export the data,
not the output.

We don't currently have a menu for doing that, but it can be done 
manually using the SAVE TRANSLATE command.

J'

--

-- 
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.

_______________________________________________
Pspp-users mailing list
Pspp-users <at> gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users
John Darrington | 2 Nov 20:02 2011
Picon

General reminder

This is a general reminder to everyone about how to ask for help with PSPP.
This message is sent to everyone who joins this list, but it seems that 
some people joined a long time ago and have forgotten.

You are strongly recommended to read Eric Raymond's excellent text "How to ask 
questions the smart way" which you can find at 
http://catb.org/~esr/faqs/smart-questions.html 

The following points in particular are especially relevant.

* State which version of PSPP you are using.  In the GUI you can see this using 
  the menu Help|About - In the command line "pspp --version" will tell you.  If 
  you are using a precompiled binary downloaded from some 3rd party website, or 
  a package from a distributes OS such as Ubuntu or Debian that is also relevant.

* State the operating system you are using - and be specific as possible.

* Include in your message a copy of the syntax which you have been trying.  If 
  you are using the GUI, the syntax automatically gets logged in the file called 
  pspp.jnl

* Choose the right forum: If you are sure you have found a bug AND you are 
  using a very recent pspp version, then open a bug report at 
  http://savannah.gnu.org/bugs/?group=pspp AFTER you have checked to see that 
  it's not already been reported.  If you are not sure whether your problem is 
  a bug or not, assume that it's not and ask on pspp-users <at> gnu.org Please do 
  not send help requests to the developer's mailing list.

* If somebody replies to your question and you need to follow it up, post your 
  follow-up question to the list.  Don't send the person a private email unless 
  they explicitly invite you to.

Thanks for listening.

--

-- 
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.

_______________________________________________
Pspp-users mailing list
Pspp-users <at> gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users
Ben Pfaff | 2 Nov 20:09 2011
Picon

Re: export entire data table

John Darrington <john <at> darrington.wattle.id.au> writes:

> On Tue, Nov 01, 2011 at 10:10:05PM -0700, Ben Pfaff wrote:
>
>      I think that your best bet is probably to export the output to
>      .csv format.  This works OK for me with the latest PSPPIRE; just
>      select CSV format from File|Export in the Output window.
>      
> If I read Jessie's message correctly, she's trying to export the data,
> not the output.

I was running LIST from syntax, then exporting the output table
to .csv.  It works pretty well, even though it's not the most
obvious way to do it.
--

-- 
Ben Pfaff 
http://benpfaff.org
Harry Thijssen | 2 Nov 20:23 2011
Picon

Re: Re: export entire data table

> You'll probably want to upgrade from 0.7.5 to the latest version
> though.  I don't know where to get an up-to-the-minute latest
> version for Windows.
>
> My test platform is GNU/Linux.  I hear that there are Windows
> specific bugs; perhaps this is one.
> --

As usual a reasonable current version can be found through
pspp.awardspace.com At the moment this is version 1 week old.

Have fun
Ben Pfaff | 3 Nov 00:43 2011
Picon

Re: export entire data table

"Rode, Nino" <Nino.Rode <at> fsd.uni-lj.si> writes:

> Nevertheless, it would be nice to get an Export item in the
> File menu. Any chance for it in the near future?

It's not too hard, but there's a lot to work on.  It'd be nice if
you would file a "wishlist" bug in the Savannah bug tracker as a
reminder.

Thanks,

Ben.
--

-- 
Ben Pfaff 
http://benpfaff.org
Ben Pfaff | 3 Nov 05:12 2011
Picon

Re: FW: Regression output format

John Darrington <john <at> darrington.wattle.id.au> writes:

> One thing I do agree is very confusing however is that the tables give no 
> indication of the dependent variable to which they refer.  We should do something
> about this.o

I added a bug for this in Savannah:
https://savannah.gnu.org/bugs/index.php?34732

--

-- 
Ben Pfaff 
http://benpfaff.org
Ben Pfaff | 3 Nov 06:00 2011
Picon

Re: Import .sav File Causing Warnings

Andy Choens <andy.choens <at> gmail.com> writes:

> I've got two SPSS files that I'm willing to send to anyone who wants to see 
> them. 
> File #1 - Created with SPSS 11 on Windows. 
> File #2 - Created with SPSS 20 on Linux (Ubuntu).
>
> File number 1 opens normally in PSPP. File two does not. File #2 does opens 
> and the data imports (integers at least import OK), but I get a bunch of 
> warnings. The same thing happens in R (down to the errors), wihch makes sense. 
> As I remember, PSPP and R both use the same underlying system to import/open 
> SPSS data files.
>
> I get the following warnings when opening file #2:
>
> PSPP warning: "/home/andy/dev/spss-import/test-spss20.sav" near offset 0x148: 
> File specifies unexpected value -1.79769e+308 as LOWEST.
> PSPP warning: "/home/andy/dev/spss-import/test-spss20.sav" near offset 0x164: 
> Invalid variable display parameters for variable 0 (DUMB).  Default parameters 
> substituted.
> PSPP warning: "/home/andy/dev/spss-import/test-spss20.sav" near offset 0x1c7: 
> Unrecognized record type 7, subtype 18.  Please send a copy of this file, and 
> the syntax which created it to bug-gnu-pspp <at> gnu.org.

Andy, did you ever get this resolved?  I now have time to take a
look at the problem and, presumably, fix it.  Please send me the
files.

Thanks,

Ben.
--

-- 
Ben Pfaff 
http://benpfaff.org
Pradeep | 3 Nov 05:59 2011
Picon

P value in Scientific notation

Hello PSPP users,

Is it possible to get the p-values displayed in scientific notation?
Currently, it rounds it up to 2 decimal places in the out put.

Thanks,
Pradeep

Gmane