Hi KurtBremser
Below is the example of the output i want, i have added a new column slope. This is supposed to help me know customers whose revenues have fallen during the 21 days of use.
Thank you
Anthony
data have; infile cards dlm=',' truncover; input msisdn :$12. rev1-rev21 slope; cards; 256312101087,0,,,,,,,,,,,,,,0,,,,,,,0 256312106571,,,,,,,,,,,,,,,,,,,,,,0 256312107758,,0,,,,,,,0,,,,,,,,,,,,,0 256312109190,,,,,,,,,,,,,,,0,,,,,,0,0 256312109409,,,,,,,,0,,,,,,,,,,,,,,0 256312109658,,,,,,,,,,0,,,,,,,,,,,,0 256312109862,,,,,,,,,,,,,,,,,0,,,,,0 256312110324,,,,,,,,,,,,,,0,,,,,,,,0 256312110608,,,,,,0,,,,,,,,,,,,,,,,0 256312111220,,,,,,0,,,,,,,,,,,,,,,0,0 256312114890,,,,,,,,,,,,,,,,,,,,,0,0 256312165100,3240,4320,2700,2640,,2340,2340,1800,2160,1620,1320,,1800,,,,,,,,,0 256312165101,180,,1800,1440,540,,4320,1260,3060,3300,,960,2700,1980,2160,,2880,,180,2340,360,-0.23 256312165102,,2160,720,,3240,,,,,,,,,360,360,,900,,,,,-0.23 256312165104,360,1800,,1260,,540,1260,,360,3600,,,180,180,1260,,,,,,,-0.23 256312165109,720,5040,1260,180,,5580,9360,4500,3060,7080,540,840,1260,1800,720,360,1260,1680,,3600,5400,-0.23 256312165110,4860,2880,4860,480,,1260,,,,,,,,,,,,,,,,-0.23 256312165111,5760,360,1440,,,1980,3960,3780,7920,,,,7380,5940,7020,,4320,,,3420,7560,-0.23 256312165112,,1620,540,,,1080,1080,,900,720,,,,3600,180,,900,,,,1980,-0.23 256312165114,1440,180,360,,,,,,,,,120,180,1800,1620,,720,,120,180,540,-0.23 256312165123,180,180,,,,180,720,,180,900,,,2700,,2880,,1800,660,,900,360,-0.23 256312165127,2520,900,180,,,1800,360,1260,5400,3600,,240,5580,1440,540,,1440,,,1980,3420,-0.23 256312165133,1080,,,,,5760,,,360,,,,,,3960,,360,,,360,,-0.23 256312165144,,,360,,360,,,,,,,,,540,180,,2040,,,180,540,-0.23 256312165148,1260,,180,,,1620,3060,900,3600,2700,,,1440,5400,6480,,2160,,,5040,3060,-0.23 256312165500,36502,21420,18000,900,,23760,24300,13500,17640,22680,,1620,17640,28620,30383.5,,12060,1200,,16020,27720,-0.23 256312165650,12420,17640,11231.5,,,23538,8100,4320,13511,4680,,,9720,7920,20707.5,,4140,,,8460,9568.5,-0.23 256312202029,,360,900,720,,7920,1620,540,540,1800,,,3600,180,180,,180,360,,,,-0.23 256312202218,,,,,,,,1080,,,,,,180,,,,,,1440,540,-0.23 256312222111,2160,900,720,540,6835,900,360,180,1620,3090,2640,5144.5,2160,2520,,,,,,,,-0.23 256312225900,3600,6120,8820,,,,,,,,,,,,,,,,86,,,-0.23 256312253500,360,1620,180,,,1260,10080,180,1080,,360,,,1800,540,1440,,,,180,360,-0.23 256312253800,1980,180,2160,2640,,180,360,,900,3900,900,,180,2340,1080,1800,540,540,,1268,540,-0.23 256312253801,3960,1980,2700,1020,,4140,5040,1620,1980,900,1260,,3600,1620,4860,180,900,6900,,5040,4140,-0.23 256312253802,5338,1800,720,,,7398,1800,,3960,360,180,,1080,2160,1620,,360,1800,,900,5983,-0.23 256312253803,540,,720,120,,2880,1800,360,1080,540,,,5400,900,3060,,,,,360,,-0.23 256312253804,3600,1260,,,,,,,,180,,,,180,1260,,3960,,,,180,-0.23 256312253805,,5040,1800,,,,720,,,,,,,720,,,,,,,,-0.23 256312253807,,,,,,,,,,,,,180,2520,2520,,18913,,,180,10061,-0.23 256312253808,540,,1260,,,3420,720,360,180,360,,,4500,1260,360,,180,480,,,540,-0.23 256312253809,,,,,,,,1080,1620,,,,,1800,540,,540,,,,1080,-0.23 256312253810,4140,6300,2520,,,,360,900,6300,1620,2940,,2340,180,2340,,2340,480,,3420,1800,-0.23 256312253811,,720,1800,,,1620,1800,5040,7560,5760,,,5040,2880,8460,,1800,,,2700,4500,-0.23 256312253812,3600,7083.5,1620,3180,,,3960,4006,3600,1980,420,,3960,6660,2880,900,,,,6120,1620,-0.23 256312253813,,,,,,180,,,,,,,,,1440,,,,,,,-0.23 256312253814,5220,4320,1260,1620,,5760,4140,1080,1620,3600,1260,,3960,540,4500,,1620,,,2700,4860,-0.23 256312253815,,,,,,10980,8100,540,,,,,,3420,3420,,3600,,,4860,5940,-0.23 256312253816,1800,7020,4680,,,1800,,360,720,,,,900,,,,,,,720,540,-0.23 256312253817,8100,7380,1020,,,5760,6480,1080,,,,,,,1620,720,2880,,,180,1260,-0.23 256312264035,5760,1980,540,,,4680,18000,6120,3060,9360,,,6120,4320,6300,,13860,1980,,29852,16920,-0.23 256312264036,1620,2160,4860,,,7740,5760,8820,3060,1980,360,,7560,5760,8820,,6660,180,,1620,0,-0.23 256312265744,,,0,,,,,0,,,,,,,,,,,,,,-0.23 256312271382,7740,9000,6660,480,,7740,3780,,,,,,,,,,,,,,,-0.23 256312271391,1440,4140,2340,300,,540,720,720,360,1440,,,1800,2160,1800,,180,,,1800,1260,-0.23 256312280959,,,,,,,,,,,,,0,,,,,,,,,-0.23 256312283211,,,,,,,,,,,,,,,,,,,,,0,-0.23 256312283570,,,,,,,0,,,,,,,,,,,,,,,-0.23 256312289210,0,,,,,,,,,,,,,,,,,,,,,-0.23 256312292336,0,,,,,,,,,,,,0,0,,,,,,,,-0.23 256312307100,46800,55276.5,28594,18746,8460,48960,42118,38880,47520,37310.5,8280,12360,52920,38700,41744,22002,42540,13260,25024,41040,,-0.23 256312307605,540,,,,,,,,,,,,,,,,,,,,,-0.23 256312307607,360,,,,,360,180,180,,900,,,,,,,,,,,,-0.23 256312307609,540,720,,,,,1440,,,,,,,,,,,,,,,-0.23 256312307610,1620,3060,180,,,720,4860,720,5940,2520,,,,,,,,,,,,-0.23 256312307613,,1080,,,,2340,720,2340,720,,,,,,,,,,,,,-0.23 256312307614,3240,11700,2520,,,4500,,,,,,,,,,,,,,,,-0.23 256312307615,540,,,,,,,,,,,,,,,,,,,,,-0.23 256312307618,1287,,,,,,,,180,,,,,,,,,,,,,-0.23 256312307620,540,,180,,,,1620,,,,,,,,,,,,,,,-0.23 256312307624,3060,1080,4860,,,2340,360,180,,,,,,,,,,,,,,-0.23 256312307625,4177.5,1620,,,,1620,2500,1620,2160,,,,,,,,,,,,,-0.23 256312307633,1260,900,,1860,,2520,,1980,360,,,,,,,,,,,,,-0.23 256312310700,4320,2700,3240,,,,540,3420,4140,0,,,1260,4100,1620,,1440,,,5940,1980,-0.23 256312310701,,,,,,,1620,,,,,,,,,,,,,,,-0.23 256312310702,,,720,,,,1620,,,,,,,,,,,,,,,-0.23 256312310703,,,,,,,,,,,,,540,,,,,60,,,,-0.23 256312310704,,,,,,,,,,,,,,,,,,,,0,,-0.23 256312310705,1080,,3060,,,5400,2880,4860,1440,1620,,,1080,5220,3420,,4500,,,1800,360,-0.23 256312310707,360,360,,,,,360,3780,1260,,,,720,540,2160,,13320,,,5580,1440,-0.23 256312310708,,180,2160,,,,720,3420,360,,,,540,360,,,180,,,1080,720,-0.23 256312310709,,,,,,,,,3240,900,,,5040,,,,,,,2700,2340,-0.23 256312310710,2873.5,,,,,,180,3960,,1402.5,,,,,,,,,,,,-0.23 256312310711,,,,,,,,,,,,,,,180,,1848,,,,,-0.23 256312310712,1260,2520,2520,60,,1080,,1260,,360,,,1620,180,900,,1260,,,1080,1800,-0.23 256312310713,,3780,1080,,,,,,,,,,,180,,,,,,,180,-0.23 256312310714,1260,,8460,,,,486.5,,,2160,,,,720,,,5040,,,5220,1800,-0.23 256312310715,,,,,,,,,,,,,,0,,,,,,0,,-0.23 256312310716,7740,,,,,,,,,,,,,,,,,,,,,-0.23 256312310717,1080,3960,1380,60,,720,720,3600,1260,900,1380,,3600,5040,720,,1440,60,,7200,2700,-0.23 256312310718,,,,,,,,,,,,,1800,,360,,900,,,2340,1260,-0.23 256312310719,,,360,,,540,,,540,,,,,180,,,,,,1440,,-0.23 256312310720,,,,,,540,360,180,,360,,,,,,,,,,2700,1800,-0.23 256312310721,,,,,,,,,,,,,,,,,,,,,360,-0.23 256312310722,1800,360,720,,,8520,180,1980,1620,180,,,900,180,,900,,660,,360,540,-0.23 256312310728,,,,,,,0,,,,,,,,,,,,,,0,-0.23 256312320600,4680,4860,13500,1800,,8540,2160,900,10620,3240,,,12600,1080,5580,,2160,540,,9820,4680,-0.23 256312370157,1800,540,1260,,,,1260,1080,1620,2360,,,1980,1800,540,,1980,,,1440,1620,-0.23 256312372008,1440,540,,,,,,,,,,,,,540,,900,,,540,720,-0.23 256312372751,8640,11880,,,,2520,1620,4320,,,,,,360,3600,,2340,,,4860,900,-0.23 256312372756,,900,,,,900,3960,5940,1440,180,,,540,540,1080,,1800,,,8460,1980,-0.23 256312374156,180,720,,,,,2160,360,,,,,,,,,,,,,,-0.23 256312393800,900,,5040,,,,5940,5040,,,,,,,,,,,,,,-0.23 256312393801,,,,,,,,,180,1164,,,,,,,540,,,180,,-0.23 256312393803,540,4320,5400,,,2700,,2340,,720,,,2880,1800,4320,,360,,,3420,1080,-0.23 256312393808,,2880,,,,720,,1620,1080,1980,,,360,4320,,,1800,,,3240,1980,-0.23 256312393809,540,540,180,,,180,,540,5040,7740,,,2160,3581.5,3662,,2520,,,540,2700,-0.23 256312393810,180,6480,1800,,,5400,,,540,,,,,,,,,,,,,-0.23 256312393813,,540,900,,,,,,3600,3060,,,1620,3060,,,1080,,,720,540,-0.23 256312393814,1260,2700,540,,,1260,1440,,,2520,,3060,3060,7560,,,,,,,,-0.23 256312393815,540,720,720,,,,,,,1620,,,,,,,,,,,1080,-0.23 256312393817,7020,2160,,,,360,900,,360,3600,240,,,15566.5,,,12600,,,4680,3960,-0.23 256312393818,,,,,,,2160,,,,,,,,,,,,,720,,-0.23 256312393819,1800,1440,360,,,2520,2520,2700,1620,1440,,,1440,540,720,,,,,1440,1800,-0.23 256312393820,360,1800,180,,,360,1260,360,1800,360,,,360,540,900,,,,,2340,180,-0.23 256312393821,3060,,900,,,1800,1980,540,2160,1260,,,4320,1980,2880,,720,,,1260,3780,-0.23 256312393822,900,4500,1680,,,1440,360,180,180,3780,840,,1260,900,5760,,2880,,,1080,1620,-0.23 256312393823,6480,1260,3024,,,3600,360,,,,,,,,,,,,,,,-0.23 256312393900,2160,7200,2880,1860,,4320,3600,3420,1080,3600,300,,3420,2102,,,,,,3600,360,-0.23 256312514764,,,,,,,,,,0,,,,0,,,,,,,,-0.23 256312515100,,,,,,,,,,,,,,,,,,,,,0,-0.23 256312515262,,,,,,,,,,,,,0,,,,,,,,,-0.23 256312516903,,,,,,0,0,,,,,,,,,,,,,,,-0.23 256312517064,,,,,,,,,,,,,0,,,,,,,,,0.45 256312517179,0,,,,,,,,,,,,,,,,,,,,,0.45 256312532532,,5220,2340,,,3060,4500,3960,3960,5040,2220,3840,2880,8460,3960,7740,12840,8340,9600,5400,5760,0.45 256322200137,1980,180,,5040,,20948,1800,900,540,5580,,,1800,,360,,3780,,,1260,900,0.45 256322200241,5121.9,,1317.06,,,1317.06,10975.5,4975.56,,3658.5,,,1170.72,878.04,1756.08,2780.46,,,,731.7,6219.24,0.45 256322200242,,,,,,585.36,1609.74,3512.16,3073.14,6585.3,,,5560.92,585.36,,439.02,,,,2634.12,439.02,0.45 256322200243,,3146.1,2780.46,97.56,,585.36,1170.72,,439.02,,,97.56,439.02,2341.44,3365.82,,,,,1170.72,585.36,0.45 256322200546,,,,,,,,,,,,,,,,,,60,1791,3420,,0.45 256322200857,,,,,,,,,,0,,,0,,,,,,,,,0.45 256322201100,13140,12240,11160,,,11700,10440,13860,15171,5400,,,13140,11700,7020,,10980,,,10620,,0.45 256322201103,20160,10800,24402,,,13320,1800,12960,7584,1440,,,11571,14580,6480,,11700,,,23940,15300,0.45 256322201244,,,180,,,180,,,,,,,,,,,,,,,,0.45 256322201313,,,180,,,,180,,2520,,,,360,3420,540,,,,,2584,,0.45 256322203151,,,,,,,,,,,,,,,,180,,,,,,0.45 256322203866,,180,,,,180,1800,180,1620,,,,,,2160,,360,,,180,360,0.45 256322315500,360,,,,,,,,,,,,,400,,,,,,,,-0.23 256322400003,3420,,180,,240,,,,2152,,360,,,,,,,,,,,-0.23 256322400004,,100,,,,,,,,0,,,,,,,,,,,,-0.23 256322400019,,,540,,,,,100,2340,,,,900,,,,1580,3360,,,,-0.23 256322400020,,,,,540,,,,,,780,1920,,,,,,4371,2820,,,-0.23 256322400021,180,5760,1800,2400,,3060,3060,,4140,,780,,2340,1980,2340,1260,180,,2580,2160,1440,-0.23 256322400025,,,,,,,,,3240,,360,1920,1440,6120,2700,,,1980,540,10800,1800,-0.23 256322400027,9460,14040,28520,14880,420,8640,26820,4860,,4680,9900,3840,10260,17820,,9900,5040,7500,780,24120,7920,-0.23 256322400028,5940,,10260,900,,9411,19440,1980,5220,,300,9060,2700,,13500,5940,8460,4620,,3420,4900,-0.23 256322400029,180,1520,360,300,,,360,,,15171,,115.5,,3665,,,6840,120,,180,,-0.23 256322400030,,,540,,,6570,720,,,360,,540,900,1260,180,3521.5,3160,,,,,-0.23 256322400032,,,,,,,,,,,3420,2400,,,,,,420,300,1800,3420,-0.23 256322400049,,,,,,,,360,,,,,,,,,,,,,,-0.23 256322400051,,,,60,,1080,,540,,,540,120,,,,1080,,,,540,,-0.23 256322400056,540,1865,,3500,1131,2700,900,,900,1260,900,0,5400,1180,6840,2880,2520,,4140,3240,2160,-0.23 256322400061,7920,540,180,965,600,180,,,0,,600,2765,5502,3260,2520,2880,3060,1860,2640,1820,2620,-0.23 256322400079,,,,,,,,,,,,,,,,,1180,,,,,-0.23 256322400085,360,100,1080,660,385,180,0,640,0,,1680,0,100,1200,1980,2700,1440,1260,900,720,180,-0.23 256322400086,3960,0,4680,2040,4920,2340,900,720,1080,1260,1800,420,8820,,1800,,540,120,5340,3240,180,-0.23 256322400097,720,1260,360,4320,4630,4270,4090,900,1260,3780,2040,6080,6480,720,540,1080,180,1860,1080,720,540,-0.23 256322400105,900,1080,6840,300,2760,2880,540,180,2880,2880,1080,2650,3780,4191,1800,,,60,,,,-0.23 256322400112,100,,,,,,,,,1180,60,300,,,,1260,,,,5040,1620,-0.23 256322400117,1080,2700,3060,,2460,,180,,180,3600,,,,,,180,7560,,,,,-0.23 256322400118,,,,,,,,,,,,,,,,,,,,,180,-0.23 256322400122,,0,0,,,,,,,360,180,540,5760,0,720,,2700,,1140,,,-0.23 256322400128,0,3060,2160,540,480,720,3060,3240,,2640,1200,3780,2340,640,2520,1620,4140,1020,3120,1440,3060,-0.23 256322400141,1440,720,6925,3240,1920,1260,3780,2520,3370,,605,60,1080,4320,360,360,1685,1020,2220,2520,3060,0.34 256322400143,2340,1620,,,1320,1980,,,,,,420,1440,,,,,,240,8640,3240,0.34 256322400148,1800,4680,1080,1620,1740,1080,1440,1080,7200,2660,5160,1740,,2140,,5760,5285,8400,,,2700,0.34 256322400150,4860,1800,2520,420,1860,1620,1260,900,,540,120,1800,,,900,,1260,300,2340,180,,0.34 256322400163,,,,0,540,0,3780,720,,,,60,900,,1620,,360,,240,3600,,0.34 256322400168,,,,3180,,1180,,,,,3120,,,,,,,5585,,,,0.34 256322400174,,,0,180,,,,,,,,,,,,,,,,,,0.34 256322400177,17380,30780,5580,1500,780,0,3240,9360,6531,5220,1560,4380,1980,7380,4860,3240,7020,8100,6240,2700,4500,0.34 256322400192,,2340,6120,2820,,5580,,9180,,3240,1320,1800,10440,2700,14760,,7920,480,2580,2520,,0.34 256322400194,,,,120,180,360,360,1851,,1260,180,120,,,180,,540,120,,,180,0.34 256322400195,,180,2160,4500,3660,7200,10440,540,,1800,1740,4080,9900,12780,1080,3780,0,1740,3000,8100,1440,0.34 256322400209,180,180,1000,,,360,,490,,,245,840,,17460,540,,,,,,1080,0.34 256322400210,,540,180,4980,7200,900,540,360,540,0,6240,9420,1440,1980,1440,1080,3960,3660,6180,,900,0.34 256322400216,1800,3600,720,1020,,900,3060,,720,,240,300,360,6300,2520,1980,2160,960,120,,180,0.34 256322400218,,,,240,,180,0,,,0,0,420,,,540,,,60,300,,540,0.34 256322400219,1440,900,1620,,3960,,,900,,1080,780,,,,1800,1440,0,1020,,1080,900,0.34 256322400221,2700,540,2520,2700,2220,5760,3240,3240,720,4320,6120,0,5400,7200,900,5220,1260,6360,4620,6300,8640,0.34 256322400226,180,180,1080,120,,,,,,,1140,,,360,180,,360,,,,180,0.34 256322400228,,0,,1260,1500,,,180,,,1860,960,,,1260,540,,720,1980,,,0.34 256322400230,5220,,,,,,,,180,900,4260,4260,4860,720,,180,1620,,,5760,3420,0.34 256322400232,540,13140,,120,,,,900,8820,,360,2280,0,,0,3305,,0,,,,0.34 run;
... View more
