# Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

10 messages
Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

 I wish to express my sincere thanks to the following people : Hillel Vardi,Beadle ViAnn,and Richard Ristow for your contributions (advice and syntax) on the above subject. Sorry to say that I have not been able to achieve my desired objective: I below is re-statement of what I want to do. Giving a data file c:\Temp\OriginalData.sav with variables x(1-4) ,y(1-3) , z1(1-15), z2(1-15),z3(1-15), and z4(1-15)  z1, z2 ,z3 and Z4 have identical categories(15). I want to do the following: 1.Identify 10  most frequent occurring categories of Z ( where Z is a combination of z1, Z2, z3 and z4) 2.Set z1,z2,z3 and z4 to missing for values of z1,z2,z3,z4 not in  10  most frequent occurring categories  Thus if the categories (2,4,7,9,12) of z1,z2,z3 and z4 are not in the 10  most frequent occurring categories, set  it to sysmiss 3. Save the new file as c:\Temp\NewData.sav with variables x,y,z1,z2,z3 and z4 Any help on this task will be very much appreciated. Warm regards to all.
Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

 OK, let's try this from a different tack because I don't think anybody understands what you mean by most frequently occurring categories. Do you want to count occurrences of values across all four variables so that if z1 and z2 each have the value 14, that counts for two occurrences of 14? Perhaps if you would tell us why you want to do this, we would better understand your question. Or if you could give us a small set of data for the 4 variables and tell us what you think are the top 2 values (so you don't have to provide so much data that we can't read it), we would could provide more help here. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Edward Boadi Sent: Thursday, August 03, 2006 2:29 PM To: [hidden email] Subject: Re: 10 most frequent occurring values of a multiple response set ( REVISITED ) I wish to express my sincere thanks to the following people : Hillel Vardi,Beadle ViAnn,and Richard Ristow for your contributions (advice and syntax) on the above subject. Sorry to say that I have not been able to achieve my desired objective: I below is re-statement of what I want to do. Giving a data file c:\Temp\OriginalData.sav with variables x(1-4) ,y(1-3) , z1(1-15), z2(1-15),z3(1-15), and z4(1-15)  z1, z2 ,z3 and Z4 have identical categories(15). I want to do the following: 1.Identify 10  most frequent occurring categories of Z ( where Z is a combination of z1, Z2, z3 and z4) 2.Set z1,z2,z3 and z4 to missing for values of z1,z2,z3,z4 not in  10  most frequent occurring categories  Thus if the categories (2,4,7,9,12) of z1,z2,z3 and z4 are not in the 10  most frequent occurring categories, set  it to sysmiss 3. Save the new file as c:\Temp\NewData.sav with variables x,y,z1,z2,z3 and z4 Any help on this task will be very much appreciated. Warm regards to all.
Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

Open this post in threaded view
|

## Re: 10 most frequent occurring values of a multiple response set ( REVISITED )

Open this post in threaded view
|