bugPSPP - Bugs: bug #30706, AGGREGATE: add support for random...


bug #30706: AGGREGATE: add support for random selection

Submitted by:  Ben Pfaff <blp>
Submitted on:  Sun 08 Aug 2010 10:43:02 PM UTC  
Category:  Syntax Parser Severity:  1 - Wishlist
Status:  None Assigned to:  None
Open/Closed:  Open Release:  Future
Effort:  0.00

Add a New Comment(Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


Mon 09 Aug 2010 06:27:53 AM UTC, comment #1:

Just a thought on this random function. I personally would prefer 2 different random methodologies.

The 2 options being a) random/variable and b) random/record. Meaning that if you aggregate 3 variables, in random/variable it would re-randomize which record to pick from for each variable.

a) Meaning if there are 3 variables being aggregated with this function. It could very well choose data from record 1 in var 1 and from rec 2 in var 2 and from rec 1 in var 3 again. Meaning it would be really random.

b) Keeping it random but structured would be to let it randomise for which record to use in it's entirety for all 3 variables when aggregating (as they may very well have some sort of link between them). Typically this would be more tricky to write, but I believe a fair assumption would be to let all in one of these commands be checked. If multiple variables are chosen with this option, do one random and use it.

I also note in examples above I use only 2 records as example, but note it might very well be more than that.

Thirdly but lastly. I note that there are sysmissing issues noted in the current dropdown functions list. I would prefer a tick box to say "Never include sysmis in function" as an option. This would mean that for the case above for instance, it would randomise between those that have data, or if not ticked in between all. Also being peculiar for option b as it would have to check all variables before deciding to choose whether a specific record can go into the choosing process of randomisation.

Fredrik Clementz <clementz>
Sun 08 Aug 2010 10:43:02 PM UTC, original submission:

From: Fredrik Clementz <fredrik.clementz@reflect.se>

> 3. If we'd really like to go a bit beyond SPSS which I personally would enjoy,
> one of the functions I would appreciate is to add the function "random". So
> when aggregating a dataset and there are 2 similar cases, how about choosing a
> random value from these. Would be really useful.

Ben Pfaff <blp>
Project Administrator


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by clementz (Posted a comment)
  • -email is unavailable- added by blp (Submitted the item)
  • -email is unavailable- added by blp (requester)

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.


    Please enter the title of George Orwell's famous dystopian book (it's a date):



    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    Sat 14 May 2011 04:48:43 AM UTC blp ReleaseNone => Future
    Sun 08 Aug 2010 10:43:13 PM UTC blp SummaryAGGREGATE: add support for randoms selection => AGGREGATE: add support for random selection
    Sun 08 Aug 2010 10:43:02 PM UTC blp Carbon-Copy- => Added -email is unavailable-

    Back to the top

    Powered by Savane 3.3