I would like to randomly re-assign records based on criteria. For example in the table below, I would like to re-assign 30% of records where the ID is 4 to be an ID of 2, and 10% of the records where the ID is 3 to be an ID of 2. I have looked into the rand function using both bernoulli and uniform and can't seem to get it right. I believe using the rand("uniform") or rand("bernoulli") functions is what would work best, but I can't seem to get the code dynamic enough to account for the specific percentages and also re-assign based on two different criteria.   ... View more

I have a column with IDs that repeat, and I would like to translate the second column to repeat the first value for each unique ID. EXCEPT for when the value is NULL, the value needs to stay NULL. Below is an example of the column I have, and the column I want.  ID HAVE WANT 1 12 12 1 19 12 1 23 12 2 40 40 2 NULL NULL 2 25 40 3 NULL NULL 3 11 11 3 NULL NULL 4 24 24 4 NULL NULL 4 72 24 4 NULL NULL   ... View more

I have a dataset where I need to make sure that each like ID gets assigned the same Value. It's not so much that I need to select a specific value to repeat from all that are assigned to the like ID, but that I need all the like IDs to have the same Value.  Data Have: Id Value 101 656 101 756 101 805 101 752 501 999 502 405 502   365  Data Want: Id Value Selected 101 656 656 101 756 656 101 805 656 101 752 656 501 999 999 502 405 999 502   365     999     ... View more