BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
acordes
Rhodochrosite | Level 12

I have successfully rebuilt the graph from the following link using my data. https://communities.sas.com/t5/SAS-Communities-Library/3-steps-to-build-a-trend-comparison-line-plot... 

 

To shape the data correctly for the garph's requirements I've tried the DoW technique, but I have several questions:

Can I apply a third time the DoW technique to get the ytd running totals instead of doing an additional new data step?

Why does the acum var which accumulates one year's observations need to divide by n to get the right result?

 

Here comes the code:

data RISKNOBA.TT;
  infile datalines dsd truncover;
  input _brand:$200. _gama:$200. SALES_RES:32. _year:$4. _fecha_venta:$7.;
datalines4;
Audi,new model,0.3830940624,2021,2021M01
Audi,new model,0.3428581134,2021,2021M03
Audi,new model,0.4118927519,2020,2020M06
Audi,new model,0.4191711448,2020,2020M06
Audi,new model,0.4178303067,2021,2021M01
Audi,new model,0.4590974406,2020,2020M08
Audi,new model,0.4436674258,2021,2021M01
Audi,new model,0.43895447,2020,2020M01
Audi,new model,0.4026715417,2020,2020M05
Audi,new model,0.5959787906,2020,2020M10
Audi,new model,0.5297978557,2020,2020M09
Audi,new model,0.5920647344,2020,2020M11
Audi,new model,0.5720171002,2021,2021M06
Audi,new model,0.5836612232,2021,2021M05
Audi,new model,0.5593217398,2021,2021M06
Audi,new model,0.450581215,2021,2021M05
Audi,new model,0.5179949133,2020,2020M08
Audi,new model,0.5017488154,2021,2021M03
Audi,new model,0.5806222023,2020,2020M01
Audi,new model,0.537967365,2020,2020M10
Audi,new model,0.5746365717,2020,2020M10
Audi,new model,0.3574689343,2020,2020M08
Audi,new model,0.4508033113,2021,2021M06
Audi,new model,0.4948680097,2020,2020M07
Audi,new model,0.4848906693,2020,2020M06
Audi,new model,0.474383876,2021,2021M07
Audi,new model,0.5548508328,2021,2021M01
Audi,new model,0.4647164158,2021,2021M03
Audi,new model,0.6029332055,2020,2020M02
Audi,new model,0.6094015319,2021,2021M01
Audi,new model,0.316220904,2021,2021M01
Audi,new model,0.4770916696,2021,2021M06
Audi,new model,0.6321059536,2020,2020M02
Audi,new model,0.5389039621,2021,2021M01
Audi,new model,0.4997045902,2020,2020M05
Audi,new model,0.5200988967,2021,2021M01
Audi,new model,0.509609758,2021,2021M01
Audi,new model,0.5260486795,2021,2021M04
Audi,new model,0.4972196529,2020,2020M06
Audi,new model,0.5344985572,2020,2020M09
Audi,new model,0.539445108,2020,2020M12
Audi,new model,0.5483164903,2021,2021M01
Audi,new model,0.6094358946,2020,2020M07
Audi,new model,0.5325663481,2020,2020M09
Audi,new model,0.615309907,2021,2021M04
Audi,new model,0.563873152,2021,2021M04
Audi,new model,0.498734603,2020,2020M08
Audi,new model,0.5195608617,2021,2021M02
Audi,new model,0.5016701795,2020,2020M08
Audi,new model,0.5783319654,2020,2020M02
Audi,new model,0.4817471605,2021,2021M05
Audi,new model,0.5316307501,2020,2020M09
Audi,new model,0.4562567099,2021,2021M05
Audi,new model,0.4563843593,2021,2021M03
Audi,new model,0.6079462212,2021,2021M06
Audi,new model,0.4596870489,2020,2020M12
Audi,new model,0.5104476806,2020,2020M10
Audi,new model,0.5110790393,2021,2021M04
Audi,new model,0.4982864135,2021,2021M05
Audi,new model,0.5206217576,2021,2021M01
Audi,new model,0.5082994433,2021,2021M05
Audi,new model,0.6240928908,2021,2021M06
Audi,new model,0.4793837511,2020,2020M06
Audi,new model,0.5027842483,2021,2021M05
Audi,new model,0.5147795073,2021,2021M03
Audi,new model,0.4295627918,2021,2021M03
Audi,new model,0.4997587625,2021,2021M04
Audi,new model,0.5180861658,2020,2020M07
Audi,new model,0.5440976268,2021,2021M04
Audi,new model,0.5144760339,2021,2021M02
Audi,new model,0.5112494333,2020,2020M07
Audi,new model,0.4235077143,2021,2021M03
Audi,new model,0.4235800102,2020,2020M12
Audi,new model,0.5309898339,2021,2021M03
Audi,new model,0.651136692,2020,2020M08
Audi,new model,0.3624934962,2021,2021M03
Audi,new model,0.5017966012,2021,2021M06
Audi,new model,0.5232546872,2021,2021M01
Audi,new model,0.5621318103,2021,2021M02
Audi,new model,0.530979524,2021,2021M06
Audi,new model,0.4931005772,2020,2020M06
Audi,new model,0.4807536896,2021,2021M03
Audi,new model,0.51236884,2021,2021M03
Audi,new model,0.5176585218,2021,2021M04
Audi,new model,0.4047494759,2021,2021M03
Audi,new model,0.478507047,2020,2020M12
Audi,new model,0.5002078237,2021,2021M01
Audi,new model,0.4985906119,2021,2021M03
Audi,new model,0.373168534,2021,2021M06
Audi,new model,0.53460096,2021,2021M06
Audi,new model,0.478094302,2021,2021M05
Audi,new model,0.4631063688,2020,2020M12
Audi,new model,0.5019624463,2020,2020M01
Audi,new model,0.4848382951,2021,2021M04
Audi,new model,0.4328203965,2021,2021M01
Audi,new model,0.5183113031,2020,2020M10
Audi,new model,0.424716105,2020,2020M06
Audi,new model,0.4094839526,2020,2020M12
Audi,new model,0.4083740612,2020,2020M03
Audi,new model,0.2489782539,2020,2020M12
Audi,new model,0.3872312804,2020,2020M02
Audi,new model,0.3378119216,2020,2020M12
Audi,new model,0.4307111018,2020,2020M08
Audi,new model,0.3801585651,2020,2020M06
Audi,new model,0.4087014385,2021,2021M05
Audi,new model,0.3117760764,2021,2021M04
Audi,new model,0.4401079189,2021,2021M03
Audi,new model,0.4171624997,2020,2020M12
Audi,new model,0.4054984387,2020,2020M06
Audi,new model,0.4104144651,2020,2020M09
Audi,new model,0.4263458755,2020,2020M09
Audi,new model,0.4309320973,2021,2021M07
Audi,new model,0.6333189547,2021,2021M01
Audi,new model,0.5195661056,2021,2021M06
Audi,new model,0.4384074912,2021,2021M01
Audi,new model,0.4585506575,2020,2020M11
Audi,new model,0.4771091785,2021,2021M01
Audi,new model,0.4884388365,2020,2020M08
Audi,new model,0.5314233638,2021,2021M05
Audi,new model,0.6802602747,2020,2020M02
Audi,new model,0.4808270046,2021,2021M05
Audi,new model,0.4760653249,2021,2021M06
Audi,new model,0.516183258,2021,2021M02
Audi,new model,0.5198170149,2021,2021M05
Audi,new model,0.5276128292,2021,2021M03
Audi,new model,0.5009779457,2021,2021M04
Audi,new model,0.5022481472,2021,2021M04
Audi,new model,0.5696630596,2020,2020M10
Audi,new model,0.4742420919,2021,2021M01
Audi,new model,0.4071112034,2020,2020M09
Audi,new model,0.5167383948,2021,2021M04
Audi,new model,0.5380667428,2021,2021M06
Audi,new model,0.4682216542,2021,2021M04
Audi,new model,0.5784840694,2021,2021M06
Audi,new model,0.5222443379,2021,2021M04
Audi,new model,0.5670324333,2021,2021M06
Audi,new model,0.5044806402,2021,2021M06
Audi,new model,0.4753757079,2020,2020M06
Audi,new model,0.4995599089,2021,2021M02
Audi,new model,0.4881252774,2021,2021M06
Audi,new model,0.5367963326,2021,2021M03
Audi,new model,0.5473630988,2020,2020M08
Audi,new model,0.5247575106,2020,2020M07
Audi,new model,0.55901649,2020,2020M09
Audi,new model,0.5093456194,2020,2020M11
Audi,new model,0.5092858014,2021,2021M06
Audi,new model,0.5154911534,2020,2020M07
Audi,new model,0.4636474376,2020,2020M07
Audi,new model,0.4565109997,2020,2020M01
Audi,new model,0.4499309037,2020,2020M08
Audi,new model,0.5028793486,2021,2021M01
Audi,new model,0.469831458,2020,2020M12
Audi,new model,0.4129460458,2020,2020M07
Audi,new model,0.4177444363,2020,2020M10
Audi,new model,0.3328004888,2021,2021M01
Audi,new model,0.4061019971,2020,2020M06
Audi,new model,0.4568074199,2020,2020M01
Audi,new model,0.315007132,2020,2020M02
Audi,new model,0.4157883752,2021,2021M03
Audi,new model,0.3683162322,2020,2020M06
Audi,new model,0.3691512209,2021,2021M03
Audi,new model,0.5089086135,2021,2021M05
Audi,new model,0.4697673797,2021,2021M01
Audi,new model,0.53120564,2020,2020M07
Audi,new model,0.4562434838,2020,2020M05
Audi,new model,0.5043353871,2021,2021M06
Audi,new model,0.501097555,2021,2021M05
Audi,new model,0.4275823593,2021,2021M06
Audi,new model,0.5072558386,2021,2021M05
Audi,new model,0.5851414757,2021,2021M04
Audi,new model,0.6384766368,2021,2021M05
Audi,new model,0.5497696438,2020,2020M07
Audi,new model,0.5342284243,2020,2020M11
Audi,new model,0.4987000126,2020,2020M08
Audi,new model,0.5346548861,2021,2021M02
Audi,new model,0.5476391661,2020,2020M08
Audi,new model,0.5919203004,2020,2020M06
Audi,new model,0.509017484,2021,2021M06
Audi,new model,0.582545969,2020,2020M02
Audi,new model,0.564153142,2021,2021M07
Audi,new model,0.4755738729,2021,2021M02
Audi,new model,0.5641666816,2021,2021M05
Audi,new model,0.6806911382,2021,2021M04
Audi,new model,0.5098178055,2021,2021M01
Audi,new model,0.4477190324,2020,2020M06
Audi,new model,0.4246794331,2021,2021M03
Audi,new model,0.6311030236,2020,2020M08
Audi,new model,0.4699061168,2021,2021M03
Audi,new model,0.4140627002,2020,2020M05
Audi,new model,0.4542053729,2020,2020M11
Audi,new model,0.4442725513,2020,2020M06
Audi,new model,0.3071176585,2021,2021M02
Audi,new model,0.5072116937,2020,2020M11
Audi,new model,0.5437045163,2020,2020M11
Audi,new model,0.5507063233,2021,2021M01
Audi,new model,0.518762752,2020,2020M06
Audi,new model,0.5840187375,2021,2021M03
Audi,new model,0.477512291,2020,2020M07
Audi,new model,0.54089937,2021,2021M04
Audi,new model,0.482720988,2021,2021M03
Audi,new model,0.4234474323,2021,2021M04
Audi,new model,0.5078458731,2021,2021M01
Audi,new model,0.4121174985,2021,2021M05
Audi,new model,0.4720105762,2021,2021M05
Audi,new model,0.5724288093,2020,2020M10
Audi,new model,0.5572772405,2020,2020M10
Audi,new model,0.5762369033,2020,2020M07
Audi,new model,0.5250671931,2021,2021M03
Audi,new model,0.5409879705,2020,2020M06
Audi,new model,0.5444531024,2021,2021M07
Audi,new model,0.497854177,2020,2020M11
Audi,new model,0.5526090418,2020,2020M08
Audi,new model,0.4964595559,2020,2020M08
Audi,new model,0.4819317869,2021,2021M03
Audi,new model,0.2990910569,2020,2020M01
Audi,new model,0.4493767432,2020,2020M01
Audi,new model,0.4335524141,2021,2021M02
Audi,new model,0.5491331601,2021,2021M03
Audi,new model,0.469595061,2021,2021M03
Audi,new model,0.5325531329,2021,2021M05
Audi,new model,0.5433301084,2020,2020M09
Audi,new model,0.4384832291,2020,2020M09
Audi,new model,0.5779337759,2021,2021M05
Audi,new model,0.5405011641,2020,2020M08
Audi,new model,0.4834234354,2020,2020M08
Audi,new model,0.5042724422,2021,2021M03
Audi,new model,0.6449472095,2020,2020M10
Audi,new model,0.4527927943,2020,2020M11
Audi,new model,0.5543835271,2020,2020M12
Audi,new model,0.5290174927,2021,2021M04
Audi,new model,0.5825646608,2020,2020M08
Audi,new model,0.5236392407,2020,2020M08
Audi,new model,0.5235175501,2020,2020M12
Audi,new model,0.5252678029,2020,2020M08
Audi,new model,0.5625573031,2021,2021M05
Audi,new model,0.5363858626,2020,2020M10
Audi,new model,0.4528841479,2020,2020M11
Audi,new model,0.485729919,2020,2020M06
Audi,new model,0.453473343,2020,2020M12
Audi,new model,0.4449341727,2021,2021M01
Audi,new model,0.5479777923,2020,2020M09
Audi,new model,0.3871199099,2021,2021M03
Audi,new model,0.4139149864,2021,2021M02
Audi,new model,0.3153300689,2020,2020M06
Audi,new model,0.4549556008,2020,2020M10
Audi,new model,0.3290879158,2021,2021M03
Audi,new model,0.4642150421,2021,2021M01
Audi,new model,0.4897330345,2020,2020M11
Audi,new model,0.4538315775,2021,2021M04
Audi,new model,0.4596603635,2020,2020M07
Audi,new model,0.4592763861,2020,2020M10
Audi,new model,0.4958302876,2021,2021M05
Audi,new model,0.6731203512,2020,2020M10
Audi,new model,0.5203229792,2020,2020M10
Audi,new model,0.5124043338,2021,2021M05
Audi,new model,0.53218824,2021,2021M05
Audi,new model,0.5527008395,2021,2021M07
Audi,new model,0.3989967993,2021,2021M03
Audi,new model,0.5059146438,2020,2020M10
Audi,new model,0.4975499098,2021,2021M02
Audi,new model,0.5262557078,2020,2020M09
Audi,new model,0.4981761757,2020,2020M11
Audi,new model,0.5497748964,2021,2021M05
Audi,new model,0.5810735313,2020,2020M02
Audi,new model,0.4828306565,2020,2020M11
Audi,new model,0.5182180224,2021,2021M02
Audi,new model,0.4034950534,2020,2020M07
Audi,new model,0.4151799436,2020,2020M05
Audi,new model,0.5293020075,2020,2020M01
Audi,new model,0.4156882959,2020,2020M07
Audi,new model,0.3264677162,2020,2020M06
Audi,new model,0.4228971256,2020,2020M08
Audi,new model,0.4491091638,2020,2020M07
Audi,new model,0.4241445609,2021,2021M04
Audi,new model,0.2940319551,2020,2020M01
Audi,new model,0.4417216375,2020,2020M02
Audi,new model,0.5229397799,2020,2020M11
Audi,new model,0.4388769089,2021,2021M02
Audi,new model,0.2921936208,2020,2020M02
Audi,new model,0.3823816431,2021,2021M01
Audi,new model,0.3677540696,2020,2020M07
Audi,new model,0.5050012733,2020,2020M07
Audi,new model,0.2679908775,2020,2020M06
Audi,new model,0.3905146459,2020,2020M10
Audi,new model,0.3975976761,2020,2020M08
Audi,new model,0.3877287855,2021,2021M01
Audi,new model,0.3646219142,2020,2020M08
Audi,new model,0.4490368511,2020,2020M01
Audi,new model,0.5133830282,2021,2021M01
Audi,new model,0.4900965851,2020,2020M01
Audi,new model,0.4316302014,2020,2020M08
Audi,new model,0.3853336302,2020,2020M08
Audi,new model,0.4748769916,2021,2021M05
Audi,new model,0.4748434631,2020,2020M09
Audi,new model,0.4369328611,2021,2021M03
Audi,new model,0.5295153181,2020,2020M03
Audi,new model,0.3286258901,2021,2021M02
Audi,new model,0.4732848983,2020,2020M08
Audi,new model,0.4518672702,2020,2020M08
Audi,new model,0.4145768302,2020,2020M06
Audi,new model,0.2502534479,2020,2020M01
Audi,new model,0.4308579745,2021,2021M01
Audi,new model,0.4089589501,2020,2020M06
Audi,new model,0.4464667413,2021,2021M01
Audi,new model,0.4692451829,2021,2021M03
Audi,new model,0.3604709996,2020,2020M06
Audi,new model,0.4292444358,2021,2021M04
Audi,new model,0.4578516206,2020,2020M07
Audi,new model,0.4420692484,2020,2020M08
Audi,new model,0.4341612699,2020,2020M07
Audi,new model,0.4497312328,2021,2021M03
Audi,new model,0.426430249,2021,2021M03
Audi,new model,0.2586455431,2021,2021M03
Audi,new model,0.4201021562,2020,2020M07
Audi,new model,0.2896237784,2020,2020M07
Audi,new model,0.461992976,2021,2021M01
Audi,new model,0.4036174664,2020,2020M06
Audi,new model,0.4219803135,2021,2021M02
Audi,new model,0.448492336,2020,2020M08
Audi,new model,0.4431271316,2020,2020M01
Audi,new model,0.3605441877,2020,2020M06
Audi,new model,0.4194893337,2020,2020M12
Audi,new model,0.4006869172,2021,2021M04
Audi,new model,0.4436633293,2020,2020M08
Audi,new model,0.4660027179,2020,2020M02
Audi,new model,0.5736645935,2021,2021M03
Audi,new model,0.3782549421,2020,2020M06
Audi,new model,0.4605551444,2021,2021M02
Audi,new model,0.4170491456,2021,2021M02
Audi,new model,0.3685065519,2021,2021M01
Audi,new model,0.4553373615,2021,2021M02
Audi,new model,0.3690096002,2020,2020M01
Audi,new model,0.4200700929,2020,2020M09
Audi,new model,0.4405862729,2020,2020M02
Audi,new model,0.3699559294,2020,2020M08
Audi,new model,0.3955702838,2020,2020M01
Audi,new model,0.3202016263,2020,2020M03
Audi,new model,0.4378197102,2020,2020M08
Audi,new model,0.4655660402,2020,2020M10
Audi,new model,0.4000439135,2020,2020M01
Audi,new model,0.3261109695,2020,2020M06
Audi,new model,0.4178115673,2020,2020M02
Audi,new model,0.3705607165,2020,2020M07
Audi,new model,0.423561766,2021,2021M01
Audi,new model,0.3926493945,2021,2021M03
Audi,new model,0.3919982719,2020,2020M07
Audi,new model,0.4286079305,2020,2020M02
Audi,new model,0.407490451,2020,2020M06
Audi,new model,0.4066792564,2021,2021M03
Audi,new model,0.3610061747,2020,2020M07
Audi,new model,0.4777163901,2020,2020M01
Audi,new model,0.3933427929,2020,2020M05
Audi,new model,0.4427237324,2020,2020M07
Audi,new model,0.4016104853,2020,2020M07
Audi,new model,0.4262875495,2021,2021M02
Audi,new model,0.4530424602,2020,2020M05
Audi,new model,0.4477063544,2021,2021M03
Audi,new model,0.5184659471,2021,2021M01
Audi,new model,0.5113604441,2020,2020M02
Audi,new model,0.4840028788,2020,2020M10
Audi,new model,0.4717727645,2021,2021M01
Audi,new model,0.2783973915,2020,2020M06
Audi,new model,0.4606614084,2020,2020M11
Audi,new model,0.4812981024,2020,2020M06
Audi,new model,0.3959342922,2020,2020M09
Audi,new model,0.4350729544,2021,2021M05
Audi,new model,0.3604246967,2020,2020M01
Audi,new model,0.3192152565,2020,2020M02
Audi,new model,0.5157464243,2020,2020M01
Audi,new model,0.4510005725,2021,2021M02
Audi,new model,0.4236321716,2021,2021M05
Audi,new model,0.4794809375,2021,2021M05
Audi,new model,0.5366502679,2021,2021M04
Audi,new model,0.5473810655,2021,2021M02
Audi,new model,0.3750313036,2021,2021M03
Audi,new model,0.4705641319,2021,2021M01
Audi,new model,0.5308007833,2020,2020M07
Audi,new model,0.5001709515,2020,2020M08
Audi,new model,0.5095660588,2021,2021M06
Audi,new model,0.5529281643,2021,2021M06
Audi,new model,0.4845288812,2021,2021M01
Audi,new model,0.5219491895,2020,2020M08
Audi,new model,0.6058803526,2020,2020M10
Audi,new model,0.5013992847,2021,2021M01
Audi,new model,0.2604483718,2020,2020M08
Audi,new model,0.5042517747,2021,2021M02
Audi,new model,0.380461883,2020,2020M02
Audi,new model,0.4040673689,2020,2020M03
Audi,new model,0.2836973264,2020,2020M03
Audi,new model,0.4564327823,2020,2020M08
Audi,new model,0.3481719099,2021,2021M03
Audi,new model,0.4380310293,2021,2021M01
Audi,new model,0.2776867989,2020,2020M08
Audi,new model,0.3306334678,2020,2020M08
Audi,new model,0.4707950931,2021,2021M02
Audi,new model,0.4974776689,2021,2021M02
Audi,new model,0.5513154991,2021,2021M01
Audi,new model,0.4182166688,2020,2020M12
Audi,new model,0.4119293486,2021,2021M01
Audi,new model,0.3762358255,2021,2021M04
Audi,new model,0.4641662576,2021,2021M04
Audi,new model,0.6065737926,2020,2020M10
Audi,new model,0.5420516241,2021,2021M01
Audi,new model,0.6075307263,2021,2021M04
Audi,new model,0.5364316349,2021,2021M05
Audi,new model,0.5000278072,2021,2021M05
Audi,new model,0.4801890063,2020,2020M11
Audi,new model,0.5166333298,2021,2021M05
Audi,new model,0.5907697959,2020,2020M02
Audi,new model,0.443634029,2021,2021M02
Audi,new model,0.4974452014,2021,2021M06
Audi,new model,0.5021592879,2021,2021M06
Audi,new model,0.5675887026,2021,2021M04
Audi,new model,0.529667119,2021,2021M06
Audi,new model,0.6342612813,2020,2020M01
Audi,new model,0.4425405663,2021,2021M04
Audi,new model,0.4004142733,2021,2021M03
Audi,new model,0.3769447762,2021,2021M01
Audi,new model,0.4108149445,2020,2020M11
Audi,new model,0.3798632406,2020,2020M01
Audi,new model,0.4414899755,2020,2020M07
Audi,new model,0.3015147495,2020,2020M06
Audi,new model,0.4057052168,2021,2021M04
Audi,new model,0.3866099105,2020,2020M10
Audi,new model,0.2427723751,2020,2020M08
Audi,new model,0.5000119115,2020,2020M03
Audi,new model,0.4963621898,2020,2020M03
Audi,new model,0.3179213722,2020,2020M01
Audi,new model,0.6002679006,2021,2021M06
Audi,new model,0.4754224687,2020,2020M06
Audi,new model,0.5597260723,2021,2021M05
Audi,new model,0.5197259926,2020,2020M07
Audi,new model,0.5134073568,2021,2021M01
Audi,new model,0.5280827147,2021,2021M02
Audi,new model,0.501526698,2021,2021M02
Audi,new model,0.4375376966,2021,2021M02
Audi,new model,0.4947415393,2021,2021M03
Audi,new model,0.3384291212,2021,2021M05
Audi,new model,0.5115614134,2020,2020M07
Audi,new model,0.5449765891,2021,2021M02
Audi,new model,0.4652681516,2021,2021M02
Audi,new model,0.4877114867,2020,2020M11
Audi,new model,0.4201465144,2021,2021M03
Audi,new model,0.5036767945,2021,2021M02
Audi,new model,0.5187528723,2020,2020M08
Audi,new model,0.5316012124,2020,2020M07
Audi,new model,0.4184526987,2021,2021M02
Audi,new model,0.5443628492,2021,2021M07
Audi,new model,0.5701760343,2021,2021M04
Audi,new model,0.5429717618,2021,2021M02
Audi,new model,0.466810294,2020,2020M06
Audi,new model,0.4645935075,2021,2021M06
Audi,new model,0.5020786929,2021,2021M04
Audi,new model,0.534392253,2021,2021M07
Audi,new model,0.4219144363,2021,2021M03
Audi,new model,0.5004757154,2021,2021M04
Audi,new model,0.4930746647,2020,2020M11
Audi,new model,0.5130123292,2021,2021M05
Audi,new model,0.5914597137,2021,2021M01
Audi,new model,0.5860617385,2020,2020M03
Audi,new model,0.5120997879,2021,2021M02
Audi,new model,0.5875784392,2021,2021M04
Audi,new model,0.5253981107,2020,2020M08
Audi,new model,0.5005248812,2020,2020M09
Audi,new model,0.519430538,2021,2021M03
Audi,new model,0.5203048552,2021,2021M04
Audi,new model,0.5056563402,2021,2021M05
Audi,new model,0.6135879125,2020,2020M10
Audi,new model,0.4779468961,2021,2021M04
Audi,new model,0.5859393281,2020,2020M07
Audi,new model,0.5799414357,2021,2021M05
Audi,new model,0.5420640184,2021,2021M05
Audi,new model,0.5493499282,2020,2020M12
Audi,new model,0.5391453145,2020,2020M07
Audi,new model,0.5448389898,2021,2021M04
Audi,new model,0.5974609032,2021,2021M04
Audi,new model,0.4833812017,2021,2021M04
Audi,new model,0.3462605807,2020,2020M07
Audi,new model,0.3151113444,2020,2020M12
Audi,new model,0.4821964862,2021,2021M01
Audi,new model,0.4493988521,2021,2021M03
Audi,new model,0.5597565029,2021,2021M05
Audi,new model,0.6164753537,2021,2021M05
Audi,new model,0.496660869,2021,2021M04
Audi,new model,0.5202383656,2021,2021M02
Audi,new model,0.5356709613,2020,2020M12
Audi,new model,0.588078128,2021,2021M07
Audi,new model,0.3759887675,2020,2020M01
Audi,new model,0.4700066601,2020,2020M01
Audi,new model,0.4478585974,2021,2021M01
Audi,new model,0.4025264091,2021,2021M04
Audi,new model,0.2923242456,2020,2020M02
Audi,new model,0.3798079924,2021,2021M02
Audi,new model,0.4975958998,2021,2021M01
Audi,new model,0.4610256891,2021,2021M04
Audi,new model,0.3651076508,2020,2020M02
Audi,new model,0.4789407396,2021,2021M06
Audi,new model,0.5040727872,2021,2021M05
Audi,new model,0.4686048536,2020,2020M12
Audi,new model,0.5331425595,2020,2020M10
Audi,new model,0.5341705188,2021,2021M06
Audi,new model,0.5371035391,2020,2020M11
Audi,new model,0.5516581179,2021,2021M01
Audi,new model,0.5741639502,2021,2021M04
Audi,new model,0.4803163355,2021,2021M05
Audi,new model,0.5591226988,2021,2021M05
Audi,new model,0.4639899331,2021,2021M06
Audi,new model,0.5285031202,2020,2020M08
Audi,new model,0.5036340461,2021,2021M03
Audi,new model,0.5397540578,2021,2021M01
Audi,new model,0.4779813608,2020,2020M07
Audi,new model,0.5319525216,2021,2021M05
Audi,new model,0.4511210951,2021,2021M03
Audi,new model,0.4634381868,2021,2021M04
Audi,new model,0.5156466843,2021,2021M02
Audi,new model,0.5351000397,2021,2021M05
Audi,new model,0.5565944711,2020,2020M07
Audi,new model,0.4343435885,2021,2021M06
Audi,new model,0.5375864984,2021,2021M06
Audi,new model,0.5539701153,2021,2021M06
Audi,new model,0.4802193544,2020,2020M07
Audi,new model,0.5283511113,2020,2020M06
Audi,new model,0.5126456793,2020,2020M06
Audi,new model,0.5251434221,2021,2021M02
Audi,new model,0.5160075117,2020,2020M11
Audi,new model,0.3852308131,2020,2020M12
Audi,new model,0.5267251576,2021,2021M03
Audi,new model,0.5352355159,2021,2021M02
Audi,new model,0.626939141,2021,2021M05
Audi,new model,0.4554379252,2020,2020M11
Audi,new model,0.6161622187,2021,2021M04
Audi,new model,0.4970566041,2020,2020M07
Audi,new model,0.5193676195,2020,2020M08
Audi,new model,0.5370863244,2021,2021M06
Audi,new model,0.5020373876,2021,2021M02
Audi,new model,0.4345914144,2020,2020M08
Audi,new model,0.4061093584,2021,2021M01
Audi,new model,0.4238632853,2020,2020M02
Audi,new model,0.4180281785,2021,2021M02
Audi,new model,0.4231780422,2021,2021M04
Audi,new model,0.3902302346,2020,2020M08
Audi,new model,0.4796019466,2021,2021M01
Audi,new model,0.5243195655,2021,2021M01
Audi,new model,0.4039996527,2020,2020M07
Audi,new model,0.3268504323,2020,2020M07
Audi,new model,0.3812753346,2020,2020M07
Audi,new model,0.3702929019,2020,2020M07
Audi,new model,0.4462932965,2021,2021M05
Audi,new model,0.4578119831,2021,2021M01
Audi,new model,0.4542485148,2021,2021M02
Audi,new model,0.539700871,2020,2020M01
Audi,new model,0.5448046175,2020,2020M02
Audi,new model,0.5776683976,2020,2020M01
Audi,new model,0.5383440774,2021,2021M03
Audi,new model,0.5553709724,2021,2021M05
Audi,new model,0.482765216,2020,2020M06
Audi,new model,0.6124253974,2020,2020M01
Audi,new model,0.5675209041,2021,2021M06
Audi,new model,0.5237134634,2021,2021M04
Audi,new model,0.440405904,2020,2020M12
Audi,new model,0.5545872253,2020,2020M11
Audi,new model,0.480802902,2021,2021M06
Audi,new model,0.5606648312,2021,2021M01
Audi,new model,0.4661571678,2021,2021M02
Audi,new model,0.4941642446,2020,2020M08
Audi,new model,0.4488634934,2021,2021M01
Audi,new model,0.5355422862,2021,2021M05
Audi,new model,0.5612759219,2021,2021M02
Audi,new model,0.4589709791,2020,2020M06
Audi,new model,0.4962386683,2021,2021M06
Audi,new model,0.4589781731,2020,2020M09
Audi,new model,0.6510247813,2020,2020M02
Audi,new model,0.5910179729,2021,2021M06
Audi,new model,0.4262938759,2021,2021M02
Audi,new model,0.5827971268,2021,2021M05
Audi,new model,0.5059962513,2020,2020M08
Audi,new model,0.490814564,2021,2021M02
Audi,new model,0.4491042479,2021,2021M05
Audi,new model,0.4248193738,2021,2021M02
Audi,new model,0.4938534923,2020,2020M11
Audi,new model,0.6090395745,2020,2020M07
Audi,new model,0.4966399468,2021,2021M02
Audi,new model,0.4546794877,2020,2020M09
Audi,new model,0.5815824266,2021,2021M07
Audi,new model,0.4567719715,2020,2020M09
Audi,new model,0.5515881367,2021,2021M04
Audi,new model,0.5379200078,2020,2020M11
Audi,new model,0.4271609643,2021,2021M01
Audi,new model,0.587836431,2020,2020M09
Audi,new model,0.4169764177,2020,2020M11
Audi,new model,0.3789878169,2020,2020M07
Audi,new model,0.4372273719,2020,2020M08
Audi,new model,0.5033151394,2020,2020M01
Audi,new model,0.3645126223,2021,2021M01
Audi,new model,0.3735575634,2020,2020M05
Audi,new model,0.393355719,2020,2020M11
Audi,new model,0.3993239583,2021,2021M03
Audi,new model,0.4344749755,2020,2020M11
Audi,new model,0.393549051,2020,2020M06
Audi,new model,0.4452805128,2020,2020M01
Audi,new model,0.3795143152,2020,2020M01
Audi,new model,0.439801944,2020,2020M02
Audi,new model,0.4182461345,2020,2020M01
Audi,new model,0.5313736691,2020,2020M02
Audi,new model,0.4312746832,2021,2021M01
Audi,new model,0.5043276632,2021,2021M01
Audi,new model,0.4590216191,2020,2020M07
Audi,new model,0.4835133126,2021,2021M02
Audi,new model,0.4394180452,2020,2020M08
Audi,new model,0.4383879382,2020,2020M09
Audi,new model,0.4201318472,2020,2020M12
Audi,new model,0.4314235909,2020,2020M06
Audi,new model,0.4198971304,2020,2020M01
Audi,new model,0.4048478224,2021,2021M02
Audi,new model,0.3208467007,2020,2020M02
Audi,new model,0.3187843212,2020,2020M07
Audi,new model,0.4205605915,2020,2020M08
Audi,new model,0.4287821793,2020,2020M02
Audi,new model,0.4378280197,2020,2020M07
Audi,new model,0.4077231775,2020,2020M01
Audi,new model,0.5334664075,2020,2020M11
Audi,new model,0.5155335012,2020,2020M07
Audi,new model,0.4943498635,2020,2020M06
Audi,new model,0.5323689683,2021,2021M05
Audi,new model,0.5517188474,2020,2020M10
Audi,new model,0.562870928,2021,2021M07
Audi,new model,0.5175762282,2020,2020M11
Audi,new model,0.5119511546,2021,2021M04
Audi,new model,0.5318948506,2021,2021M03
Audi,new model,0.5908956743,2020,2020M06
Audi,new model,0.4465831211,2020,2020M06
Audi,new model,0.4945720032,2020,2020M06
Audi,new model,0.4878463394,2021,2021M04
Audi,new model,0.4738924613,2021,2021M03
Audi,new model,0.5650561947,2020,2020M08
Audi,new model,0.5526039907,2021,2021M02
Audi,new model,0.4931189711,2021,2021M02
Audi,new model,0.5469004423,2021,2021M06
Audi,new model,0.5995126158,2020,2020M10
Audi,new model,0.5369743052,2021,2021M04
Audi,new model,0.5158802169,2021,2021M06
Audi,new model,0.5125152829,2021,2021M03
Audi,new model,0.4991396104,2021,2021M06
Audi,new model,0.4835669442,2021,2021M05
Audi,new model,0.4279436273,2020,2020M08
Audi,new model,0.5887255533,2021,2021M05
Audi,new model,0.5783819129,2020,2020M11
Audi,new model,0.6014853362,2021,2021M03
Audi,new model,0.5057416623,2021,2021M03
Audi,new model,0.5225388886,2021,2021M02
Audi,new model,0.5041993516,2020,2020M12
Audi,new model,0.4649494797,2020,2020M09
Audi,new model,0.4962535449,2021,2021M03
Audi,new model,0.4961328781,2021,2021M04
Audi,new model,0.5714928418,2021,2021M05
Audi,new model,0.5993871673,2021,2021M05
Audi,new model,0.4733847067,2020,2020M07
Audi,new model,0.5071325815,2020,2020M08
Audi,new model,0.4454410998,2020,2020M11
Audi,new model,0.5417097549,2021,2021M03
Audi,new model,0.5206458563,2021,2021M01
Audi,new model,0.49476267,2021,2021M06
Audi,new model,0.5567764267,2021,2021M04
Audi,new model,0.5449019234,2021,2021M06
Audi,new model,0.5481604862,2021,2021M06
Audi,new model,0.5561894532,2021,2021M03
Audi,new model,0.4694215364,2021,2021M06
Audi,new model,0.488097168,2021,2021M02
Audi,new model,0.5073413985,2020,2020M06
Audi,new model,0.4902512773,2021,2021M04
Audi,new model,0.4968690843,2021,2021M03
Audi,new model,0.4945309849,2021,2021M04
Audi,new model,0.5733317882,2020,2020M09
Audi,new model,0.5018497932,2020,2020M10
Audi,new model,0.5007122533,2020,2020M09
Audi,new model,0.5842685072,2021,2021M05
Audi,new model,0.5434243656,2021,2021M01
Audi,new model,0.5338997968,2021,2021M02
Audi,new model,0.5894713906,2021,2021M03
Audi,new model,0.5548791339,2021,2021M05
Audi,new model,0.4572763077,2021,2021M04
Audi,new model,0.5374987231,2020,2020M08
Audi,new model,0.5139454643,2021,2021M04
Audi,new model,0.5063564834,2020,2020M08
Audi,new model,0.5826844946,2020,2020M10
Audi,new model,0.530197741,2020,2020M11
Audi,new model,0.5583432109,2021,2021M03
Audi,new model,0.5989929084,2021,2021M02
Audi,new model,0.5582182506,2021,2021M03
Audi,new model,0.4952934292,2020,2020M07
Audi,new model,0.5643005367,2020,2020M07
Audi,new model,0.5249516373,2021,2021M04
Audi,new model,0.5489236066,2020,2020M08
Audi,new model,0.6237037408,2021,2021M03
Audi,new model,0.6688902113,2021,2021M05
Audi,new model,0.524301882,2020,2020M11
Audi,new model,0.5949435379,2021,2021M04
Audi,new model,0.5367924143,2021,2021M04
Audi,new model,0.4753145367,2020,2020M08
Audi,new model,0.5528862067,2021,2021M01
Audi,new model,0.4586416351,2021,2021M01
Audi,new model,0.5306882569,2021,2021M04
Audi,new model,0.5201739491,2021,2021M06
Audi,new model,0.4826356883,2021,2021M03
Audi,new model,0.5667997488,2021,2021M02
Audi,new model,0.6399534437,2020,2020M10
Audi,new model,0.5501390028,2021,2021M05
Audi,new model,0.5709876713,2021,2021M04
Audi,new model,0.5244384963,2021,2021M06
Audi,new model,0.480150681,2020,2020M07
Audi,new model,0.5036897001,2020,2020M08
Audi,new model,0.5204076747,2020,2020M11
Audi,new model,0.5800309943,2021,2021M01
Audi,new model,0.5108158661,2021,2021M05
Audi,new model,0.4958620347,2021,2021M05
Audi,new model,0.5039480228,2020,2020M09
Audi,new model,0.5430084259,2020,2020M08
Audi,new model,0.5255151075,2020,2020M11
Audi,new model,0.4756250302,2020,2020M06
Audi,new model,0.5277653188,2021,2021M02
Audi,new model,0.5295469913,2021,2021M05
Audi,new model,0.6436328551,2020,2020M08
Audi,new model,0.5070563589,2021,2021M07
Audi,new model,0.4974151563,2021,2021M06
Audi,new model,0.5004903593,2021,2021M01
Audi,new model,0.4959996444,2021,2021M05
Audi,new model,0.4682955258,2020,2020M10
Audi,new model,0.4103855241,2021,2021M02
Audi,new model,0.5528293898,2021,2021M05
Audi,new model,0.4189697208,2021,2021M02
Audi,new model,0.3970858019,2020,2020M06
Audi,new model,0.5077810961,2020,2020M12
Audi,new model,0.4291991013,2021,2021M06
Audi,new model,0.5981677862,2020,2020M08
Audi,new model,0.5237490295,2021,2021M01
Audi,new model,0.554876374,2020,2020M11
Audi,new model,0.5074981326,2021,2021M04
Audi,new model,0.5673140375,2021,2021M01
Audi,new model,0.5260306649,2021,2021M05
Audi,new model,0.4971324666,2020,2020M09
Audi,new model,0.5844301064,2020,2020M10
Audi,new model,0.4050668062,2020,2020M01
Audi,new model,0.3428615966,2021,2021M05
Audi,new model,0.3641350722,2020,2020M07
Audi,new model,0.4284068764,2020,2020M10
Audi,new model,0.4777322983,2021,2021M03
Audi,new model,0.4577051398,2020,2020M07
Audi,new model,0.4507203536,2020,2020M08
Audi,new model,0.3723192739,2021,2021M01
Audi,new model,0.4620568583,2020,2020M09
Audi,new model,0.3649868694,2020,2020M06
Audi,new model,0.3280949459,2021,2021M01
Audi,new model,0.4480988973,2021,2021M04
Audi,new model,0.4232239602,2020,2020M09
Audi,new model,0.4427330049,2021,2021M02
Audi,new model,0.4394136606,2021,2021M03
Audi,new model,0.5095583227,2020,2020M02
Audi,new model,0.443302126,2021,2021M03
Audi,new model,0.42830315,2021,2021M02
Audi,new model,0.3964932083,2021,2021M01
Audi,new model,0.5084164819,2020,2020M07
Audi,new model,0.3633045372,2021,2021M03
Audi,new model,0.4428613623,2020,2020M06
Audi,new model,0.4913343321,2020,2020M07
Audi,new model,0.4425010119,2020,2020M09
Audi,new model,0.4284753744,2021,2021M04
Audi,new model,0.4837317806,2020,2020M11
Audi,new model,0.5978307688,2021,2021M04
Audi,new model,0.5626640956,2021,2021M06
Audi,new model,0.5097767314,2021,2021M06
Audi,new model,0.4906717514,2020,2020M02
Audi,new model,0.5116500083,2021,2021M06
Audi,new model,0.5774444617,2021,2021M01
Audi,new model,0.4707643185,2021,2021M05
Audi,new model,0.5393816684,2021,2021M06
Audi,new model,0.5974232914,2020,2020M09
Audi,new model,0.517658691,2021,2021M05
Audi,new model,0.5297284396,2021,2021M01
Audi,new model,0.5081267768,2021,2021M02
Audi,new model,0.4822716566,2020,2020M08
Audi,new model,0.5117953158,2020,2020M06
Audi,new model,0.4970592702,2021,2021M01
Audi,new model,0.4883372329,2021,2021M04
Audi,new model,0.5356090366,2020,2020M10
Audi,new model,0.5356210984,2020,2020M09
Audi,new model,0.5024145702,2020,2020M06
Audi,new model,0.549754703,2020,2020M08
Audi,new model,0.5557998465,2021,2021M07
Audi,new model,0.5088568343,2021,2021M04
Audi,new model,0.5454416489,2020,2020M01
Audi,new model,0.4107435448,2021,2021M01
Audi,new model,0.5119812798,2020,2020M10
Audi,new model,0.4579573171,2021,2021M06
Audi,new model,0.537214475,2021,2021M04
Audi,new model,0.5102078893,2021,2021M06
Audi,new model,0.5290008948,2020,2020M12
Audi,new model,0.4983736183,2021,2021M06
Audi,new model,0.6348669539,2021,2021M01
Audi,new model,0.6574910709,2020,2020M01
Audi,new model,0.5472846315,2020,2020M10
Audi,new model,0.5229056557,2021,2021M04
Audi,new model,0.5490127931,2021,2021M01
Audi,new model,0.5544349702,2021,2021M02
Audi,new model,0.5494240379,2021,2021M06
Audi,new model,0.7185144604,2020,2020M01
Audi,new model,0.6615202033,2021,2021M05
Audi,new model,0.604883595,2021,2021M02
Audi,new model,0.5037748069,2020,2020M08
Audi,new model,0.5144098899,2020,2020M07
Audi,new model,0.5601785941,2021,2021M06
Audi,new model,0.4502070644,2020,2020M08
Audi,new model,0.5657001864,2021,2021M05
Audi,new model,0.5115088105,2020,2020M06
Audi,new model,0.5249849407,2021,2021M05
Audi,new model,0.5320082064,2020,2020M12
Audi,new model,0.5397225827,2021,2021M02
Audi,new model,0.4510974688,2021,2021M04
Audi,new model,0.5079647687,2020,2020M12
Audi,new model,0.5583742405,2021,2021M04
Audi,new model,0.5811816963,2021,2021M03
Audi,new model,0.5868234706,2021,2021M05
Audi,new model,0.4839951322,2021,2021M04
Audi,new model,0.5118811567,2021,2021M03
Audi,new model,0.4618815458,2020,2020M11
Audi,new model,0.5534906435,2021,2021M05
Audi,new model,0.5233569653,2021,2021M06
Audi,new model,0.4584461588,2021,2021M05
Audi,new model,0.5263457852,2020,2020M02
Audi,new model,0.4356311105,2021,2021M04
Audi,new model,0.5413920411,2020,2020M11
Audi,new model,0.3562678576,2021,2021M03
Audi,new model,0.5021295718,2020,2020M07
Audi,new model,0.4935809,2020,2020M02
Audi,new model,0.5204881084,2021,2021M03
Audi,new model,0.5625073794,2021,2021M05
Audi,new model,0.4484006971,2021,2021M05
Audi,new model,0.5809451524,2021,2021M01
Audi,new model,0.6024951541,2021,2021M06
Audi,new model,0.4380123685,2020,2020M08
Audi,new model,0.4460892414,2021,2021M06
Audi,new model,0.5906586436,2020,2020M10
Audi,new model,0.5792359529,2021,2021M02
Audi,new model,0.5566825642,2020,2020M11
Audi,new model,0.5065909231,2021,2021M06
Audi,new model,0.500046246,2020,2020M07
Audi,new model,0.657015837,2020,2020M03
Audi,new model,0.5113058341,2020,2020M12
Audi,new model,0.5283721723,2021,2021M01
Audi,new model,0.5378649995,2021,2021M01
Audi,new model,0.4947571259,2020,2020M08
Audi,new model,0.4935904776,2021,2021M06
Audi,new model,0.596220517,2020,2020M11
Audi,new model,0.5672339209,2021,2021M03
Audi,new model,0.4248151629,2021,2021M03
Audi,new model,0.5375308146,2021,2021M05
Audi,new model,0.553514942,2020,2020M11
Audi,new model,0.5987286548,2021,2021M02
Audi,new model,0.5251442932,2021,2021M03
Audi,new model,0.5509891733,2021,2021M06
Audi,new model,0.4595696975,2021,2021M04
Audi,new model,0.4591179182,2021,2021M04
Audi,new model,0.5655523152,2021,2021M05
Audi,new model,0.4598571647,2021,2021M03
Audi,new model,0.5097289877,2021,2021M04
Audi,new model,0.5110024474,2021,2021M05
Audi,new model,0.4213603093,2021,2021M06
Audi,new model,0.5536963912,2021,2021M06
Audi,new model,0.6544883036,2020,2020M10
Audi,new model,0.626830693,2021,2021M05
Audi,new model,0.56829817,2021,2021M04
Audi,new model,0.5325657551,2021,2021M06
Audi,new model,0.5028261906,2021,2021M01
Audi,new model,0.5638874218,2020,2020M10
Audi,new model,0.4858149594,2021,2021M01
Audi,new model,0.551629034,2020,2020M10
Audi,new model,0.5488527204,2020,2020M01
Audi,new model,0.5292472388,2021,2021M06
Audi,new model,0.6814319825,2021,2021M06
Audi,new model,0.5907566532,2020,2020M11
Audi,new model,0.4617667139,2020,2020M06
Audi,new model,0.5193416082,2021,2021M03
Audi,new model,0.4905366233,2020,2020M07
Audi,new model,0.5637873914,2021,2021M06
Audi,new model,0.5718647754,2020,2020M05
Audi,new model,0.5169342491,2021,2021M02
Audi,new model,0.5511645534,2021,2021M03
Audi,new model,0.6463689606,2021,2021M06
Audi,new model,0.5010376215,2021,2021M04
Audi,new model,0.5893152287,2021,2021M03
Audi,new model,0.5707548558,2021,2021M02
Audi,new model,0.5342791634,2021,2021M01
Audi,new model,0.4490304381,2021,2021M01
Audi,new model,0.5280650516,2020,2020M11
Audi,new model,0.5242289423,2021,2021M02
Audi,new model,0.5575063004,2021,2021M04
Audi,new model,0.469941501,2021,2021M06
Audi,new model,0.4573314472,2021,2021M05
Audi,new model,0.5548751916,2021,2021M02
Audi,new model,0.5179690116,2021,2021M05
Audi,new model,0.5144363122,2021,2021M02
Audi,new model,0.5351468277,2021,2021M03
Audi,new model,0.5495884598,2021,2021M06
Audi,new model,0.4260033738,2021,2021M01
Audi,new model,0.4373912269,2021,2021M04
Audi,new model,0.281693723,2021,2021M02
Audi,new model,0.3997015591,2020,2020M10
Audi,new model,0.4483761267,2021,2021M04
Audi,new model,0.3573191765,2020,2020M08
Audi,new model,0.4007871524,2021,2021M02
Audi,new model,0.4099928244,2020,2020M02
Audi,new model,0.4812969892,2021,2021M06
Audi,new model,0.3900023858,2020,2020M02
Audi,new model,0.3898991135,2021,2021M06
Audi,new model,0.421806467,2021,2021M05
Audi,new model,0.4626854517,2021,2021M01
Audi,new model,0.4359595163,2021,2021M01
Audi,new model,0.4802107611,2020,2020M10
Audi,new model,0.4397309197,2020,2020M06
Audi,new model,0.4005760164,2020,2020M08
Audi,new model,0.444304582,2020,2020M11
Audi,new model,0.5367296555,2020,2020M10
Audi,new model,0.4310456165,2021,2021M06
Audi,new model,0.6347768934,2020,2020M02
Audi,new model,0.5415375188,2021,2021M02
Audi,new model,0.4651582015,2020,2020M06
Audi,new model,0.4952786606,2020,2020M07
Audi,new model,0.5498392368,2020,2020M09
Audi,new model,0.5463831714,2020,2020M10
Audi,new model,0.4976546303,2020,2020M10
Audi,new model,0.5421327511,2020,2020M06
Audi,new model,0.5352828004,2020,2020M05
Audi,new model,0.3777547506,2021,2021M04
Audi,new model,0.481715902,2020,2020M06
Audi,new model,0.4862957896,2020,2020M11
Audi,new model,0.5281843166,2021,2021M04
Audi,new model,0.5113608322,2020,2020M08
Audi,new model,0.5540694894,2020,2020M09
Audi,new model,0.5239922031,2021,2021M03
Audi,new model,0.5578148606,2020,2020M11
Audi,new model,0.53415039,2021,2021M04
Audi,new model,0.5603586031,2021,2021M04
Audi,new model,0.5308626227,2020,2020M07
Audi,new model,0.5966156587,2020,2020M01
Audi,new model,0.3613186156,2020,2020M01
Audi,new model,0.4314910212,2020,2020M07
Audi,new model,0.3823287694,2020,2020M06
Audi,new model,0.3971209914,2020,2020M05
Audi,new model,0.5167402513,2020,2020M01
Audi,new model,0.5280211317,2020,2020M07
Audi,new model,0.4923358045,2020,2020M07
Audi,new model,0.5926378899,2020,2020M01
;;;;
run;


data risknoba.oks;
do n=1 by 1 until(last._fecha_venta);
set risknoba.tt;
by _gama _year _fecha_venta;
frek=n;
saly=sum(saly, sales_res);
end;

do until(last._fecha_venta);
set risknoba.tt;
format sales_avg percent9.1;
by _gama _year _fecha_venta;
sales_avg=saly/n;
if first._year then acum=.;
acum+n/n;
end;

run;

data RISKNOBA.OKS2(promote=yes);
do n=1 by 1 until(last._year);
set RISKNOBA.OKS;
by _year _fecha_venta;
ytd_fyr=acum;
end;

do n=1 by 1 until(last._year);
set RISKNOBA.OKS;
format fecha_venta monyy.;
by _year _fecha_venta;
val_bubble=.;
val_series=.;
if last._year and _year="2021" then des_bubble=catx(" ", "Current Total:", put(ytd_fyr, 6.));
if last._year and _year="2020" then des_series=catx(" ", "Total Last Year:", put(ytd_fyr, 6.));
if last._year and _year="2021" then val_bubble=ytd_fyr;
if _year="2020" then val_series=ytd_fyr;
fecha_venta=input(_fecha_venta, ANYDTDTE7.);
val_line1=.;
val_line2=.;
if _year="2020" then val_line1=acum;
if _year="2021" then val_line2=acum;
output;
end;
run;

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

You need to explain more about what you are trying to do.   It would probably also help to provide more focused example set of data that makes it easier to visualize what you are trying to calculate.  There are some issues with the posted code, for example the sample data is not sorted the way the code need and the second step is using different BY variables than the first loop. 

 

But let's ignore that until you have explained what you are trying to do and concentrate on exploring the form of what it looks like you want to do.  So your first step is aggregating at one level and then your second step is aggregating at another. 

 

So if you have 4 key variables (ABCD) that uniquely identify the data then perhaps want you are saying is you want to calculate something at the ABC level (D is then just for making sure the duplicates are processed in the right order) and then calculate something else at the AB level.

 

So in that case you need to nest the DO loops.  The two main DO loops will use LAST.B and then (if needed) the inner loops with use the LAST.C.

 

For example let's do a simple case.  Say all you want at the AB (highest) level is the overall N.  So then the beginning of your step is just this:

data want;
  do n=1 by 1 until(last.b);
     set have;
     by a b c d ;
  end;
  put a= b= n= ;

Now you need to add another DO loop to process all of the observations for that level of A and B.  Now if you want to again use double dow method to calculate something at the ABC level that you can apply to the ABCD level observations just add those DO loops into the second loop.

  do until(last.b);
     do until(last.c);
       set have;
       by a b c d ;
       ...
    end;
     ...
     do until(last.c);
       set have;
       by a b c d ;
       ...
    end;
    ...
  end;
run;

Places the OUTPUT statement at the level you want to write.  If you want to re-write the same number of observations then place it in that last inner most DO loop.  Or at the ABC level then after that loop and inside the outer do loop.  Or if the AB level then at the end (or just leave out the OUTPUT statement and SAS will automatically output at the end of the iteration).

View solution in original post

5 REPLIES 5
ballardw
Super User

In response to :"Why does the acum var which accumulates one year's observations need to divide by n to get the right result?".

The variable created  in this code:

sales_avg=saly/n;

is an average or arithmetic mean. Which means the total divided by the number of values. Pretty much a definition.

Other uses would use other operations

jimbarbour
Meteorite | Level 14

Well, first, this is very complicated, and it will take a person quite a while to try to understand what you are doing, at least it would for me.  Perhaps you could explain the code a bit more.

 

Second, an observation:  I'm sure you already know this, but you're going to need a Sort for this to work.  The data is not in BY order.

 

Proc	SORT	DATA=WORK.TT;
	by _gama _year _fecha_venta;
RUN;

 

 

Third:  In your code you have n/n.  N/n will always be 1.  If you want 1, you should probably just use 1 which will be easier to understand.

 

acum+n/n;

 

 

I wonder if you meant this:

(acum+n)/n;

 

Lastly, what is your definition of the DoW technique?  A quick Google search comes up with the below.  Is this what you mean?

What Is the Dow Theory?

The Dow theory is a financial theory that says the market is in an upward trend if one of its averages (i.e. industrials or transportation) advances above a previous important high and is accompanied or followed by a similar advance in the other average. For example, if the Dow Jones Industrial Average (DJIA) climbs to an intermediate high, the Dow Jones Transportation Average (DJTA) is expected to follow suit within a reasonable period of time.

 

Jim

 

Cynthia_sas
SAS Super FREQ
Here's a paper about Ian Whitlocks "DoW" loop: https://support.sas.com/resources/papers/proceedings12/052-2012.pdf ... This is not the type of construct I would recommend for the beginner. It's not documented except in papers and it's not a supported use of the Do Loop.

Cynthia
jimbarbour
Meteorite | Level 14

Ah, thank you @Cynthia_sas.  It sounded familiar, but I couldn't quite place it.

 

Yes, hardly a simple technique.

 

Jim

Tom
Super User Tom
Super User

You need to explain more about what you are trying to do.   It would probably also help to provide more focused example set of data that makes it easier to visualize what you are trying to calculate.  There are some issues with the posted code, for example the sample data is not sorted the way the code need and the second step is using different BY variables than the first loop. 

 

But let's ignore that until you have explained what you are trying to do and concentrate on exploring the form of what it looks like you want to do.  So your first step is aggregating at one level and then your second step is aggregating at another. 

 

So if you have 4 key variables (ABCD) that uniquely identify the data then perhaps want you are saying is you want to calculate something at the ABC level (D is then just for making sure the duplicates are processed in the right order) and then calculate something else at the AB level.

 

So in that case you need to nest the DO loops.  The two main DO loops will use LAST.B and then (if needed) the inner loops with use the LAST.C.

 

For example let's do a simple case.  Say all you want at the AB (highest) level is the overall N.  So then the beginning of your step is just this:

data want;
  do n=1 by 1 until(last.b);
     set have;
     by a b c d ;
  end;
  put a= b= n= ;

Now you need to add another DO loop to process all of the observations for that level of A and B.  Now if you want to again use double dow method to calculate something at the ABC level that you can apply to the ABCD level observations just add those DO loops into the second loop.

  do until(last.b);
     do until(last.c);
       set have;
       by a b c d ;
       ...
    end;
     ...
     do until(last.c);
       set have;
       by a b c d ;
       ...
    end;
    ...
  end;
run;

Places the OUTPUT statement at the level you want to write.  If you want to re-write the same number of observations then place it in that last inner most DO loop.  Or at the ABC level then after that loop and inside the outer do loop.  Or if the AB level then at the end (or just leave out the OUTPUT statement and SAS will automatically output at the end of the iteration).

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 616 views
  • 3 likes
  • 5 in conversation