using frequencies as a filter variable

[Gekko]

hi i have the following problem and do not know, how to solve this in spss:

i have a data set with produkt evaluations from differend respondents in the rows who evaluated one of 200 produkts (that all have a unique produkt id saved into an variable produkt id)

for example resp. 1,24,126 and 640 evaluated produkt it 333

now i want to run some analysis but only with those produkts, that have at least a number of x evaluations, that is, where the frequencies table for  the product ids shows me at least an x.

for example where there are at least 3 evaluations - and in this case product id 333 should be valid, since it counts 4 evaluations

the problem is, that i do not get the frequencies into an spss variable

is this possible?

[Peck, Jon]

The simplest way to do this is to use AGGREGATE to add the group count to each case, e.g.
AGGREGATE
  /OUTFILE=*
  MODE=ADDVARIABLES
  /BREAK=productcode
  /N_BREAK=N.

Then filter on N_BREAK.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gekko
Sent: Thursday, January 10, 2008 2:42 AM
To: [hidden email]
Subject: [SPSSX-L] using frequencies as a filter variable

hi i have the following problem and do not know, how to solve this in spss:

i have a data set with produkt evaluations from differend respondents in the
rows who evaluated one of 200 produkts (that all have a unique produkt id
saved into an variable produkt id)

for example resp. 1,24,126 and 640 evaluated produkt it 333

now i want to run some analysis but only with those produkts, that have at
least a number of x evaluations, that is, where the frequencies table for
the product ids shows me at least an x.

for example where there are at least 3 evaluations - and in this case
product id 333 should be valid, since it counts 4 evaluations

the problem is, that i do not get the frequencies into an spss variable

is this possible?
--
View this message in context: http://www.nabble.com/using-frequencies-as-a-filter-variable-tp14730780p14730780.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Pearmain, Michael]

Hi All,

Has anyone used GPL to create a Venn diagram of 2 products and there
intersection?

Is this possible?

Any help appreciated

Mike

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Fry, Jonathan B.]

This would be easy if you had a variable containing the frequency count for the product_id variable.  In recent releases of SPSS, you can add it using a command like

        Aggregate /break=product_id/id_frequency = n.

Then create your filter using the GUI or using the commands

Compute filter_$ = id_frequency > 3.
Filter by filter_$.

Jonathan Fry
SPSS Inc.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gekko
Sent: Thursday, January 10, 2008 3:42 AM
To: [hidden email]
Subject: using frequencies as a filter variable

hi i have the following problem and do not know, how to solve this in spss:

i have a data set with produkt evaluations from differend respondents in the
rows who evaluated one of 200 produkts (that all have a unique produkt id
saved into an variable produkt id)

for example resp. 1,24,126 and 640 evaluated produkt it 333

now i want to run some analysis but only with those produkts, that have at
least a number of x evaluations, that is, where the frequencies table for
the product ids shows me at least an x.

for example where there are at least 3 evaluations - and in this case
product id 333 should be valid, since it counts 4 evaluations

the problem is, that i do not get the frequencies into an spss variable

is this possible?
--
View this message in context: http://www.nabble.com/using-frequencies-as-a-filter-variable-tp14730780p14730780.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD