Forum Discussion

erchs's avatar
erchs
Frequent Visitor
9 years ago
Solved

Generating numbers conditional on another column

My dataset contains a variable (X) with two categories, A and B.  The data looks like this:   X A A A A B B B B   I would like to generate a new variable, Y, such that there will be a ce...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi erchs,

     

    You can add a calculated column with RANDBETWEEN and SWITCH function to calculate the result:

     

    Y = SWITCH([X],"A",SWITCH(RANDBETWEEN(0,1),0,1,2),"B",SWITCH(RANDBETWEEN(0,3),0,3,4),-1)

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi erchs,

 

You can add a calculated column with RANDBETWEEN and SWITCH function to calculate the result:

 

Y = SWITCH([X],"A",SWITCH(RANDBETWEEN(0,1),0,1,2),"B",SWITCH(RANDBETWEEN(0,3),0,3,4),-1)

 

 

Regards,

Xiaoxin Sheng

erchs's avatar
erchs
Frequent Visitor
9 years ago

For my general understanding, would you please explain how do the % of As, Bs and Cs are being taken into consideration here? Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi erchs,

     

    >> would you please explain how do the % of As, Bs and Cs are being taken into consideration here? 

    For random 0 to 1, each item has 50% chance. it suitable for your request A.

     I want to create Y so that when X='A', Y will have 50% 1s and 50% 2s. 

     

    For random between 0 to 3, each items has 25% chance. I setting one item equal to 3(1*25%) and others to 4(3*25%), so it is suitable for you request B.

    when X='B', Y will have 25% 3s and 75% 4s. 

     

    Regards,

    Xiaoxin Sheng