question

red68 avatar image
red68 asked

Want to set control to be 10% of the treated population by segment/age/income without manually calculating it..there are alot of distributions. Do I use a cursor or best way to do this without manually running it? Thx.

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.eyesheavy_check_mark+1

oracle-sql-developer
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.