Ex: I have a 1000 records that are assigned as treated records. I need to assign 10% or 100 of those treated records as control records. So Treated would be 0 and control would be 1 by segment/age/income without having to manually use update queries for each combination. Would it be best to use a cursor, CTE or some other methodology? Thanks!
Want to set control to be 10% of the treated by segment/age/income without manually calculating it..there are alot of distributions.