Sorry 'Randomizing' may not be the right title for this thread. I am randomizing using Rand("uniform") Data Confidentialized ; Set Rollup(Rename=(Members=tmpMembers Spend=tmpSpend)) ; If tmpMembers LE 3 then do ; Random=rand("Uniform"); Members=0 ; IF Random GT 0.5 then Members=3 ; Dollars=(Members/tmpMembers)*tmpSpend; end ; IF tmpMembers GT 3 then do ; Members =tmpMembers ; Spend=tmpSpend ; end ; run ; *** BIAS Check ; Proc SQL ; Create table BiasCheck as SElect sum(Members)/sum(tmpMembers)-1 as MemberBias format Percent8.2, Sum(Spend)/Sum(tmpSpend)-1 as SpendBias format Percent8.2 From Confidentialized ; quit; proc print data=biascheck ; run ; Essentially, based on the results of the Bias check, i'd like to re-iterate the confidentialization code so I can 'promote' the version where both bias is less than 1% difference.
... View more