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, "[email protected]" <[email protected]> wrote: >Send Pspp-users mailing list submissions to > [email protected] > >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 > [email protected] > >You can reach the person managing the list at > [email protected] > >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 <[email protected]> >To: [email protected] >Subject: Transferring a cvs file to PSPP >Message-ID: <[email protected]> >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 > > >[email protected] >-------------- 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 >[email protected] >https://lists.gnu.org/mailman/listinfo/pspp-users > > >End of Pspp-users Digest, Vol 87, Issue 16 >****************************************** _______________________________________________ Pspp-users mailing list [email protected] https://lists.gnu.org/mailman/listinfo/pspp-users
