Challenge with combining data files

Hello, I have been trying to marge 2 different dataset files for analysis on the pspp, but its very difficult to understand the command syntax because I'm not a programmer. Can someone help me wit an example of how it can be done? Kind regards. Hamza Ibrahim National Teachers' institute,Nigeria __

RE: Getting PSPP compiled version with PostgreSQL support

Dear Alan, Many thanks for the very quick reply! Thanks for the insight. We can make use of the Linux version to do most of the donkey work, so I'll stick with that for the moment. This is just such a great tool. We are a publicly funded medical research organisation and PSPP came to our re

Re: Getting PSPP compiled version with PostgreSQL support

Great! Let us know when there's a version ready for testing. I can run 32- and 64-bit versions. -Alan On 3/19/2016 4:20 PM, Harry Thijssen wrote: > Hi Alan > > Actually I already working the whole weekend at this issue. Hopefully > it will be fixed today or tomorrow. > > I have not heard of pe

Re: Getting PSPP compiled version with PostgreSQL support

Hi Alan Actually I already working the whole weekend at this issue. Hopefully it will be fixed today or tomorrow. I have not heard of people for which it is a break point, but it can definitely be useful if working which large or realtime datasets. Have fun 2016-03-19 21:52 GMT+01:00 Alan Mead

Re: Getting PSPP compiled version with PostgreSQL support

Maybe we're straying a bit from the topic at hand... Should we fix the Windows build to support PSQL? My point is that I don't see much use, but clearly Philip Curran sees a use. And John's answer seems pretty emphatically in favor of the feature. So, if it's missing from the Windows version, th

Re: Getting PSPP compiled version with PostgreSQL support

> You could do that with a single select statement (albeit a complicated > one). > You would need to use an inner join and an additional where clause. > > I would recommend creating a view and the join in the view. For big data and realtime data the use of a database looks a good idea to me. Ha

Re: Getting PSPP compiled version with PostgreSQL support

On Sat, Mar 19, 2016 at 01:48:13PM -0500, Alan Mead wrote: I'd be curious to hear how Philip is using this feature because if you can get data from a database using a single select statement, then you can also redirect those data into a TAB delimited file. So, this just s

Re: Getting PSPP compiled version with PostgreSQL support

Harry, My replies are inline below. Cheers! -Alan On 3/19/2016 9:38 AM, Harry Thijssen wrote: > > > Date: Thu, 17 Mar 2016 17:09:18 + > From: "Curran, Philip" > > To: "pspp-users@gnu.org " > mailto:pspp-users@gn

Re: Getting PSPP compiled version with PostgreSQL support

Philip, Has anyone answered you off-line? I don't know anything about PSQL support, but I see that it's not enabled in the Windows binaries provided by Harry Thijssen. A couple years ago this came up and he said: > I doubt if my MSWindows build has a working support for PostgreSQL. At > least I

Re: Challenge with combining data files

Hello, there is a good introduction here: http://www.ats.ucla.edu/stat/spss/modules/merge.htm Cheers, Zoltán On 2016-03-17 14:01, hamza ibrahim wrote: Hello, I have been trying to marge 2 different dataset files for analysis on the pspp, but its very difficult to understand the command syn

Re: Getting PSPP compiled version with PostgreSQL support

> > > Date: Thu, 17 Mar 2016 17:09:18 + > From: "Curran, Philip" > To: "pspp-users@gnu.org" > Subject: Getting PSPP compiled version with PostgreSQL support > > I would like to obtain compiled a compiled version of PSPP with PostgreSQL > support included for Windows. Can anyone list a locati

Re: Challenge with combining data files

Hamza, Tell us more about the data. One key distinction is whether you are merging files of the same people with different variables ("adding columns") or if you are merging files of different people on the same variables ("adding cases"). And there are less common possibilities. like dictionary

Re: Combining dataset files in PSPP

Hamza, I need more information about what you are trying to accomplish. Can you give us a small example of the data you are trying to merge? -Alan On 3/17/2016 10:01 AM, hamza ibrahim wrote: > > Help doctor, I'm new to PSPP. I have been trying to combine some > dataset files using the syntax

Re: Combining dataset files in PSPP

How is record 1 of the breastfeeding practices datafile related to record(s) in the socioeconomic factors and breastfeeding knowledge datafiles? Is there a unique identifier? If so, what is the name of the variable? -Alan On 3/17/2016 10:34 AM, hamza ibrahim wrote: > > Thanks for the response.

Getting PSPP compiled version with PostgreSQL support

I would like to obtain compiled a compiled version of PSPP with PostgreSQL support included for Windows. Can anyone list a location and version number for this? I currently run 0.9.0-g745ee3 on Windows. I would like a Linux version too, but it's easier to build this from source. Kind regards,