SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Need efficient way to create a variables calculating differences in a wide dataset

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Need efficient way to create a variables calculating differences in a wide dataset

[ Edited ]

Hello,

 

I am currently working with a wide dataset where we collected readings for ~32 various mRNA markers. Each variable has two values, denoted "x_20" and "x_30" (where x is the mRNA type). I would like to calculate the difference between these variables and perform some calculations.

 

If there were just one variable, this would be simple. Lets say I have an example dataset with only one variable with both readings, x_20 and x_30. I would do the following calculations:

data example;
	/*1. Difference between readings*/    diff_x=x_30-x_20; 				
	/*2. Two raised to this difference*/  fc_raw_x=2**diff_x; 			
	/*3. Untransformed if >=1*/           if fc_raw_x ge 1 then foldchange_x=fc_raw_x; 
	/*4. Transformed if <1*/              else if 0<fc_raw_x<1 then foldchange_x=-1/fc_raw_x;
drop fc_raw_x diff_x; 
run;

The problem is there is not just one variable, and I need to repeat this ~32 times. I was wondering if there is a way to  automate it using an array or some other method. Unfortunately my attempts at solving this problem have hit a roadblock, and any help will be appreciated. I am attaching the data2datastep code below:

 

data WORK.HAVE;
  infile datalines dsd truncover;
  input il6_mrna_20:32. il6_mrna_30:32. ifng_mrna_20:32. ifng_mrna_30:32. tnfa_mrna_20:32. tnfa_mrna_30:32. lta4h_mrna_20:32. lta4h_mrna_30:32. tgfb_mrna_20:32. tgfb_mrna_30:32. ccl2_mrna_20:32. ccl2_mrna_30:32. hif1a_mrna_20:32. hif1a_mrna_30:32. mmp8_mrna_20:32. mmp8_mrna_30:32. mmp9_mrna_20:32. mmp9_mrna_30:32. timp3_mrna_20:32. timp3_mrna_30:32. s100a8_mrna_20:32. s100a8_mrna_30:32. s100a9_mrna_20:32. s100a9_mrna_30:32. elane_mrna_20:32. elane_mrna_30:32. cxcl8_mrna_20:32. cxcl8_mrna_30:32. tlr2_mrna_20:32. tlr2_mrna_30:32. tlr4_mrna_20:32. tlr4_mrna_30:32. tlr5_mrna_20:32. tlr5_mrna_30:32. nlrp3_mrna_20:32. nlrp3_mrna_30:32. nlrc4_mrna_20:32. nlrc4_mrna_30:32. myd88_mrna_20:32. myd88_mrna_30:32. card8_mrna_20:32. card8_mrna_30:32. il18_mrna_20:32. il18_mrna_30:32. il18r_mrna_20:32. il18r_mrna_30:32. il1b_mrna_20:32. il1b_mrna_30:32. il1r_mrna_20:32. il1r_mrna_30:32. aim_mrna_20:32. aim_mrna_30:32. casp1_mrna_20:32. casp1_mrna_30:32. casp5_mrna_20:32. casp5_mrna_30:32. acsl1_mrna_20:32. acsl1_mrna_30:32. glut1_mrna_20:32. glut1_mrna_30:32. mpo_mrna_20:32. mpo_mrna_30:32. ctsg_mrna_20:32. ctsg_mrna_30:32. pkm_mrna_20:32. pkm_mrna_30:32. idh3b_mrna_20:32. idh3b_mrna_30:32. eno_mrna_20:32. eno_mrna_30:32. dlst_mrna_20:32. dlst_mrna_30:32. mip1a_mrna_20:32. mip1a_mrna_30:32. pid:32.;
  label il6_mrna_20="il6_mrna_20" il6_mrna_30="il6_mrna_30" ifng_mrna_20="ifng_mrna_20" ifng_mrna_30="ifng_mrna_30" tnfa_mrna_20="tnfa_mrna_20" tnfa_mrna_30="tnfa_mrna_30" lta4h_mrna_20="lta4h_mrna_20" lta4h_mrna_30="lta4h_mrna_30" tgfb_mrna_20="tgfb_mrna_20" tgfb_mrna_30="tgfb_mrna_30" ccl2_mrna_20="ccl2_mrna_20" ccl2_mrna_30="ccl2_mrna_30" hif1a_mrna_20="hif1a_mrna_20" hif1a_mrna_30="hif1a_mrna_30" mmp8_mrna_20="mmp8_mrna_20" mmp8_mrna_30="mmp8_mrna_30" mmp9_mrna_20="mmp9_mrna_20" mmp9_mrna_30="mmp9_mrna_30" timp3_mrna_20="timp3_mrna_20" timp3_mrna_30="timp3_mrna_30" s100a8_mrna_20="s100a8_mrna_20" s100a8_mrna_30="s100a8_mrna_201" s100a9_mrna_20="s100a9_mrna_20" s100a9_mrna_30="s100a9_mrna_30" elane_mrna_20="elane_mrna_20" elane_mrna_30="elane_mrna_30" cxcl8_mrna_20="cxcl8_mrna_20" cxcl8_mrna_30="cxcl8_mrna_30" tlr2_mrna_20="tlr2_mrna_20" tlr2_mrna_30="tlr2_mrna_30" tlr4_mrna_20="tlr4_mrna_20" tlr4_mrna_30="tlr4_mrna_30" tlr5_mrna_20="tlr5_mrna_20" tlr5_mrna_30="tlr5_mrna_30" nlrp3_mrna_20="nlpr3_mrna_20" nlrp3_mrna_30="nlrp3_mrna_30" nlrc4_mrna_20="nlrc4_mrna_20" nlrc4_mrna_30="nlrc4_mrna_30" myd88_mrna_20="myd88_mrna_20" myd88_mrna_30="myd88_mrna_30" card8_mrna_20="card8_mrna_20" card8_mrna_30="card8_mrna_30" il18_mrna_20="il18_mrna_20" il18_mrna_30="il18_mran_30" il18r_mrna_20="il18r_mrna_20" il18r_mrna_30="il18r_mran_30" il1b_mrna_20="il1b_mrna_20" il1b_mrna_30="il1b_mrna_30" il1r_mrna_20="il1r_mrna_20" il1r_mrna_30="il1r_mrna_30" aim_mrna_20="aim_mrna_20" aim_mrna_30="aim_mrna_30" casp1_mrna_20="casp1_mrna_20" casp1_mrna_30="casp1_mrna_30" casp5_mrna_20="casp5_mrna_20" casp5_mrna_30="casp5_mrna_30" acsl1_mrna_20="acsl1_mrna_20" acsl1_mrna_30="acsl1_mrna_30" glut1_mrna_20="glut1_mrna_20" glut1_mrna_30="glut1_mrna_30" mpo_mrna_20="mpo_mrna_20" mpo_mrna_30="mpo_mrna_30" ctsg_mrna_20="ctsg_mrna_20" ctsg_mrna_30="ctsg_mrna_30" pkm_mrna_20="pkm_mrna_20" pkm_mrna_30="pkm_mrna_30" idh3b_mrna_20="idh3b_mrna_20" idh3b_mrna_30="idh3b_mrna_30" eno_mrna_20="eno_mrna_20" eno_mrna_30="eno_mrna_30" dlst_mrna_20="dlst_mrna_20" dlst_mrna_30="dlst_mrna_30" mip1a_mrna_20="mip1a_mrna_20" mip1a_mrna_30="mip1a_mrna_30";
datalines4;
20.599713236,,13.64,,13.244274883,,11.159417677,,7.982662615,,11.425,,9.950288197,,16.454321171,,9.8663426561,,30,,4.9681762042,,4.4603192668,,17.75,,14.57,,11.72,,11.799641116,,12.080737477,,13.165740416,,11.751409637,,9.7108351832,,12.303253456,,14.506718629,,14.875550818,,10.840000361,,15.693601542,,15.693601542,,8.31,,12.155,,9.8139004021,,12.230475584,,13.863659849,,15.625,,8.5761022305,,13.529560173,,8.7999801791,,12.32,,11.425,,50200003
19.324609686,19.438410981,14.165844161,14.990885596,12.271350307,12.756165267,9.6250901239,9.599299401,7.0659214131,5.7405847513,12.191590267,12.162601277,8.6477593763,8.0844562947,15.663306983,13.521277049,9.5587949954,6.0122202195,21.711384691,18.536341618,5.9511076891,2.9274818614,5.080330725,3.043944777,19.45865712,18.124386436,13.583677539,12.259550313,10.405242582,10.310677005,10.296968149,9.6824903625,11.438769795,11.052985657,10.99596968,10.570391781,11.100507583,11.354683273,8.1587706398,6.513183265,10.825263678,10.375018095,14.046843501,15.606048273,14.590152441,15.047027306,9.205568354,7.4631870791,14.330878458,13.170760841,12.032748327,11.925883798,7.7838966427,6.5513536037,11.189748871,10.040773952,10.208279949,9.4474378207,11.005779692,10.732299022,14.144381062,12.405396071,17.060289807,15.702638593,6.3147973417,5.7144323843,11.909414102,12.03123189,7.9312586685,7.102523903,10.649972301,11.347187777,12.067964225,11.064059043,50200005
16.973344647,19.050082423,9.2358226242,13.394602775,11.888259683,13.290469004,6.1787109572,9.406230365,4.6646799737,6.6555037504,11.033132198,13.706598324,3.6962974808,7.8298712905,10.461905508,14.255896833,4.4192520048,7.5728652494,30,19.261114881,0.1,3.1998478276,0.033571591,3.5411087782,17.39168543,18.984426094,9.4333587014,13.927779481,5.9376559448,9.7289324468,6.6781960054,9.7827768741,4.9015048144,9.2806145238,10.397821741,12.409540819,6.5452292886,10.278945011,5.1075932753,8.3668051671,7.855951914,10.44852336,10.68116492,13.802071357,9.9671602907,13.676473315,4.9473264526,8.206275434,9.7713017008,13.817142417,6.0475966896,10.100383061,2.2542121312,6.6133809801,6.143018757,9.7476808617,4.8819312226,7.9849863483,6.9092714799,10.227147648,11.632542892,14.510486314,13.472536971,15.895135149,5.1246302805,7.2054166244,10.485177866,12.737859445,6.6850732233,8.92501791,9.9045344922,11.378075406,9.2861839028,13.033505475,50200006
20.807275075,,16.38,,14.664618825,,12.148901758,,7.6031468449,,12.93,,9.8499900567,,14.285289991,,7.018382892,,30,,6.054423756,,4.9856764413,,18.735,,15.46,,12,,11.740343453,,12.492039591,,13.986128339,,13.268383791,,9.6515580062,,11.872343909,,15.934434156,,16.10475109,,10.309345122,,15.263174863,,15.263174863,,8.605,,12.87,,10.973911524,,11.591929972,,14.063049493,,16.03,,7.787940927,,13.569084503,,9.3880203327,,12.465,,14.1,,50200007
18.855772332,15.738598226,14.956945513,12.71775836,12.105793894,11.276839715,10.918266639,7.0284941619,6.4266298887,4.8433800763,12.44997395,13.904880545,8.640765106,6.9540075527,16.266023884,15.877073533,6.5123911064,6.8815836686,20.814312208,19.108917591,5.9073588215,4.0338352368,4.2690692551,3.1394164489,18.508897789,17.630565909,15.171716407,12.767072708,10.429246014,8.5547792971,10.003114586,8.574233596,10.73440312,8.7455431961,11.464403098,9.9244579618,10.574798999,8.7073439686,7.3683719818,6.8009956645,10.660092538,9.0231024258,14.391380171,11.591788171,13.322973364,12.994345376,8.0300381394,7.3864666013,13.981625001,12.189798943,12.650008792,10.702906178,7.9120697161,5.7645796878,10.922855227,9.2749221808,8.562088971,7.6635925153,11.594126576,9.174558889,14.805671411,13.652072661,18.087209471,16.993451741,6.7265588304,4.9239279439,12.367183779,10.303568065,7.8213164128,6.7870129878,11.042957723,9.9844654391,12.29589271,10.948391268,50200008
16.697344048,19.571373449,10.781526833,15.24016558,12.86508811,12.41525272,8.8480158038,8.874336318,6.167764094,6.8341393678,11.682637109,17.465620539,7.6310230055,9.0925950642,11.99081098,12.152193272,7.1261231912,6.4745589121,18.381139339,21.128970113,3.7912093059,5.2430309619,3.4511985196,3.3473043088,15.397994407,13.78323074,14.826548821,17.241689404,10.267281305,11.196915006,10.636213507,10.565106147,10.597127059,10.125678338,11.118284253,12.022715538,9.8566931382,9.8836037283,7.4729479202,8.6973854293,10.112801088,11.095644393,12.941352769,13.870654546,13.797252292,12.825649558,10.230439077,9.6504137609,13.382850397,13.554863485,10.475072979,11.319453078,6.4108441773,8.2352826491,11.747947706,11.877984715,8.8967866913,8.4578963762,9.9049548221,12.786232969,11.267632945,11.440611422,12.071924388,12.130970725,6.3392266276,7.3803238218,10.717930702,12.630756674,6.3783851873,7.718543808,10.6096719,11.225805333,11.718674828,14.626485845,50200010
19.755295245,20.685304251,15.764598521,16.443493748,13.012737658,13.235563977,10.109705361,11.071688235,6.5885853211,7.032890586,13.473113373,17.265473856,8.4364535177,10.411500278,15.292561645,19.211375416,7.4688973302,9.5085259314,17.700687151,20.595682826,5.779307478,7.1496711989,4.769131058,6.2790649659,17.203365717,20.759478756,13.819429406,16.463185584,11.235928894,13.816366418,9.9978586643,11.901915925,12.016793676,14.334378233,11.232883885,11.880897343,11.832720487,14.268946496,7.9627857386,8.9482249464,10.753277793,11.577777605,14.722227352,16.713879382,15.27953556,17.161190869,9.3450047138,10.693173749,13.597751023,14.968022773,13.125001607,14.963604222,8.3396848398,9.7152043407,12.521305873,13.707122233,9.7105276342,11.571798446,11.200522867,11.467234458,13.27720483,15.774823699,14.762667404,16.765717043,5.9604824399,6.6174116857,12.070900326,12.919542693,8.349455404,8.685239533,10.883566564,11.267754995,11.902373758,12.07296055,50200011
18.939294789,16.707669223,12.731804512,10.402941839,13.058030611,12.817491803,10.793725814,7.9729486254,7.7259526577,6.5726741359,12.916541583,13.707853283,9.8276940383,7.4338816204,17.426034174,14.593581763,10.567944782,7.2664103588,19.825849326,20.713371155,5.0673841141,1.9694209448,5.1029484267,3.7455768385,19.973883517,19.168961787,13.379571218,11.01782086,11.819699608,10.163730081,11.377989845,9.938917946,12.762580635,9.7287126609,12.726472503,11.734661292,12.81582231,10.389692558,9.6415937998,8.4483337623,11.907922398,10.154607638,14.853131696,11.86711742,15.397030587,13.995632511,10.207238841,8.4246695541,15.364891254,12.591697567,12.104466662,10.317528948,8.0202545685,5.4900193601,11.607036778,9.8790004878,10.836551689,9.8764047909,10.997206705,10.07177584,15.345778519,14.750023594,16.92671935,15.856484436,8.1828115725,6.6747720834,13.106215031,11.652129768,9.1080394145,8.6481920935,11.834851304,10.979931685,13.442613183,12.42273895,50200012
19.222750145,19.828474786,13.912890105,14.278587028,13.537050829,13.872293371,10.870201135,10.05601278,7.4087631222,7.4218834347,13.355447903,17.01805752,9.0157046315,9.1873285118,16.894759542,17.164682987,10.921863628,9.5682694799,30,30,5.4896855411,5.0268366387,4.7018861985,4.3313390057,17.297785776,19.632782754,12.486332081,14.179334019,10.869915584,11.158692646,10.491837867,10.595569427,11.622758979,11.120273868,12.279443602,12.818100764,12.13612182,11.538129948,8.9063397348,9.7161671321,11.049864378,11.206188205,14.395598036,14.800952084,14.538521718,14.925821737,9.4546362515,9.4327732095,13.838623169,14.120564369,11.892822705,11.693891018,7.5371539534,8.0873872412,10.917240317,11.105958948,9.5182286759,9.2680901441,10.940939996,10.785474614,14.878349772,16.114249565,14.770329354,16.789244327,8.2655751416,8.2622136863,12.681975868,12.974002612,8.8819797797,8.525486468,11.651445178,11.999631886,14.890775023,15.226448028,50200013
18.785078045,19.191646112,13.337589221,15.847414356,12.617016773,13.194466785,9.4492212891,10.538822366,6.7703572793,6.8206121244,12.771785912,14.477647933,8.1175922138,8.6413325844,14.801424027,17.77245558,8.4546126503,7.9936228704,20.045824917,30,4.0472671694,6.195590371,3.7621342298,4.2757630115,18.408400737,20.264820191,10.254401166,11.7244178,9.5543462986,9.8136286019,9.0743269539,9.6064617437,10.105656956,10.823372425,11.829571501,12.422566267,11.006253129,11.772965823,8.3065883016,8.6900702938,10.247971538,10.804055595,13.365060808,14.7727415,13.889520098,14.31358222,8.3125366947,8.8073292726,12.710481363,12.907374181,10.268817934,11.731791089,6.7158958943,7.8088179924,9.8625958825,10.972461382,7.9175139131,8.2814723159,11.294174753,12.495934119,14.625753137,16.63840416,15.532846382,19.128758619,7.3229273747,7.9664244388,11.935111941,12.534773116,8.3764716755,8.6239672033,11.143064163,11.773246151,13.581741805,15.223371238,50200014
16.711135741,,12.9,,12.344958666,,9.1223784098,,6.0412801771,,10.8,,7.3540477455,,13.925043752,,6.3952025215,,30,,3.2798429405,,4.135854379,,17.825,,11.095,,9.83,,9.3587301929,,10.173432359,,11.558317164,,10.443186798,,7.573102837,,10.702342009,,13.384607681,,13.826026234,,8.6405476021,,13.921061337,,13.921061337,,5.87,,10.11,,9.082557163,,11.561317253,,11.974151253,,14.985,,5.663025313,,11.385081584,,8.3313040642,,11.185,,9.235,,50200015
19.225866465,20.507040718,13.472054751,15.63225716,14.113704485,14.373782892,9.4458613733,9.4110888198,6.657244091,7.4992324807,14.801201034,16.867113824,7.6951423186,9.1512083692,11.2351409,13.472796662,4.5810567513,6.6593030634,18.804655628,30,1.0124204974,2.9352875318,3.024666361,4.3740932264,16.624685939,17.726406954,12.099154943,13.936211105,9.8054951409,10.85785078,9.3059975505,10.275724438,9.3373220362,11.527956298,11.937550387,11.92151563,10.005683089,11.088692321,7.4431857328,8.7837417826,10.424804318,11.392924215,13.461547493,14.719183332,14.076833043,16.382832291,8.734363635,9.601779364,12.547967278,14.126264155,9.9401225916,11.45621028,6.2235885479,7.4550481406,10.616307465,11.912895079,8.7198230775,9.695694965,10.260096343,11.133845094,11.42411508,12.70404401,13.83133659,14.748216555,6.1486915063,6.405665947,12.180478443,13.01059082,9.0391608603,9.149694983,11.356103451,11.989307856,11.168255615,13.01932565,50200016
19.85328073,19.342645506,15.554023431,17.277462258,13.204885104,13.203755765,10.130670152,9.3669588595,7.4540947288,6.9813917374,14.57219311,18.594338681,10.05296969,10.218558119,17.090837291,18.439405644,10.304787493,10.515176395,21.323366186,19.738671262,5.883676449,7.3438493158,5.3053238542,5.6773711587,18.813131346,21.064166101,14.234843549,15.100049422,11.717184989,11.800989655,11.32747015,11.420173615,12.95314696,12.94822503,12.296498931,12.734151983,12.090430239,12.421465926,9.3597564111,9.5919227301,11.932569223,11.512711128,15.394995714,15.477941327,15.921286952,16.979546425,10.364199411,10.255229489,16.84248973,15.783080282,12.358164489,13.489105065,8.95484544,9.1714692103,12.468629247,12.318716618,10.247749821,10.842540886,11.687658489,12.428173293,15.093237905,16.221872165,16.91839358,18.825808314,7.5378368998,7.0763939352,13.217813097,13.213652962,8.321171089,8.5434621828,11.934199252,11.893893687,15.426308465,14.97225646,50200017
18.136994293,,12.789745754,,11.930138111,,9.2300526492,,5.7490147676,,13.910644164,,6.7744916522,,11.898871781,,7.2437032469,,18.845765063,,3.3940044466,,2.2547514537,,17.353721008,,11.132623614,,9.5846964574,,8.8232496263,,9.364823009,,12.262500508,,9.4685506256,,7.6748922783,,9.6473325525,,12.522307362,,12.80875671,,6.7558573703,,13.512384493,,9.6322762469,,6.113458166,,8.8255459477,,7.6632907446,,9.1807393136,,13.208449083,,14.784063389,,6.5036927937,,11.232968174,,7.2251787935,,11.598888962,,12.328560685,,50200018
14.658754662,15.233094822,8.9520988534,9.9262656554,10.993328044,11.79060898,6.5359293629,6.5838117348,5.921369385,5.5452938103,15.227737078,17.983398487,6.8597406748,7.1886289572,14.720206905,15.877325007,7.0973177767,6.6621050315,20.230691521,19.979692212,1.8180775479,2.0878022322,2.0848713005,2.4480257657,17.18140756,18.388815873,10.770360042,11.737843483,8.9041791283,9.0072984938,8.7051072686,8.9165907687,8.931597048,9.0572747057,11.720427784,11.337863606,8.5665625086,8.4240907246,7.5206163244,7.8414931339,9.607150026,9.6808115327,12.544102304,13.133462917,13.471582244,13.495634417,7.1198557674,7.4768890301,12.56671932,12.959539073,9.4769339818,10.073312135,5.8038780831,6.1857214659,8.4026784748,8.7681805016,8.0842782531,7.6747319509,10.841952835,10.908906991,12.729797901,13.843692179,13.648814798,15.321811848,5.9989059989,5.9339691933,11.084874683,11.149970159,7.3676421515,6.8955495435,10.353237526,10.349270943,11.73352972,12.855177535,50200020
17.717357749,,13.99,,13.062313539,,9.2175512876,,7.1183666845,,13.3575,,8.4424984613,,16.804394279,,11.271210971,,20.154036493,,6.1332074241,,5.122425677,,21.11,,11.8725,,10.68,,10.494184269,,11.957099042,,12.795095762,,11.735912199,,9.1069183859,,11.170583457,,13.335397621,,14.858410466,,9.2572060763,,14.081273856,,14.081273856,,7.4425,,11.8075,,10.062202231,,10.848172162,,15.587456778,,17.255,,7.8798998745,,12.613844022,,8.6861965557,,11.535,,13.475,,50200021
19.500745827,,13.18,,13.865708176,,10.136213984,,7.5783945112,,14.8775,,9.2645951563,,14.708473681,,8.7164031337,,22.662313629,,5.4337074614,,5.3158803735,,17.405,,13.6175,,11.6475,,11.509021244,,12.212488089,,12.972959282,,11.773755601,,9.5004071693,,11.311636894,,15.440508528,,14.449908308,,10.80336413,,14.691141849,,14.691141849,,8.3725,,12.1475,,9.6014760013,,10.902933871,,13.685383,,15.35,,8.228274775,,13.13927106,,8.4291035204,,11.59,,14.85,,50200024
21.659776766,,15.84,,15.160123606,,11.06057914,,8.7402729596,,15.2025,,10.41771968,,17.258216337,,9.728787205,,22.105922096,,4.6524067689,,5.1579616064,,20.375,,13.795,,12.8575,,12.178050493,,13.311002369,,14.558295245,,12.898501882,,11.283707632,,12.993454818,,15.481400788,,16.133882146,,11.686374717,,15.750973855,,15.750973855,,9.425,,14.365,,10.850410182,,10.884354007,,16.155070205,,17.2875,,9.0529004402,,14.713269176,,10.021322211,,13.415,,13.78,,50200025
17.078807194,16.880020947,12.06513879,11.650020459,13.516459273,11.999797249,9.5804502227,8.5711935043,7.0996056554,6.104074035,12.544485281,13.442801813,7.8214508677,7.9537547656,13.110915217,13.124675791,7.5453652584,6.8069659917,18.706263368,19.48150015,3.1768804314,3.079568456,4.5554966189,3.4807524277,17.193278242,17.93558575,12.893676827,13.796991817,10.487705791,10.513734151,10.498219439,9.9412645539,10.704345943,10.31557865,13.498434273,11.85307234,10.106120459,9.6203594404,8.7636919687,8.4056224985,11.140129958,10.194726503,13.491922745,12.885355305,14.479572441,13.649143537,9.3615683807,9.3930145532,13.648101336,14.464334138,10.324387926,10.428502998,6.6519412244,6.6475021208,11.162518326,11.292188038,9.831430911,8.7707277511,9.3412985347,10.772913999,12.148206595,13.230689593,12.892125029,14.161055942,7.1799965368,6.8919424888,12.118493595,11.122590799,9.143602226,7.7008959083,11.18641489,10.382529226,13.506009,12.138267733,50200026
18.164295375,21.510149548,12.5410709,15.212919445,11.944681046,13.572538746,7.1452271468,8.0517989681,5.6763414084,6.643527512,17.339364714,18.531556716,6.9660435276,8.4754199711,13.055747535,12.75735004,7.2208397529,7.9763686957,17.066907035,18.523923859,2.6072129072,4.6222925704,2.0392807457,3.7203697635,19.944819485,17.114071699,13.182676217,15.228985132,8.3434993592,10.171704586,8.44426059,10.263030232,7.9750923412,9.7805671171,12.193308913,12.940819535,8.17685222,10.0424013,7.4317267692,8.7632799824,9.3029961873,10.911871918,12.958049757,13.538949139,11.655352791,15.055781892,6.6866093044,8.0734566977,12.123946782,13.386695351,8.1626718026,10.674291099,5.8341059964,7.783887466,7.7386784658,9.4824303488,6.782771372,8.8330425765,10.617646633,10.079138671,14.760589505,12.55654886,17.60342983,14.566161243,6.6898812364,7.2323520432,11.694903941,13.041123212,7.918209523,8.8750051013,10.566074565,11.987663415,11.71819786,13.436824505,50200027
17.737182324,16.282340605,13.431286991,13.165972578,13.602781314,12.757051381,10.47024339,9.3127532685,7.6335995574,7.242299327,13.794211246,17.178245913,10.037156372,9.6844061818,14.53486053,16.253483848,10.885133256,10.43337006,22.793382033,21.21969048,6.0256386899,6.2601196306,5.4236955502,4.7509630142,16.942280688,17.721139202,14.275951004,14.744404867,11.826944383,11.172661162,11.845067466,11.570304707,13.153856311,12.470742285,13.293542647,12.821596142,11.901723807,11.558910464,10.120153503,9.4985775492,12.325485245,11.54198526,14.964670614,13.770758472,16.407027566,15.699236163,11.372355381,11.084991998,15.928916823,15.391830432,12.95337804,13.283815599,8.7074157215,8.2522234097,14.081788521,13.687423047,10.99448467,10.725838968,11.134684627,11.47930097,13.365294189,14.814666888,13.660594795,14.849397071,8.2586303075,7.8954930987,13.212982773,12.474362366,9.1750927325,8.651508535,11.880202568,11.117232353,14.71533287,13.876053295,50200028
21.681419327,,16.71,,13.531142952,,13.539758398,,8.4049069687,,13.18,,11.674061371,,17.865987701,,10.430380176,,30,,8.8100236366,,6.8754311542,,21.4575,,16.3475,,13.1875,,13.335008031,,14.709733361,,13.630858695,,14.499395835,,9.7753013869,,13.178626911,,17.044619474,,17.459498107,,12.191512766,,17.357399186,,17.357399186,,10.63,,14.835,,12.106412099,,12.245180639,,15.066936115,,19.9375,,8.6408092102,,14.367079524,,9.6043375015,,12.765,,13.105,,50200029
18.882516841,,14.46,,14.304662434,,10.403186726,,7.5000545619,,14.3425,,9.3546214391,,16.037577583,,9.8711988644,,21.190341823,,5.6711923228,,5.1448324512,,19.975,,13.485,,11.805,,11.365050648,,12.763046729,,14.268278363,,12.696093948,,9.6555792998,,11.379351808,,15.051780224,,15.754431083,,10.138010448,,15.151456947,,15.151456947,,8.385,,13.185,,9.7349628221,,11.401244206,,15.394131222,,17.1575,,8.4276944344,,13.486570573,,9.5072090944,,12.435,,15.5025,,50200030
20.715048885,19.094797115,12.237158525,13.691838707,13.111608203,11.807167621,11.125844554,8.301684269,7.6117760661,5.172302554,13.390010867,18.317837386,9.1397392682,5.4692755292,13.982924623,11.489413533,8.82692867,4.191676601,21.040891556,19.534538177,4.5462616078,1.7737600272,3.9850713444,1.651539585,17.170302806,14.219113843,13.361251764,14.583943254,10.965687294,8.1754851155,11.246534045,7.7684763296,11.76085093,7.5688928224,13.207103113,10.972406566,11.709984538,7.6963454899,9.3958548634,6.6800171216,11.168855003,9.4045507483,14.258020129,11.990224386,13.808732054,10.743822353,9.8387073672,7.3219300184,15.402124909,11.146496327,10.958374709,8.7784639251,7.5299803146,5.3342151126,11.927523479,9.0859660569,9.0867130368,6.3379309261,11.544624854,10.757991004,13.280957484,10.292309843,14.422970149,11.490795641,8.7217205378,6.4168043287,12.977598931,11.677022714,8.8260019238,8.029934767,11.540167912,10.689735076,15.167941103,12.066463033,50200031
19.445229721,25,13.25036929,19.288385697,13.52722038,15.049593554,10.535134241,13.863555555,7.3926838676,8.3401301415,12.668353846,16.537100032,9.5285795257,13.293222443,15.939713722,17.107087031,9.9503368113,7.7585994424,21.215240248,30,5.4939099234,7.6303652829,5.1285829004,7.110906002,17.879625726,20.485731987,12.145293685,14.422330828,11.51935481,12.941184366,11.56504188,14.541961001,13.068481519,13.371179775,13.25492417,14.084829636,12.385925107,18.774641325,9.7845013029,10.958923781,11.575440468,13.565361998,14.819579676,18.756156573,14.670440976,20.91121881,10.351779325,12.203507378,15.002331807,18.256495986,12.484207691,17.816917264,8.029270223,11.463942463,12.749891235,16.138789609,10.339626265,13.479599345,10.320911633,12.396125581,14.277742845,16.744495769,15.490063406,22.244707118,8.4399782145,8.6879360736,12.988669501,14.92824935,8.787789168,11.10117346,11.740054461,12.892868981,13.746683368,16.01906916,50200033
19.285009162,18.893729,11.892019624,17.370307692,12.027526582,13.068318433,9.6785030705,10.758672581,6.4850244479,6.4537626914,11.143596521,11.983062318,8.4495629735,8.2392870386,16.005227965,15.90391935,9.6425500353,7.307424136,30,21.285804446,5.3779445641,6.5902884832,3.9946354509,4.0224863604,19.465534152,19.19442967,12.738106763,16.023386049,10.15963635,10.461894769,10.446232441,10.049814012,11.166562425,10.448934162,11.117491305,11.732542336,10.938966177,11.019171016,7.9199700274,8.242188034,10.778617465,10.724986575,13.73469937,14.758658333,15.147817003,14.002692729,9.6156412285,8.7354320332,14.206843864,12.99800446,11.932316414,12.037619603,6.9114393045,7.8080935947,11.997003732,11.421232086,9.0605475272,7.9321463597,10.545317398,12.070190909,14.296083154,15.190253251,15.190443878,17.53751875,7.0126293456,7.5449425368,11.554452975,12.758990856,6.4564478613,8.190895219,11.898624467,11.659861982,11.133354783,14.47092409,50200034
19.827336923,19.981367063,16.555985917,16.371867332,14.150027644,13.004592351,10.128117477,8.1516725473,7.2821876657,6.5621085168,13.788826238,16.258163116,8.7595895844,8.7754824642,13.836478572,17.021470375,8.8707839074,9.5884549624,21.187723255,21.179325594,5.9908779281,7.2868273324,4.840843828,4.8360346199,16.144369868,18.141159244,13.551607556,14.765980867,11.354801379,11.081616768,10.945153386,11.115795144,11.557861818,11.170334311,13.187010355,12.28685895,11.481064288,10.423553493,9.461094912,9.2059599803,11.465794383,10.905837643,14.967594341,14.059101213,14.597007588,15.131488126,9.4313202742,9.4552552816,13.691720853,13.176599038,11.645988664,12.592511184,8.0279680784,8.007601849,11.129416942,11.845790562,9.3655070717,9.3372330783,10.074092144,9.9731814787,12.233367379,14.305566209,13.206827187,15.520691594,7.8652051319,7.1132215408,13.226837817,11.8837551,8.9711302263,7.860778376,12.061964918,11.094682365,14.759167905,14.177227378,50200035
20.170800739,,15.23,,13.803451951,,10.70445817,,7.4056886701,,12.995,,9.9850805695,,18.571848131,,11.012384721,,22.406154635,,8.9103477322,,6.6339640503,,20.625,,15.2575,,12.6775,,11.744801651,,13.515601837,,13.262337846,,12.75744313,,9.5486929417,,12.339884933,,15.461813489,,16.209144231,,10.740376885,,17.181988848,,17.181988848,,9.1725,,13.2025,,11.20763751,,12.153562588,,17.078871565,,18.7525,,7.6548469581,,12.616402564,,8.4114174392,,11.6925,,14.615,,50200036
16.822593408,17.713984791,11.755616056,15.720120961,12.517272146,13.840701609,8.6320471813,10.258789181,6.6590000048,6.4965651617,12.490408663,15.65174523,8.0688391695,9.0533210125,12.126179332,14.853173656,9.8513049827,6.6259594632,20.123842199,20.049817574,3.0542925446,4.6538086041,3.8143635088,5.4024587797,15.176860498,18.637459903,13.347901796,13.440315018,10.423868198,11.520408729,10.283587064,10.88119557,10.832247221,11.723490049,11.696616289,12.47148986,9.61144953,12.502520635,8.3695224472,8.007118805,10.597695085,10.373289415,12.278091706,14.951407448,14.184392088,16.584606593,10.306239449,9.4555309569,14.218707752,15.104112415,11.663638108,13.747042639,6.6428218464,8.1603187079,12.029058267,12.649503094,9.7184654551,10.300435462,10.85208449,10.939321071,11.721412996,13.380406902,12.575517904,16.490432199,6.9827090753,5.8386162037,11.478845861,12.467761243,7.6540203278,9.060223072,10.50572869,11.660583654,12.695594185,11.075794338,50200037
18.983182871,19.839433893,13.887689558,15.734024666,13.324089148,13.454173774,9.0098622332,8.9301930143,6.8348480375,6.9956483193,10.139573879,18.011846162,8.0048476064,8.9960126175,13.603191951,13.47865957,9.0663584495,7.318330654,20.591955894,21.315730535,3.1481840846,3.5068675902,3.0356064092,2.586115021,14.497716945,17.614217195,12.379238148,15.113844874,10.373482326,10.552157361,10.085265766,10.055269783,10.102031675,9.9206818245,11.40352798,11.988843634,9.6117943971,10.090894479,8.7367978234,9.0280097822,10.78049967,10.501072933,12.053662466,13.423869684,14.827945148,14.266675116,8.9629428053,8.6843779939,13.600759576,13.190373617,10.824911744,11.061140737,6.3358757451,7.5139454831,11.204339888,10.979387076,8.700194741,7.9793570231,11.628021218,12.771732381,10.687139264,13.638747666,10.764019703,15.663502762,7.1653597531,7.5433235494,11.967741549,12.646138263,8.0198292753,8.1602702795,11.284150184,11.887918794,13.200298325,14.476547795,50200038
17.610293325,30,14.053586549,16.56521897,12.423284241,13.20131678,7.9742661781,9.9359305861,4.8169491174,6.8519911017,13.50634918,16.741272888,5.881896596,8.6862860306,12.482166843,14.968301848,6.6225254865,6.9760054109,17.247368859,21.022269391,4.1704119569,6.3571841178,2.6990152243,4.3377066525,14.646098635,19.702552869,11.93142914,15.636805357,8.8339662535,11.710159513,8.2283142428,10.627966137,8.9595806149,11.390515031,10.19688602,11.957758867,8.881754212,10.645934021,6.2875609896,8.8010135233,9.5283890215,11.15460614,12.557214875,14.652020132,13.546033319,14.335715647,6.8757631514,9.8996205055,11.233796017,14.271760836,10.302146286,12.894110583,5.5027168226,8.4130608172,9.3404304956,12.01090063,7.1431948997,9.5170821018,9.9912763124,12.8927325,10.596836644,15.072044213,11.116708797,16.975148867,5.6363122534,7.4758396295,10.583584603,12.69706727,6.8034339273,8.4714416298,11.003415668,11.2574779,10.772993797,13.968425938,50200039
18.464420374,20.375665712,14.710102315,18.340264665,12.241749545,14.123738085,9.1856227063,11.615978838,5.9297083223,6.6669331008,13.743847186,12.413690679,7.5655020604,9.7203625903,14.221882733,17.906064114,6.394839046,7.6227844889,20.243670435,30,5.0870850974,7.059686018,3.8699988278,5.5403797741,16.430197865,20.588760113,13.278535607,14.555557468,9.9609532654,11.932569657,9.6192193364,11.078889998,10.118871089,13.027989337,11.724045172,12.344545627,10.442068594,14.143081405,7.9041492935,8.5667535945,10.440604528,11.293961745,13.485569164,16.477407395,15.41168334,17.856594805,8.4827418841,9.6427961872,12.714356193,14.860512925,12.192219016,13.750364491,7.2302424597,8.9959161785,10.910387412,12.389906652,8.9752948857,10.769257882,10.681261689,12.17141499,12.251546792,15.48160807,13.256024885,18.263900712,6.4620606519,6.9569434626,12.011788717,13.435303798,8.4853873533,9.7011126273,11.307593231,12.506277906,12.501356413,14.067203763,50200041
18.994328965,18.100557531,11.53,13.63,11.396412497,11.131253807,5.5905043418,6.5789983231,5.1283069974,5.2009281853,13.5475,16.15,6.4569610018,7.1510113618,11.076651739,11.062246423,6.055029534,4.0680526989,18.343207893,19.409475849,1.8444769375,3.1253666109,1.7500519926,2.679051588,15.09,16.235,13.0975,12.69,7.705,9.9375,8.2329783361,9.0161182452,7.5435450013,9.5907635073,9.3519066829,9.9576624505,7.6019961221,8.9924186427,6.2057469152,6.4208749544,8.591002262,8.9739888063,12.088960944,12.790611193,11.87996364,13.489172247,6.6466304275,7.6141959137,10.287443859,12.317315637,10.287443859,12.317315637,5.1375,6.755,9.4225,10.33,6.4940617637,8.3237941036,9.1944479978,9.9716544464,10.713106735,11.575896496,11.7725,14.38,5.5406586942,4.6368248562,10.35309231,11.075075816,5.8561093145,6.5158917091,10.2875,10.285,12.5875,11.545,50200044
19.588201522,19.054806128,13.18,13.73,12.425532073,12.669357442,8.2033890265,8.6262345683,5.5076495179,6.4785888488,15.445,15.26,7.3487153677,9.2264346732,16.759582367,20.411796123,6.4852842087,9.9892872758,18.843281524,21.168552076,3.8380382046,6.0369221091,3.2028917265,4.5527694238,21.0225,19.4375,14.5925,12.855,9.13,10.175,9.0195929458,10.686321587,9.6036757479,11.48929109,10.88587199,11.802865753,10.082109335,10.907157439,6.6168395913,8.742841148,9.7624090351,10.629302278,14.288215344,13.636685367,13.942700541,14.58001479,7.3471706109,9.504713832,12.355049206,13.835637917,12.355049206,13.835637917,6.2275,7.6675,8.955,11.0525,7.9319803351,9.3638451959,10.187580094,11.300058351,14.07266859,15.805483826,17.225,18.7625,5.9191807986,7.4004541271,11.520958947,12.130926878,6.8723231894,7.5584918442,11.05,10.6875,12.1925,14.11,50200045
19.571331797,,14.76,,13.69714086,,11.059783357,,7.9514699118,,13.8125,,9.4685638185,,15.298644887,,9.9347348747,,20.794774818,,5.6397711555,,5.0531118143,,17.495,,15.98,,11.3075,,10.650997206,,12.039092271,,12.195571388,,12.300047216,,8.9827836918,,11.048211827,,15.651641157,,15.654381262,,10.006628123,,14.472774604,,14.472774604,,8.3425,,11.2075,,9.8652908456,,11.797058043,,14.581176352,,16.4325,,7.6192526032,,12.811772789,,8.7156145831,,11.6675,,15.1225,,50200048
18.831500927,,13.46,,12.035135831,,9.9273706672,,7.2630548636,,11.605,,8.7370949656,,15.303174813,,11.257681955,,21.813610403,,6.349776556,,4.9522308678,,18.08,,13.2725,,11.43,,10.710493833,,12.058167645,,12.560706574,,11.50974659,,9.0076932789,,11.421807034,,14.056136889,,15.372920046,,9.7414373941,,14.84712404,,14.84712404,,8.175,,12.595,,10.546925983,,11.628943591,,14.315063504,,15.065,,8.0205811013,,12.377096444,,8.6483712199,,11.4325,,13.16,,50200049
21.10932761,,15.3,,14.380250779,,12.01371389,,8.1278095721,,13.4125,,9.9801270455,,14.408736115,,9.1564671886,,21.299527392,,5.8807271861,,5.8296327693,,19.2075,,15.3775,,12.4325,,12.055232301,,13.247180126,,13.669770489,,13.442058452,,9.32317197,,12.206584778,,16.074405028,,16.118517761,,10.774785148,,15.994145534,,15.994145534,,9.0575,,12.125,,10.877413653,,11.323667661,,14.538762304,,16.8525,,8.1716592581,,13.968178575,,9.6571468793,,12.4,,13.59,,50200051
21.294725568,20.264466875,13.65,14.1,13.283823116,12.357567723,10.579935033,6.9470595827,7.8960354788,5.7597462317,13.535,20.36,9.7006111955,7.5684065805,16.97301887,13.127243735,9.3971082327,5.9325403068,20.536847965,19.910987828,4.2639848728,2.0411330906,3.721601843,2.1190018552,19.76,18.545,13.6175,14.7225,10.435,8.95,10.257878376,11.669624652,11.327346386,8.3030801932,13.070403076,12.089139759,11.804993263,8.3460338793,9.117391265,7.6904593918,10.982772485,9.8104274938,14.607529603,12.629146504,14.012032308,12.655964143,9.4022904556,7.5442910862,15.475155687,15.865298125,15.475155687,15.865298125,7.6675,6.295,12.175,9.2675,8.6432270408,7.0529790907,12.003752004,10.4375792,16.090039832,14.496774742,19.2,17.465,8.5688898699,6.9661440184,13.051933189,12.150025627,8.6068413205,7.9361737949,11.6525,11.055,12.4625,13.96,50200052
20.543406251,22.464307251,15.79,20.06,13.748671441,13.952066985,11.225577751,12.652303367,7.66760084,7.8185428891,14.9,15.2075,10.054307299,11.879448875,17.733464279,18.913311539,10.471980129,9.6929276694,30,20.58796241,6.3509230948,8.2847102737,5.3371668658,6.471819111,20.15,20.8575,13.335,13.7175,11.44,12.9875,10.922320338,12.38950626,12.296125873,13.836304498,12.402472507,12.765577279,12.323327228,14.602667451,8.9017342376,9.2430765926,12.161054503,12.933088029,15.841709193,18.162641322,16.307584801,18.820557503,10.313212329,10.948029886,14.354132029,16.502370331,14.354132029,16.502370331,8.9225,10.71,12.1475,14.075,9.925214626,11.920776226,12.382624614,12.731994088,15.282451116,15.79850354,17.8625,19.8675,7.7145855105,7.8218721338,13.496050041,14.167986147,8.8449079008,9.7023711107,12.0325,12.51,14.7025,13.325,50200053
19.985107169,30,14.99,19.88,14.999452584,17.240534575,11.518635804,14.340899581,8.1483685503,9.8744416212,14.8675,19.6675,10.292014944,13.62920422,14.728263972,18.944825106,8.5985491108,9.3020364775,21.399417289,30,5.0016784581,8.1630626231,5.9321572818,7.7373498386,18.11,22.155,12.9175,15.635,12.095,12.4775,12.003770945,14.15291019,13.397398303,12.710232045,13.174208935,15.06813591,13.057656764,18.577843616,9.9045750897,11.467817832,11.934967339,13.741992498,16.71712942,30,16.530045314,19.540861891,11.159204114,12.163006087,14.227346425,16.31085935,14.227346425,16.31085935,8.96,11.1025,13.595,16.17,11.754911795,13.064752125,11.855926697,13.512481915,13.873189329,17.730079192,15.71,21.21,7.916823093,9.7951742802,13.420546911,16.543846439,9.8795570911,11.77565826,12.1025,12.4675,14.3825,14.7075,50200054
20.261510846,21.667203383,13.31,18.83,14.210899959,14.397260645,10.624199276,12.345872752,7.8456840779,7.8522223837,12.415,18,8.8484299406,11.980792484,15.639022811,20.005661191,9.4270053511,10.427553028,21.180876801,20.228708646,4.5067928514,7.803394064,5.4272818514,6.4693319604,17.91,19.74,12.89,15.3775,11.855,14.955,11.0304474,13.920380615,12.424494419,15.252050852,13.122339585,13.4319491,11.890729124,15.740300964,9.3538973336,9.9331129586,11.640638195,12.998694393,14.315901285,18.734215858,14.890809847,18.879863565,10.059041073,11.699937855,14.716155058,18.961625204,14.716155058,18.961625204,7.8225,11.2725,12.3625,14.625,10.527564115,12.952755859,10.188510159,12.820566579,13.302828269,16.144638331,14.695,18.73,7.6265336801,8.1214711583,13.260659672,14.171943164,9.6972988547,9.6299828989,11.8575,12.4325,14.406666667,14.5125,50200059
19.655937506,19.589209336,16.43,15.62,14.454150663,14.795392273,11.682439624,11.383537906,8.1132138869,8.7461920781,14.185,16.49,11.018134477,10.537679325,17.205811743,16.241556434,7.8658100176,8.7195412345,22.38002528,30,6.6395570026,4.4328283431,5.4482970022,6.2325156646,20.465,21.68,14.3,12.915,12.42,12.3625,12.261687111,11.996745996,13.735977382,13.65052574,14.130985019,14.458421157,13.820256736,13.7697699,9.8619088802,10.088486146,12.644629038,12.231528118,15.879774708,15.776043731,16.883182208,17.096672335,10.946525053,11.591404656,16.132237225,14.441373823,16.132237225,14.441373823,10.0025,8.4925,14.6225,13.9425,11.346365074,12.160725587,11.967021714,10.794411901,15.716962028,15.448255361,18.393333333,17.5675,8.6738394281,8.1465703855,14.231819018,14.201736933,10.048817014,10.919183878,12.695,12.7575,14.045,14.985,50200062
30,21.898950597,13.21,14.9,13.047481576,13.129270072,10.835196706,9.006410301,7.3993705966,7.1303827762,14.085,16.7375,9.1479620125,8.7273980448,13.61506978,10.564218069,8.513892589,5.5266446226,19.905657996,20.149371144,5.2371127543,2.5821752958,5.0882049982,3.3578625112,18.045,17.07,14.405,14.9025,11.5575,11.215,11.966180627,11.213792803,11.572489248,9.6844755814,14.14485245,13.633776616,11.528715377,9.548378045,9.540964489,9.5696621326,11.621623745,11.326790434,14.797383602,13.683113184,14.564197097,13.433165624,9.8254299066,9.5938893409,14.386585081,12.594893045,14.386585081,12.594893045,8.115,7.53,11.47,11.6,9.7775238088,9.035523504,10.86635672,8.812071426,13.114116682,12.025203005,14.9675,14.0475,8.3566917678,7.5739979712,13.321978579,13.24084251,9.3386794603,9.5153222152,11.965,12.04,10.9675,12.8575,50200066
22.607090487,,14.46,,13.907300684,,11.114669491,,8.3410744712,,13.0125,,10.247560644,,17.200351343,,11.311638054,,30,,5.3566081871,,4.7317124039,,18.675,,13.7675,,11.545,,11.568853028,,12.146868398,,13.087851877,,11.886794877,,9.8976926462,,11.961862408,,14.478959517,,15.812147184,,10.650027484,,15.13689164,,15.13689164,,8.695,,12.26,,10.033298129,,12.019878377,,15.694822104,,16.5825,,9.0860669583,,13.566666231,,9.466195208,,12.2225,,14.15,,50200067
19.338890332,30,16.4,30,14.594294804,15.315778505,11.643470555,13.407787312,7.7112540338,7.8552081914,14.41,30,8.887241283,11.989567954,14.322348514,14.383596994,7.1283892224,4.3440237437,17.57481214,17.648628377,4.1464554554,5.9667941158,4.8770644108,4.9326491694,17.3125,19.815,13.275,16.0475,10.75,11.625,10.744963036,12.670382606,11.971776746,11.750245724,13.655366184,14.831148075,12.650363187,15.924836768,8.917274268,8.6545263686,11.261722198,12.709035281,15.397495884,20.784025015,15.034312656,19.221135233,9.8310732977,10.567056648,14.576353747,15.788625156,14.576353747,15.788625156,7.7225,10.8175,11.29,14.3175,9.8537998434,11.670483031,10.874710649,12.265370509,12.920257545,13.817712655,14.755,19,7.3686609498,7.9187379602,14.156296667,15.94099599,10.749025273,10.595111217,12.5075,11.6025,13.12,13.5,50200068
20.92950679,,15.94,,13.754871102,,11.232663255,,,,12.485,,9.695667081,,15.775529394,,8.5041868514,,30,,,,,,,,,,11.7875,,11.458542677,,11.817786308,,12.881158512,,11.819190505,,9.1474660044,,,,15.612276305,,14.45905608,,9.8385373424,,14.695676932,,14.695676932,,,,12.04,,9.9568850973,,,,,,15.2175,,,,,,,,,,13.2275,,50200069
20.847609736,21.178465087,19.55,20.83,14.764613668,15.252633758,13.115750259,13.05088781,8.4822293675,8.8052193355,16.455,20.62,10.999930732,12.164738058,16.654938583,17.548902785,7.7878508114,8.5282689065,21.614122592,30,8.4348966725,8.1802536513,6.4542268638,6.9511307823,17.7475,19.695,16.0875,15.285,12.9425,13.1225,12.253888016,12.963701488,13.574082811,13.677859344,13.111913298,13.865008613,14.185600795,15.232683727,10.098083801,10.750608945,13.250785013,13.312414951,17.045773512,18.791431283,17.787396124,18.70941654,11.484469348,11.704970744,16.120422504,16.990319286,16.120422504,16.990319286,10.885,11.33,14.6725,14.995,11.936553635,12.55981895,12.974054706,12.553836295,14.431436902,15.925974939,16.9075,19.0275,8.7089007569,9.1381321502,14.807858052,14.924148145,10.111719348,10.596129739,12.7375,12.8375,14.5125,14.9375,50200070
17.642290128,21.279675533,15.87,17.91,15.112012888,14.204159843,11.574020184,11.877852187,8.2366647115,7.2094496843,13.875,17.3925,10.00558423,11.671364253,13.194810259,13.975997089,6.2467778207,6.2434306375,30,30,3.2461970099,5.4196998371,5.4328867578,4.9400390848,18.6075,16.6875,8.875,14.9175,11.8625,13.515,12.064323221,11.680713254,12.105037738,14.513971606,13.859975685,12.902113309,12.803680319,14.624936989,9.1674650333,8.8900775661,11.718552668,11.347522579,15.514930423,17.790875929,17.243744997,19.063068838,10.925168467,10.777369414,14.865849929,16.462627324,14.865849929,16.462627324,8.18,9.58,13.6425,13.6675,11.536522954,11.254482446,11.679646889,12.885240011,12.017959664,11.527663846,15.4125,14.956666667,7.9117730066,7.1122799878,14.127007199,13.77150064,10.296372268,9.526786613,12.685,12.575,10.6775,13.715,50200071
21.167358699,18.247078046,21.1,17.55,15.189095289,13.280388753,13.96597296,11.459133377,9.2863798853,7.6965636653,13.875,12.385,12.677109195,9.9174316679,18.746956394,17.615518033,10.893364115,9.9796966749,30,30,9.5603388471,8.3320068239,7.6592362625,5.8438611003,20.3925,20.585,14.4625,13.4125,14.0125,11.885,13.449232071,11.578005016,14.766036841,13.636659229,13.607638193,12.878683549,15.938884918,13.017914374,10.585212038,9.4781871353,13.938965172,12.08348357,18.495567479,15.704333324,18.944904709,15.925678081,12.940101828,10.603605241,17.36775424,15.907315805,17.36775424,15.907315805,11.605,9.24,16.0475,13.3775,13.508690963,10.558899258,13.239509185,12.470531573,15.932785257,16.117811236,19.395,17.82,9.4505522575,8.4010738589,15.532052136,13.005281173,10.739768317,8.7798573752,13.5525,11.925,14.57,13.9275,50200073
19.229459483,18.16554157,15.509399426,14.19142513,13.959098506,13.607489291,10.365889847,9.9606226323,6.8831007504,7.3564051558,17.930869281,18.309729415,9.658841831,10.210328117,13.669807093,16.793059597,8.5607735219,9.9851772318,,,6.7727461873,6.9074565919,4.1688449514,4.8246493455,16.807363002,18.302321871,13.733351255,14.599700706,9.4783434848,10.409607983,9.7768658893,10.914961367,12.420621804,13.625025593,12.110034722,12.759478695,12.064850145,12.767808363,8.4572429957,9.2567882817,11.158953023,11.317196163,15.582926334,15.029207016,14.03982028,15.35435296,10.157639452,10.898021028,13.553426307,13.581556517,12.369646466,13.071433334,9.3214959173,9.4879846713,12.257780213,12.722849747,,,,,14.097189824,15.58959847,17.872850847,18.50085258,,,,,,,,,14.68140813,14.700470017,50200074
20.039228855,30,14.01,30,13.089697482,12.5294627,10.942923058,8.4836173482,7.7858328802,4.9498484843,10.5,10.6125,9.4259625793,6.4265474657,14.687637589,12.089335991,10.658519711,3.3595033966,20.59294456,30,6.2025932249,0.3124621153,5.0982362076,1.319428002,18.59,18.243333333,13.62,11.283333333,10.4825,7.8875,10.7934969,7.3631844884,11.586204852,7.8242144302,12.716274256,8.4331580134,11.484224054,10.452428785,9.0322202402,4.0767333285,11.054437088,7.0435413611,14.186735549,13.282804333,14.41153719,11.715696882,9.703011828,5.2516930867,14.832528637,10.484837152,14.832528637,10.484837152,7.4425,4.9433333333,11.04,6.2275,9.3850667282,5.6485715083,11.417164558,11.507077955,14.908098079,11.348337285,14.655,14.253333333,8.4605328156,3.8666863636,12.717743363,10.256613725,8.6009572359,6.5959943262,11.5925,9.1166666667,12.9875,9.7625,50200075
19.842586772,,16.42,,15.483084988,,11.66780352,,8.1104083511,,14.5475,,9.7431137146,,13.539227824,,8.9797064822,,19.679112101,,4.2183592828,,4.7473141819,,17.7475,,13.8075,,11.66,,11.312404576,,11.832788002,,14.149326096,,11.572129763,,10.530788386,,12.327265378,,15.109965707,,14.970737763,,10.72279783,,14.733981697,,14.733981697,,8.4,,12.3375,,9.8819020591,,10.126570875,,13.002891113,,14.4875,,8.6778508579,,14.543875796,,10.082897529,,13,,16.8825,,50200076
17.813348014,,12.23,,12.71138804,,8.3907481638,,7.1711218404,,13.1075,,8.0599874194,,11.263167256,,7.991487406,,20.142210219,,2.8857900426,,3.0873988484,,15.6325,,10.52,,9.7325,,9.5905381309,,9.546117561,,12.217571862,,9.6163445672,,8.5918590971,,10.690887212,,12.433474385,,13.933314833,,8.1581795165,,12.935781156,,12.935781156,,6.09,,9.6325,,8.5770175812,,10.703657586,,11.97617432,,12.15,,7.973895319,,12.391068404,,9.134604509,,11.48,,11.9125,,50200079
20.213453863,22.46593286,15.47428091,18.417689258,14.983854715,15.265791853,11.838822443,11.518373943,7.9720692071,7.9384777234,17.002551886,19.128311788,10.928469973,12.055391987,16.311162015,16.120015372,9.959130449,8.7400518764,,,7.6003997033,9.0012113022,5.6767608189,5.7734118899,18.250451246,18.540937601,12.94040861,17.252956355,11.595261594,13.506975135,11.21906893,12.089826101,14.697563474,14.610487592,13.274278336,12.604942846,13.766730589,14.676122447,9.48285287,8.7017047837,12.481890233,12.604732203,17.572811532,18.541161441,16.632713503,19.553808323,11.139398673,10.991915323,14.680293047,15.51425586,14.756279349,17.172807301,9.9629682323,10.50836702,13.009920637,13.650851153,,,,,15.291740046,14.271481655,18.59006534,19.310507307,,,,,,,,,14.973027537,15.926026383,50200080
18.468429573,22.225418187,16.198541967,18.794689986,13.69647311,14.603057064,8.5943904587,10.703646067,6.2726688456,6.7155576712,18.201426711,18.781887094,8.2864693097,11.650309447,13.233807565,18.797312255,5.7174593251,7.7054705285,,,3.787768705,8.2900630735,2.3662460136,4.936171716,15.245340503,17.621016045,13.470206398,13.298179551,8.0062283589,12.335928601,8.0744149993,11.335604443,9.6349153877,13.905349673,10.223907584,12.049018566,10.375149171,13.97921426,6.8181091047,8.3526599517,10.3002976,11.646604173,14.69265273,18.065601389,11.395427723,18.41128204,7.6931390604,10.578428557,9.7947456873,14.05092221,11.168588505,16.954661991,7.5760413003,10.360727587,10.29175662,14.476489263,,,,,12.434501749,15.04025145,14.70417027,18.550955397,,,,,,,,,13.62163888,14.353511077,50200081
21.656236497,18.368924743,16.084975614,14.230364015,14.593033753,14.039770852,10.98959371,9.0362248203,7.4834844392,6.7839601647,18.658052053,16.857254514,10.803732773,9.2888141987,15.762686982,19.130793566,8.6367678993,11.332529336,,,6.7932843041,7.3993002389,4.9623395143,5.3135471294,16.600220552,20.56772898,12.942491796,12.592434927,12.263298049,10.568934507,11.3985049,10.899604862,14.311736599,13.003865407,13.295819749,11.777014335,13.381068879,11.872649004,8.9378250223,8.357492325,12.147508633,11.27134821,16.689748198,15.050308382,17.380122927,15.580144543,10.596138577,9.9718409941,14.656650647,13.950799497,15.162282438,13.200702335,9.9306262303,9.2817543953,14.26639329,12.603755647,,,,,14.963043433,16.882056641,17.519605723,18.180763473,,,,,,,,,14.278694387,14.201783383,50200084
30,,15.82,,13.621728923,,9.0563946669,,6.64563801,,20.69,,9.6181667451,,16.072117905,,7.8889348875,,19.655839312,,4.5786107507,,3.7364461828,,20.54,,15.03,,10.59,,9.9026991019,,10.78549472,,12.225654859,,10.795599231,,8.4598435022,,10.794019695,,15.562026412,,14.608834356,,8.6201301767,,11.487044581,,11.487044581,,7.9975,,10.8125,,9.0307389643,,12.763828977,,15.555752184,,17.8,,6.7835465715,,13.134310316,,8.8447262277,,11.635,,14.6975,,50200085
21.203903723,22.78218858,15.688304671,16.452951462,13.485711806,14.363920287,11.305903993,10.23898695,6.8513407788,7.1188840554,14.982994652,19.785567564,9.2838417297,10.289221603,13.580600716,15.438766434,7.7242235878,8.0537267785,,,6.9856766805,7.4090340309,4.7500338275,4.4000085166,16.279778293,21.244300888,14.671540961,17.629423407,11.284535275,11.405468919,10.575666058,11.069485644,13.517478435,13.132825997,12.067330795,12.469911026,12.529003115,12.114851271,8.4040502053,9.155567437,11.575237903,12.052710833,15.370832815,16.360961763,14.635562647,14.45841545,10.09457234,10.418929603,13.973046667,14.73864216,12.918036334,13.154477492,9.470625426,10.224040797,12.89001676,12.108705277,,,,,13.252445749,16.05579998,17.00371748,23.026379923,,,,,,,,,12.825697073,13.033635197,50200086
19.473112923,20.816099833,16.728592254,16.91452595,12.688467016,13.314025919,8.6944369157,8.7251850447,5.7182158187,5.5743676695,18.099965211,18.015126431,8.43544137,9.0738787013,10.425659881,11.400283542,4.9640922641,6.4383829762,,,3.8239537978,4.8138414343,2.1418136769,2.7920021894,14.069197947,14.055820739,11.907336618,12.451264555,9.1133589836,9.54187285,8.3261508511,9.0260610142,10.863189876,11.683819734,11.802334288,11.085848324,10.282907605,10.930465398,6.8941496967,7.2244159337,10.186757337,10.274715117,14.863455314,15.349849825,13.05940419,14.18009804,7.5209356627,8.1195868226,11.689909457,12.30348187,11.028792241,11.976569818,8.0349426423,8.373095246,9.4743579943,9.3190747507,,,,,10.882834663,11.341990439,13.73662701,14.656597243,,,,,,,,,14.36586789,14.349908723,50200087
19.45568715,19.230743983,14.882376635,16.013028697,12.353091019,13.437190563,11.223303167,10.329089493,6.7411558418,6.7686637175,14.208985508,19.154265374,9.0064035213,9.5294164457,18.008515215,19.246556368,10.037586336,9.9565272332,,,6.5649418511,8.7463062003,4.8374920255,5.1904311938,17.425505136,18.069514302,11.898286103,14.336307833,10.834469419,10.687149594,9.7166278008,10.562798859,13.61516738,13.301991715,11.393253773,11.584187488,12.467481944,12.139016376,7.7247945497,8.5024482663,11.041784243,10.885345767,14.72616164,14.710782489,14.620852547,14.616393737,9.9798965949,10.198955951,13.97322196,14.27567012,13.182049997,13.532541188,8.5301465367,9.2986405377,12.765347703,12.983438637,,,,,14.909187618,15.968213927,17.291652563,18.64650672,,,,,,,,,13.659419213,14.48386785,50200088
20.074158116,,17.124189001,,14.204346162,,11.403786559,,7.2332754535,,17.788456197,,9.8306858835,,17.63928895,,7.927158076,,19.234920711,,5.237930479,,5.1933708116,,20.587579742,,11.473353921,,12.267762933,,11.221882508,,12.766830479,,12.715846868,,13.290825374,,8.7992928637,,11.325057628,,17.152539863,,18.179610576,,9.1265756973,,13.959176243,,13.934648975,,9.12573097,,11.86957275,,10.668008502,,12.313627739,,15.758606031,,17.734522211,,7.2916147651,,13.638531832,,9.7666648163,,12.449422962,,12.84380881,,50200089
21.305460963,30,16.027331513,18.694102544,14.87200205,16.386722478,10.298854607,13.71082147,7.2529160489,8.8947183403,18.771299401,22.393521254,9.8369679453,13.377746183,14.538453904,20.028853874,9.4105387911,9.787290376,,,5.7014082242,8.5644520436,4.3909592043,6.701501767,14.845743723,21.880043197,13.239389324,14.339000699,10.383906058,14.849222274,9.9487171324,12.101036158,13.005886414,16.451154499,12.322151146,15.093640634,12.512545893,15.592747104,8.8928137247,10.715494103,11.592396377,13.543290267,15.645864993,19.667755347,14.801427317,20.43038027,10.221382266,11.499492492,12.819419303,16.747437217,13.240828834,18.660258936,9.255166612,11.828060857,12.204997873,15.71966244,,,,,13.118743246,17.490822734,15.123544717,23.479435533,,,,,,,,,15.548794493,15.52789286,50200090
19.10066503,,15.252906659,,13.387686947,,10.663281603,,6.6376975827,,15.342768256,,9.457883128,,11.702211218,,7.4079505714,,,,5.0576239608,,3.6736663416,,12.906880595,,12.331594048,,9.8731892696,,9.690723766,,12.25078298,,11.668756767,,11.987101176,,7.912547189,,11.057967723,,15.566777274,,14.24822722,,8.6291449037,,13.349741987,,12.148822803,,8.7550849817,,11.29463014,,,,,,11.113211345,,13.721792257,,,,,,,,,,14.217558213,,50200091
19.746977017,30,16.953662205,19.274987685,14.337825048,30,10.40656665,15.561151777,7.4423326243,10.736625349,14.944369396,30,10.130959627,14.825786953,17.291016505,30,11.023999341,14.185953189,,,6.2016400394,10.840740788,4.4560861821,9.2893521906,19.13066297,30,11.945545943,16.517244163,10.626228546,12.269889998,10.158741036,17.602197401,12.704092876,11.969703633,11.408304826,30,12.687305357,30,8.4058330013,12.97316038,11.33985536,17.30949928,16.850284787,30,16.838846453,30,9.0480640969,30,13.542475203,30,14.394100403,30,9.3482577087,12.99083123,10.67259347,16.908304355,,,,,15.057540068,18.265875155,20.065214063,30,,,,,,,,,12.766887423,17.34847666,50200092
19.304026577,30,16.234747643,20.622922173,14.941063152,18.290061043,10.078022973,16.344078523,7.7796863659,11.401628124,19.058942746,30,10.172555043,15.748818727,13.440658475,23.281198779,9.3475116986,14.29992952,,,5.5824330023,11.836673567,4.1624626056,10.178769686,14.040985223,22.890627494,16.031463512,20.057255559,11.694070818,13.576619975,10.791294378,16.620767164,13.506940652,13.331464106,12.638036654,17.439678268,11.996012462,23.399753279,9.4025269123,13.518915003,11.860667197,16.92673736,15.603366735,21.223291284,15.531500473,30,10.950205509,15.766187883,13.2706482,20.17210034,13.063218091,21.400850605,10.067278178,14.79503485,13.046023193,19.125714263,,,,,13.197946541,22.036769635,14.84196215,30,,,,,,,,,17.535299793,18.542060555,50200095
18.919258983,21.61696953,15.097223756,16.344420439,13.185452719,13.629026841,10.02562243,9.999909784,6.5267396121,6.8813299729,15.336659088,18.983374108,8.7868815997,10.41393392,15.146145755,15.825266133,7.7713152123,7.768879331,,,5.6991528506,6.72698236,3.5203682102,4.260131499,16.899303362,17.274299117,12.129896942,11.828628717,10.241091557,11.767681522,9.8220434274,11.004830976,12.725099579,13.517179402,11.761322659,12.073197386,12.339536232,13.245299311,7.4505282927,8.2253316057,10.426918427,11.282546937,15.657733172,16.475645285,15.1441086,16.87535211,8.6248831855,9.5127361515,13.415740483,14.380662743,12.968019732,14.719963153,8.482884906,9.5859126183,11.042018993,11.994125923,,,,,13.581224242,13.937391828,16.96432427,17.959253987,,,,,,,,,13.165455067,13.336915263,50200096
22.023112823,22.148468197,18.856482284,19.460937367,15.531547607,13.97729826,13.241153767,10.38041481,8.6762478185,6.8153324072,16.166217491,19.030320363,11.917928863,10.32301612,16.26405154,13.483639485,9.5186473544,6.3426355863,,,8.8549814509,6.5979157343,6.8018840147,4.2381057829,17.017280737,18.031020316,14.9605043,16.366260448,14.213933815,11.467949119,12.779308982,10.183884716,15.75530432,12.978984381,14.137156355,12.516857563,15.475172935,12.465520182,9.9166714147,8.479890678,13.1587295,11.749533043,17.619972599,16.349957775,18.546315283,14.986158993,12.828283976,10.037124598,16.749649197,14.250934427,17.094401566,13.711447154,11.757526287,10.50872794,17.02141937,13.027567573,,,,,14.032883725,14.495198938,17.52170302,19.603805527,,,,,,,,,14.32994611,13.609309007,50200097
18.394949297,,17.43404499,,14.360351795,,9.976941137,,7.1182265809,,17.826491936,,9.796357813,,16.120407339,,9.4532934379,,,,6.8952793901,,4.4910502139,,15.232578349,,13.914342935,,10.339699487,,10.228583747,,12.394540052,,11.710583778,,12.403994655,,8.1799770287,,11.38493783,,15.971232241,,14.6318015,,9.3745718898,,13.305623807,,13.463686852,,9.410701564,,11.2599612,,,,,,13.360309004,,15.66811984,,,,,,,,,,14.639879837,,50200098
17.903711413,20.1387722,13.404529101,15.901992429,12.669310755,12.894621844,9.3817526027,9.6518182543,6.9444956196,6.4989934365,13.262995418,14.591600364,9.2093676297,8.716701003,11.757806925,13.099164229,8.2018959021,6.4479759207,,,3.7541160845,4.4278608266,2.6487767584,2.9820818286,15.714246116,13.928600506,13.219748873,12.683085246,9.0939832656,9.3468708742,9.0104983447,9.0402126322,11.788743094,11.953818713,11.42030139,11.68814886,11.451244253,11.243124818,7.8084236163,7.353549523,11.032305437,10.839365493,14.504326142,14.728655087,12.882737513,13.085976193,9.7086085094,8.5313290938,14.029691773,13.05635502,10.295177978,11.583006206,7.8338557873,7.9408893893,10.296502957,10.2928579,,,,,13.32161956,11.495705831,16.226303993,14.780840683,,,,,,,,,11.607839747,12.64736246,50200099
19.799415683,22.257358925,17.04709141,30,13.967144052,17.552099926,11.576459537,16.98249144,6.9992629043,10.841901506,14.64014961,30,9.803369201,15.44113295,15.38613978,21.144168736,8.3258185427,10.61463454,,,7.1095718365,11.014912922,4.4088684419,8.8824905704,16.283547127,23.200868977,13.272580622,16.13387851,10.566732297,15.576391572,9.7192730397,15.194136041,12.888334106,15.946312826,12.359038368,17.440663159,11.997986269,16.713248778,8.1881739543,12.917461227,11.41954387,16.220344457,15.949710833,21.991138389,14.736232983,22.99,9.9750744216,14.719669838,13.503401527,21.040392123,12.714739417,19.995592185,9.339962322,15.048564077,11.99339442,17.719818893,,,,,13.633772587,19.442339949,16.85798131,23.67218768,,,,,,,,,14.230713437,17.17566145,50200100
21.5240473,,16.399038308,,14.230452207,,10.959351513,,7.4505088471,,17.744184144,,9.851932169,,14.448717769,,8.5113518815,,,,4.9758222938,,4.2658831136,,14.510948074,,13.829716485,,10.440603377,,10.221275663,,12.918536815,,12.089756585,,12.78899469,,8.5025259103,,11.539798367,,16.186453311,,15.036347247,,10.266133795,,13.359771197,,13.379217149,,9.148296544,,13.185471373,,,,,,12.401073659,,14.7668702,,,,,,,,,,15.239950177,,50200101
23.150330205,,18.465675768,,16.484031387,,13.295147103,,8.5290230898,,19.63265526,,12.702154733,,14.902960888,,8.4811678907,,,,7.7459899221,,5.8883081104,,17.740031845,,14.877504808,,13.950563578,,12.605244476,,15.740679249,,14.283590606,,15.613412566,,10.23589447,,13.81650329,,18.454760493,,19.84848353,,12.039193992,,16.721755143,,17.177741367,,11.577957333,,14.805081277,,,,,,13.73659399,,18.492572847,,,,,,,,,,14.867462597,,50200102
19.800143877,22.721103747,16.941082664,17.340602439,13.778262888,13.79183685,9.3935149767,9.779462921,6.8904195644,6.9410538179,19.347991529,19.596562613,9.5195769767,10.312199283,14.52653306,14.382024475,7.3584381861,7.7474075566,,,3.6691679838,5.339794171,3.0440196381,3.7152177946,18.440872656,16.989671813,15.598858895,10.790338955,10.053967069,10.879489526,9.5896224912,10.430713441,11.10747188,12.294836382,12.279069718,12.628668538,11.442632106,12.384574376,7.7832949963,8.284728344,11.24457029,11.871472257,15.331028481,16.693835246,14.534096707,15.806455897,8.4285694422,9.3591328753,12.462779843,13.651827787,11.681787462,13.695834316,8.5757910473,9.6108460353,11.249162267,12.22823259,,,,,14.428564643,13.745688816,17.972793287,17.20334126,,,,,,,,,16.272267977,14.45203076,50200103
21.67799682,,17.853323111,,15.785359792,,13.275292383,,8.6028114659,,15.371381559,,12.224692947,,19.794768918,,10.364348792,,,,10.17534279,,7.2290269697,,18.058491969,,15.371644213,,12.737445161,,12.432596257,,14.759344817,,13.792841141,,14.656576394,,9.8711650187,,13.261600187,,18.63282711,,17.41555592,,11.819041124,,16.538495547,,15.917929281,,11.857140693,,15.970967743,,,,,,14.878427938,,18.20933669,,,,,,,,,,14.345817917,,50200104
23.66059117,22.659292617,19.76157105,18.144278736,16.373040948,14.822724901,14.964167593,11.913290823,9.4335472716,8.3210126825,21.606910341,20.692467916,14.733442817,12.092694053,20.362822429,19.178347454,12.734646413,12.232821128,,,11.661703901,10.955416945,8.9099622541,7.6657793489,20.005799686,20.009609074,18.32640331,16.210738118,15.169090924,13.112481433,14.660505385,13.038753233,17.049622741,15.600312514,15.291347947,13.228045623,16.745444004,14.439174785,11.422291367,10.661857303,14.74044921,12.97876773,21.253116327,17.730655923,23.058195957,18.23683858,13.515519968,12.855781791,19.51921828,16.280612327,19.540191543,16.747286184,13.729159257,11.912681573,17.68753151,15.768457477,,,,,16.584021501,16.479074798,21.05385471,19.9727856,,,,,,,,,16.485344297,15.912582317,50200106
21.393683653,,18.021199217,,15.019986876,,12.4668325,,7.598688262,,17.339208677,,10.48357969,,16.876089224,,8.1727103184,,,,8.4390734881,,5.4784165713,,17.452740136,,15.786653465,,11.11822222,,10.803295197,,12.654298054,,13.179248679,,13.404714474,,9.2063641917,,12.003593573,,17.489248513,,14.818462817,,10.299548084,,14.934872063,,13.723751883,,10.125998513,,12.467844143,,,,,,14.612476776,,18.135970887,,,,,,,,,,14.676492033,,50200107
18.871104053,,16.147152191,,14.605679941,,10.359318667,,7.513171197,,14.916148171,,10.879981887,,20.139420698,,12.364034675,,,,9.0660874907,,6.0786391251,,18.926511133,,14.361417278,,11.474897634,,11.551076272,,13.789297659,,12.306820651,,13.158050636,,9.1607866743,,12.420753487,,16.804097684,,16.636118813,,11.168273498,,15.407333697,,14.58413049,,10.29701567,,13.156885127,,,,,,16.53713394,,20.324396437,,,,,,,,,,15.163088263,,50200108
21.36369,30,17.059414956,30,15.372318176,30,12.11373108,30,8.6836917393,30,17.161286065,30,11.401547113,30,18.704206555,30,12.880014642,30,,,8.6438303013,30,6.5364258077,30,17.407205389,30,14.098763952,30,12.290837623,30,12.195938593,30,15.249710551,30,13.219125034,30,14.194238235,30,9.937923116,30,12.746983063,30,17.65683492,30,18.34064075,30,12.316498013,30,16.250770987,30,16.372333575,30,11.126158557,30,14.87998406,30,,,,,15.307648754,30,18.437731623,30,,,,,,,,,15.223453143,30,50200109
19.988242983,20.583058597,15.53620523,20.88014785,13.776463046,16.719651796,9.346569826,13.841478373,7.7190857067,9.8365165386,19.246881517,19.047781296,10.041551407,13.883064923,18.367015427,23.856594409,11.357724943,12.625718537,,,4.6327899649,11.465157793,3.7991893157,8.6924591541,18.972041788,22.692197968,13.166834562,12.178132476,10.358584916,15.39608065,10.007657004,14.872389607,12.404870652,16.46275545,12.601078834,14.378844923,12.406978542,17.300202635,9.0312440837,11.86447542,11.377855043,14.3999283,14.742015336,21.236004486,14.938085343,21.097328147,9.4661479242,13.098730736,14.161874283,17.95993263,11.854085977,19.542973869,9.0211851947,13.60160087,11.081472647,16.903152307,,,,,16.228528617,19.13222614,19.026141457,24.620027327,,,,,,,,,14.718669393,15.801819183,50200110
20.411007723,20.467405423,17.776388873,15.676474527,14.252322004,13.407852916,10.29768898,9.3144750747,6.8986809192,6.6926158489,18.650406851,16.006382275,10.30329094,9.2283215513,13.792714142,12.516207958,6.9676680533,6.5742586789,,,6.6476256911,4.5405303016,4.3587714518,3.6545746309,14.541116122,13.574681152,13.910113856,13.746951636,11.25143927,10.21779562,10.465247911,9.6553956132,13.916094694,12.693394872,12.29294539,11.313735421,13.037173395,11.69942236,8.396429008,7.7922740643,11.628273337,11.12210295,16.45589489,15.03372547,16.307145687,14.561881487,9.7822025631,9.3966082178,14.46815123,13.35964055,13.879990184,12.055104507,9.8765444467,8.5642556137,12.4757647,11.73935221,,,,,12.162104117,11.363809846,15.340288943,13.956592593,,,,,,,,,14.75170215,14.677008833,50200111
21.931823063,20.17310489,16.972878361,16.998117491,14.913925876,14.115722334,11.579302543,10.470985433,7.4449480698,7.3463069615,16.638701099,17.161679659,10.353971017,10.157921657,15.167051796,18.946689071,8.3292106149,9.6898295678,,,5.8025120074,7.6837830654,4.1946137228,5.0461400281,15.270371174,18.324195459,12.384164572,14.991101536,11.322476564,11.541736629,10.266011452,10.731460311,13.297160615,13.785538251,12.355786863,11.869801787,12.935556585,12.837974203,8.5943953903,8.8319241127,11.852184733,11.640367773,16.889461148,15.70512487,15.839696057,16.285233247,10.241843951,10.369998018,14.609794667,15.061286377,13.442825482,14.115588294,9.278088353,9.9685165147,13.133046787,13.34538071,,,,,12.769627845,15.626577361,15.450338217,18.382800367,,,,,,,,,13.502444523,14.87561531,50200112
22.033394427,,16.223505166,,15.508788156,,11.85988029,,8.9095490762,,19.564968373,,11.654446863,,18.332501412,,10.578987944,,,,6.7122740462,,5.1653624975,,20.191712417,,16.354349107,,11.499646635,,11.634224642,,13.392646456,,13.031173384,,12.89356028,,9.9977955523,,12.900106707,,16.931034608,,15.905275377,,12.047242211,,14.740602017,,14.776978518,,10.397056067,,13.59308675,,,,,,16.975859632,,21.131460643,,,,,,,,,,17.060528413,,50200113
20.918936087,19.50253138,18.257617045,16.9361593,15.468577162,14.364343626,13.80685611,11.35569226,8.3073005502,7.2884927614,17.366090182,19.560129544,11.411745547,10.460865077,19.005543257,15.884901404,9.7944961939,8.7615892923,,,8.0179133959,7.9987845424,5.7714696565,4.8994075901,18.915242895,18.396576964,15.616296784,15.868014938,12.000574052,12.058860643,11.734425293,11.066240123,14.062560577,14.136718217,13.798703132,12.45324097,15.255656519,13.708298637,9.2395187237,8.6863023803,12.355886383,11.173795073,17.405219155,16.606787125,17.5490205,16.822722607,10.751401551,10.575883736,15.5552417,14.65644783,15.634483539,15.418433245,10.491049133,10.51622508,14.48788055,13.84493344,,,,,16.20202841,14.696376732,19.425365953,18.692292387,,,,,,,,,15.469560767,14.595932187,50200114
23.077482857,,16.092517311,,14.419082215,,11.308452863,,7.2948625265,,15.831582415,,10.18663116,,16.894545431,,9.0448063098,,,,8.6467428449,,5.3475372346,,20.029535337,,14.796666013,,11.19040554,,10.892670579,,13.49729545,,12.982866827,,13.368316309,,8.839336505,,11.950373887,,15.68859981,,15.048968037,,10.520692815,,15.024643923,,13.605555775,,10.165093163,,12.187138477,,,,,,16.487098412,,19.475405473,,,,,,,,,,15.1180467,,50200115
19.97133078,21.282476753,19.086056839,20.654849117,15.208945469,15.508751312,11.368352213,13.314203847,7.9060586015,8.7137891654,20.921407902,20.383824107,11.22334806,13.18000219,12.366323154,18.747360982,7.5681755979,11.030545212,,,5.1766472627,10.302707695,4.1171466826,7.3481734298,13.518255228,18.682355335,16.04892572,17.930852756,12.72817008,14.722952676,11.730689759,13.679047273,14.253241071,15.651512966,13.337059662,13.726828702,13.091849929,15.726135455,9.5030080663,10.486955343,12.397435867,13.32763022,17.150586092,20.055566579,17.829407047,20.080674357,11.139746134,12.552085223,14.711313777,17.159207457,14.315075468,18.241510722,10.056047437,12.557495373,13.630978577,15.894316067,,,,,10.853860787,15.262325366,13.617933233,19.014458827,,,,,,,,,16.35675876,16.297920537,50200116
20.243217137,19.74663154,17.569100929,17.11928568,15.377078363,14.754470999,12.400734897,11.087987557,7.3350083172,7.3705562517,21.153618239,19.832678939,11.188953847,10.023031695,19.49870322,19.560040637,9.3395474189,8.5584016052,,,7.4738678612,7.1168537099,5.2102055941,4.8180503128,19.781217547,19.488108121,15.649207708,14.258595331,12.932478776,10.829205626,11.48589947,10.483893801,14.152296867,12.659826223,13.065427158,12.976016114,14.2151379,12.779396364,8.7883257497,8.7288549307,11.832985397,11.267559783,18.970672241,17.027098275,17.968910113,15.27098728,10.314348156,10.074323965,15.270144167,13.44256119,15.428652636,13.101186359,10.548761717,9.773155975,12.443146283,11.59838517,,,,,15.849824162,16.316373605,19.50258129,19.334954923,,,,,,,,,14.512609107,15.371379363,50200117
23.62198524,20.18858143,17.696632604,19.051515441,14.944518343,14.534448053,11.40948238,11.874633477,7.698228082,7.8613329114,15.506583899,18.534535137,9.9893188773,11.04149051,14.044721628,16.63097576,8.3487365494,8.9219275179,,,6.1572700563,8.0280366147,4.4947727112,5.6019312851,14.348797687,16.735299929,14.038010619,14.035668428,10.408732992,11.867306483,10.278739546,11.200221117,12.3355112,14.28104402,12.270922509,12.421683526,12.389349732,14.252753707,8.917748574,9.4146906123,12.043779553,12.69648455,15.987335045,17.677765403,13.839732093,17.012486717,10.583153431,10.999218188,13.115195037,15.522486927,12.442706685,14.73516991,9.6040043053,10.59865276,12.751283803,13.510305923,,,,,12.541900594,14.247076686,14.113796367,17.07212227,,,,,,,,,16.476460283,15.28253389,50200118
22.983024757,,19.231491099,,15.218485846,,12.474742963,,7.9541663252,,13.672269304,,11.617027267,,17.420373456,,11.351748722,,,,9.4898593265,,6.4542158722,,17.605577474,,15.497739653,,13.11371257,,11.853426686,,15.164398242,,12.446586723,,14.389003727,,9.291837424,,12.880763223,,18.198334381,,18.125495973,,11.095125235,,16.212779833,,16.064457327,,11.46897595,,14.41876572,,,,,,14.579207113,,18.254236767,,,,,,,,,,15.284427723,,50200119
21.816616653,19.65946579,17.009514377,17.862982043,14.13955943,14.748072603,11.22528553,11.480813593,8.0649647684,8.0407909847,13.54229511,17.434912038,10.38406219,10.769760667,15.400261637,16.546981626,8.4100654759,7.7901072191,,,7.4160089066,6.9039014423,5.2825932613,4.7316057921,17.993334507,20.003502425,16.031480284,15.742765229,11.250760855,12.131187583,11.185282898,11.318311439,13.605612544,13.507025629,11.715895974,13.046725159,12.407532258,12.758266441,8.781514182,8.948038032,12.062652027,12.03814925,16.32356345,17.687123578,15.494525837,14.851398473,12.169562264,11.004216315,14.785516797,14.98393555,14.245103604,14.018033122,10.062813715,10.356640857,13.87014717,12.265062793,,,,,14.576339168,16.003308111,19.543089307,21.340262957,,,,,,,,,14.743243137,14.223522383,50200120
22.83443661,19.639531557,18.727193205,16.233900623,16.211764258,13.866882855,13.718821223,9.9630166543,8.8929647533,6.9079168432,16.294039522,20.662756198,12.315706223,10.024505656,19.489242818,16.528100682,9.9891296304,8.0096741373,,,8.9878358794,5.6157465662,6.5927291694,3.7994747351,20.094892154,18.661808655,14.362176829,12.285378808,12.686643727,10.148295961,11.665239332,9.756771208,14.976521413,12.75012294,13.955882139,12.256046815,14.320941899,12.304928165,9.944803492,8.3826047763,13.191279297,11.039469417,18.753184948,16.731114496,17.67377177,14.718516673,11.19969713,9.5846948745,15.515680573,13.537591213,16.529424503,12.955496788,11.463186037,9.1709923973,13.14615796,11.33764174,,,,,16.64164663,15.343705432,20.706445977,19.32950399,,,,,,,,,16.198617873,14.926571287,50200121
20.43771561,21.0165465,14.037974248,17.800019071,14.324145333,14.34767656,11.190244063,12.134122227,7.7367168304,7.9250526009,17.049055815,17.302086301,11.07109727,12.064788277,14.462612647,21.644030001,9.3889624874,13.697521299,,,6.6911461454,11.857621582,5.5863506533,8.3716716446,16.116010775,21.185901581,14.308488673,16.895922624,12.572513566,13.119835907,11.854656066,13.246727047,14.866565397,15.541930376,12.873470889,13.561627368,13.855074276,14.825714752,9.198119583,10.001843578,12.61034329,12.842858143,16.915674087,18.104472886,17.257771783,17.935700793,12.622995282,12.759091634,14.80692493,16.57007604,14.380716779,15.72179335,9.9137895833,11.757754293,14.07022849,15.812758507,,,,,13.060255964,17.380887791,15.682967837,20.289907297,,,,,,,,,14.076683667,16.333144013,50200122
24.980643505,24.01094645,18.908719161,20.567356809,14.891973721,15.457588295,11.56341222,11.502886993,8.1161280698,8.5525677272,15.101238579,30,11.272500773,11.892088867,18.569030459,17.591185392,12.053865328,10.079377566,,,10.443669129,9.1125740064,6.7961456375,5.9952748452,17.099103107,19.266674499,16.551474663,16.494097168,12.611047797,12.652092334,11.722906842,12.092128035,14.771411537,14.941905406,12.151052181,13.600400213,13.517790505,14.210894186,9.2918667177,10.059955082,12.836147087,13.25304433,17.317962229,18.616557296,17.81903032,18.12247979,11.979328641,11.783249899,16.13638733,16.71622413,15.75953388,15.759759679,11.236348363,12.007341877,14.710600903,14.115866623,,,,,14.255948325,15.85362406,17.156302503,19.747915253,,,,,,,,,15.73975218,16.02261362,50200123
20.589220447,,17.353736812,,14.2427086,,12.09096019,,7.7950727851,,15.576562637,,11.400449413,,20.728294136,,12.085614033,,,,10.379169428,,7.0242320191,,19.465014718,,14.999783066,,12.847635128,,12.42265973,,15.262639745,,13.005159499,,14.789713308,,9.4236549947,,12.365406593,,17.813403538,,17.960262503,,12.052148125,,15.56708996,,15.919281453,,11.216457103,,14.92643358,,,,,,16.343732613,,19.464236627,,,,,,,,,,14.834039917,,50200125
21.290518755,,17.559979921,,14.576493137,,11.986198793,,7.565657647,,16.915812119,,12.05711448,,20.442614667,,11.648078321,,,,8.9655264007,,6.2560013769,,20.755727679,,14.368072314,,12.928260801,,11.751174231,,15.48617233,,12.270822169,,14.352615127,,9.0323780373,,12.63192358,,18.463753645,,18.608557617,,11.296083398,,16.707436457,,16.74049841,,11.16032191,,14.710241947,,,,,,15.397163524,,21.61603156,,,,,,,,,,14.338993223,,50200126
20.753176133,,15.31364735,,12.915313431,,10.166648363,,6.5019396256,,14.946258262,,9.819925249,,15.801788118,,10.421856328,,,,8.5073298716,,5.0902331405,,15.315268161,,15.916916173,,10.660011735,,10.89376009,,13.232441766,,11.575758897,,12.351910319,,7.9396991973,,11.190111787,,15.784016404,,14.550860377,,10.003272773,,14.80235387,,12.834058155,,9.31296464,,12.46582775,,,,,,12.795357501,,15.772384593,,,,,,,,,,13.14994364,,50200128
22.78889304,,17.782409578,,13.804953819,,11.35738442,,7.141742742,,14.771926017,,9.9530878337,,16.622813009,,9.7992881041,,,,9.3022924696,,5.8312965475,,16.074075428,,14.644519213,,10.68080458,,10.505693356,,13.64190598,,11.778611288,,12.307391286,,8.459199727,,11.62204804,,15.927691782,,14.91527485,,11.161283544,,14.15457625,,13.577010383,,10.022852106,,14.274549737,,,,,,14.076346379,,16.854854833,,,,,,,,,,14.729656303,,50200129
20.96764245,,16.020785928,,13.948538659,,10.176042833,,7.0774660057,,16.24924597,,9.7244910033,,12.730073847,,7.7245125682,,,,6.0196679549,,3.8748431658,,12.851395874,,14.05444936,,10.809677981,,10.311223623,,13.620434021,,12.374529164,,12.550405729,,8.0713094393,,11.26225298,,16.196445131,,15.434659557,,9.8465105983,,13.327517033,,13.619688861,,9.5848979263,,12.217431973,,,,,,11.002674691,,13.574576007,,,,,,,,,,15.435144143,,50200132
18.086118633,,15.870059073,,13.364074755,,9.5361715673,,6.0843711907,,15.840869168,,9.220025144,,13.949030686,,7.766261955,,,,5.0826295724,,2.968009408,,15.108997663,,14.089355121,,9.3783123905,,9.0484129689,,11.236342405,,11.313617055,,11.490681359,,7.237063751,,10.43604574,,14.577720322,,13.60120801,,9.0566897806,,12.039480987,,11.92758282,,8.6545041027,,11.05462133,,,,,,13.067001777,,15.022180903,,,,,,,,,,15.32956369,,50200134
21.950465053,,15.941339587,,14.427064239,,11.286696677,,7.7152382763,,14.648862857,,10.550022623,,16.022524782,,11.667122314,,,,7.6550556558,,5.5698306698,,15.256807599,,13.30029222,,11.505803205,,11.072837411,,14.057547062,,12.225366769,,12.922878941,,9.0197768887,,12.122002737,,15.763788744,,16.16216178,,11.287291206,,14.30611446,,13.800499053,,10.061587947,,13.238695493,,,,,,13.739325075,,15.812758253,,,,,,,,,,17.11057181,,50200135
18.106669533,,12.356521027,,12.465191459,,8.478759451,,6.2141291352,,14.824932563,,9.0285053603,,12.937813998,,9.1521740421,,,,4.9109379139,,3.0989793619,,12.494055489,,12.472176629,,9.8190672431,,9.7074379057,,11.741381065,,11.218759799,,10.691582565,,7.7201846287,,10.350043467,,14.537860653,,13.537926053,,9.6489416781,,13.482643473,,11.480322811,,8.2355452367,,11.3070103,,,,,,11.56728439,,12.91997734,,,,,,,,,,13.870104287,,50200136
22.68962915,,18.466864867,,14.405903106,,12.074323467,,7.3940908884,,16.657457043,,11.086536787,,16.739778149,,9.8109918893,,,,8.8495100092,,5.9885007736,,17.494704413,,15.070934865,,11.565495797,,11.206816674,,14.847159276,,11.985213266,,14.073725291,,8.8389910803,,12.20318739,,17.432252512,,17.56247266,,11.492939391,,14.49124141,,15.834570013,,11.110371367,,13.806714947,,,,,,14.859820429,,18.068338123,,,,,,,,,,14.828945357,,50200137
22.14215946,,15.984348777,,14.283346149,,9.735545805,,6.6689625889,,18.940275848,,9.3638846793,,15.821825803,,7.3908261129,,,,5.4797195101,,3.8034070864,,17.631048271,,13.132086948,,10.681488902,,9.6261447525,,12.211690612,,12.012206683,,12.331606191,,7.9280632833,,11.141190597,,16.048970795,,14.408694567,,9.0450257975,,13.142770783,,12.459267315,,9.0475903887,,10.900009707,,,,,,14.225448052,,18.062571843,,,,,,,,,,13.887657877,,50200138
;;;;

 


Accepted Solutions
Solution
‎06-25-2018 08:03 AM
Super User
Posts: 24,026

Re: Need efficient way to create a variables calculating differences in a wide dataset

Arrays will work. Here's some skeleton code that can get you started.

 

It seems like you may be calculating more than one variable for the output? If so, you may need more than one array to hold the output values. 

 

You could also consider transposing your data which would probably make your life easier in the long run.

 

 

data want;
set have;

array a_20 (*) il6_mrna_20 ifng_mrna_20 ... list of variables;
array a_30 (*) il6_mrna_30 ifng_mrna_30 ... list of variables;

array diffs(32) diff1-diff32; *or names you want;

do i=1 to dim(a_20);

diffs(i) = a_30(i) - a_20(i);
rest of calculations;

end;

run;

View solution in original post


All Replies
Solution
‎06-25-2018 08:03 AM
Super User
Posts: 24,026

Re: Need efficient way to create a variables calculating differences in a wide dataset

Arrays will work. Here's some skeleton code that can get you started.

 

It seems like you may be calculating more than one variable for the output? If so, you may need more than one array to hold the output values. 

 

You could also consider transposing your data which would probably make your life easier in the long run.

 

 

data want;
set have;

array a_20 (*) il6_mrna_20 ifng_mrna_20 ... list of variables;
array a_30 (*) il6_mrna_30 ifng_mrna_30 ... list of variables;

array diffs(32) diff1-diff32; *or names you want;

do i=1 to dim(a_20);

diffs(i) = a_30(i) - a_20(i);
rest of calculations;

end;

run;
Occasional Contributor
Posts: 15

Re: Need efficient way to create a variables calculating differences in a wide dataset

Thank you so much! I typically work with long datasets and dont work with arrays too often. Thanks again for clarifying and sorry for asking such a simple question!

Super User
Posts: 13,947

Re: Need efficient way to create a variables calculating differences in a wide dataset

Things might go better if you cut down your example data to maybe three groups of variables and 2 or three rows of example data with fewer digits.

Then you could hand calculate a examples and show what the actual desired result for the example data looks like.

Generally similar calculations tend to lean toward arrays.

I would think one array to hold all of the _20 variables, another for the _30, a third to hold the results of the fc_raw and another for the foldchange.

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 133 views
  • 0 likes
  • 3 in conversation