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


bug #30706: AGGREGATE: add support for random selection

Submitter:  Ben Pfaff <blp>
Submitted:  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
* Mandatory Fields

Add a New Comment Rich Markup

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>
Group 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)

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.


    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2011-05-14 blp ReleaseNone Future
    2010-08-08 blp SummaryAGGREGATE: add support for randoms selection AGGREGATE: add support for random selection
    2010-08-08 blp Carbon-Copy- Added -email is unavailable-

    Back to the top

    Powered by Savane 3.13-6ae7.
    Corresponding source code