Transferring a cvs file to PSPP

[CHRIS WARNER]

Dear Mark
I too, am a newbie to PSPP but love it.I run it on MacBook Pro and have
had the same problem. The way I get round it is to open the excel csv file
in Libre office
(free to download) using the spreadsheet app. Then I save that file as a
csv file with the encoding at UTF8. I then import that data and it has
worked fine.

I assume that the excel file has listed the responses as separate lines in
the first place?

Hope that this helps
-- 






On 24/08/2013 02:50, "address@hidden"
<address@hidden> wrote:

>Send Pspp-users mailing list submissions to
>       address@hidden
>
>To subscribe or unsubscribe via the World Wide Web, visit
>       https://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. Transferring a cvs file to PSPP (Mark Levine)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Fri, 23 Aug 2013 21:39:49 -0400
>From: Mark Levine <address@hidden>
>To: address@hidden
>Subject: Transferring a cvs file to PSPP
>Message-ID: <address@hidden>
>Content-Type: text/plain; charset="us-ascii"
>
>Hi folks,
>
>Newbie to PSPP, used SPSS decades ago. What a great idea!! I am seriously
>impressed by what this team has put together. I am currently trying to
>use PSPP 0.8.0 on a MacBook Pro running OS 10.8.4.
>
>Basic problem: I don't know how to tell PSPP what to expect in terms of
>NVAR and NCASE. I get one case and a load of variables.
>
>I want to analyze a small survey, roughly vars = 100, N = 150, collected
>on Survey Monkey. I want to do some basic descriptive, correlational, and
>multivariate stuff, etc. I have eliminated the open-ends (because some
>responses were very long and I was getting an error message from PSPP)
>and deleted the row of the column labels.
>
>OK, I have a clean dataset, I saved it as a cvs file in Excel as John
>Darrington suggested and tried to open it. Unfortunately (and reasonably)
>PSPP saw the data as one respondent with a load of vars. It didn't know
>how many variables to fill in and then to go on to the next case. I can't
>find a way to tell PSPP how many vars, how many rows to expect. Just
>can't get from cvs file into PSPP.
>
>How do I set up PSPP to accept a cvs file? Am I missing something?
>
>Can the community guide me a bit or point me to a resource or a previous
>thread? I've searched and found the one with John's suggestion and that's
>about it.
>
>Here's where I am:
>
>
>
>Your thoughts????? If there is any further info needed, please advise.
>
>ALSO: Does a guide to the GUI version exist?
>
>HELP!!
>
>Cheers,
>
>Mark
>
>
>address@hidden
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: 
><http://lists.gnu.org/archive/html/pspp-users/attachments/20130823/9909e89
>b/attachment.html>
>-------------- next part --------------
>A non-text attachment was scrubbed...
>Name: Screen Shot 2013-08-23 at 9.25.41 PM.png
>Type: image/png
>Size: 339540 bytes
>Desc: not available
>URL: 
><http://lists.gnu.org/archive/html/pspp-users/attachments/20130823/9909e89
>b/attachment.png>
>-------------- next part --------------
>A non-text attachment was scrubbed...
>Name: msl.jpg
>Type: image/jpeg
>Size: 4751 bytes
>Desc: not available
>URL: 
><http://lists.gnu.org/archive/html/pspp-users/attachments/20130823/9909e89
>b/attachment.jpg>
>
>------------------------------
>
>_______________________________________________
>Pspp-users mailing list
>address@hidden
>https://lists.gnu.org/mailman/listinfo/pspp-users
>
>
>End of Pspp-users Digest, Vol 87, Issue 16
>******************************************