Programming the statistical procedures from SAS

getting the rate of change by each observation for a number months

Reply
Occasional Contributor
Posts: 8

getting the rate of change by each observation for a number months

Dear Members,

 

I have revenues for customers for over 12 months, customers are about 9 millions, customers are not active thoughout the 12 months, so some months have revenues missing (.) for some customers. There have been a general revenue fall trend over the 12 months and I would want to get an indicator for each customer showing a fall and its rate. this indicator will help classify customers into 1. Revenue have decreases, 2=Revenues have stayed constant, 3=Revenues have grown.

 

This will help me study customers,  study customers whose revenues have fallen will help me understand the reasons.

 

Thank you for your help

 

Toni

Esteemed Advisor
Posts: 6,270

Re: getting the rate of change by each observation for a number months

Please provide some example data in a data step, so we have something to play around with. Just enough to illustrate your issue(s).

And a fitting example of the expected results

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 8

Re: getting the rate of change by each observation for a number months

Dear 

 

Here data is attached

 

Toni

Attachment
Esteemed Advisor
Posts: 6,270

Re: getting the rate of change by each observation for a number months

First of all, THIS is how you provide data in a data step:

data have;
infile cards dlm=',' truncover;
input msisdn :$12. rev1-rev21;
cards;
256312101087,0,,,,,,,,,,,,,,0,,,,,,
256312106571,,,,,,,,,,,,,,,,,,,,,
256312107758,,0,,,,,,,0,,,,,,,,,,,,
256312109190,,,,,,,,,,,,,,,0,,,,,,0
256312109409,,,,,,,,0,,,,,,,,,,,,,
256312109658,,,,,,,,,,0,,,,,,,,,,,
256312109862,,,,,,,,,,,,,,,,,0,,,,
256312110324,,,,,,,,,,,,,,0,,,,,,,
256312110608,,,,,,0,,,,,,,,,,,,,,,
256312111220,,,,,,0,,,,,,,,,,,,,,,0
256312114890,,,,,,,,,,,,,,,,,,,,,0
256312165100,3240,4320,2700,2640,,2340,2340,1800,2160,1620,1320,,1800,,,,,,,,
256312165101,180,,1800,1440,540,,4320,1260,3060,3300,,960,2700,1980,2160,,2880,,180,2340,360
256312165102,,2160,720,,3240,,,,,,,,,360,360,,900,,,,
256312165104,360,1800,,1260,,540,1260,,360,3600,,,180,180,1260,,,,,,
256312165109,720,5040,1260,180,,5580,9360,4500,3060,7080,540,840,1260,1800,720,360,1260,1680,,3600,5400
256312165110,4860,2880,4860,480,,1260,,,,,,,,,,,,,,,
256312165111,5760,360,1440,,,1980,3960,3780,7920,,,,7380,5940,7020,,4320,,,3420,7560
256312165112,,1620,540,,,1080,1080,,900,720,,,,3600,180,,900,,,,1980
256312165114,1440,180,360,,,,,,,,,120,180,1800,1620,,720,,120,180,540
256312165123,180,180,,,,180,720,,180,900,,,2700,,2880,,1800,660,,900,360
256312165127,2520,900,180,,,1800,360,1260,5400,3600,,240,5580,1440,540,,1440,,,1980,3420
256312165133,1080,,,,,5760,,,360,,,,,,3960,,360,,,360,
256312165144,,,360,,360,,,,,,,,,540,180,,2040,,,180,540
256312165148,1260,,180,,,1620,3060,900,3600,2700,,,1440,5400,6480,,2160,,,5040,3060
256312165500,36502,21420,18000,900,,23760,24300,13500,17640,22680,,1620,17640,28620,30383.5,,12060,1200,,16020,27720
;
run;

This makes it possible for everyone else to recreate your data with a simple copy/paste and submit. See it as a matter of basic courtesy to the people who are supposed to help you.

 

Next, you have 21 revX columns. How do those map to the twelve months you need to observe? Or would you want 9 12-month rolling windows?

And can it be assumed that a missing month value represents zero?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 8

Re: getting the rate of change by each observation for a number months

Thank you 

 

 

 

ppropriate

Esteemed Advisor
Posts: 6,270

Re: getting the rate of change by each observation for a number months

So what output do you expect? Take the sample data from my last post, and show what should be the output for every observation, and how you (logically) came to that result.

If you need more datalines to illustrate what you want, just expand the datastep with more data.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 8

Re: getting the rate of change by each observation for a number months

Hi 

 

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;

Esteemed Advisor
Posts: 6,270

Re: getting the rate of change by each observation for a number months

And what is the formula you used to get that slope?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 8

Re: getting the rate of change by each observation for a number months

Yes 

 

 

 

 

 

Esteemed Advisor
Posts: 6,270

Re: getting the rate of change by each observation for a number months

Ok, now we're getting somewhere.

The simplest thing would be to compare the first half against the second:

data want;
set have;
array revs {*} rev1-rev21;
do i = 1 to dim(revs); /* set missing to zero */
  if missing(revs{i}) then revs{i} = 0;
end;
drop i;
if sum(of rev1-rev21) ne 0; /* don't calculate when there's no revenue at all */
sum_start = sum(of rev1-rev10);
sum_end = sum(of rev12-rev21);
slope = (sum_end - sum_start) / (sum_end + sum_start);
run;

This method could be expanded to calculate more smaller groups and the individual differences between them.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 8

Re: getting the rate of change by each observation for a number months

Thank you 

 

 

Ask a Question
Discussion stats
  • 10 replies
  • 100 views
  • 2 likes
  • 2 in conversation