Hi,   I have a dataset with variables date, AR and TA2.   I want to create AR2 and fix it at the earliest AR date for all subsequent rows (i.e. 2000-01-01). In this case the value should always be 0.020158103.   How can I achieve this in the shortest number of steps? I have tried the retain function as well as a sort, delete and merge but this is quite messy.   Date AR TA2 AR2 2000-01-01 0.020158103   0.020158103 2000-02-01 0.018692771 0.021258489 0.020158103 2000-03-01 0.021398338 0.022432956 0.020158103 2000-04-01   0.021881263 0.020158103 2000-05-01   0.022085627 0.020158103 2000-06-01   0.02190027 0.020158103 2000-07-01   0.021667115 0.020158103 2000-08-01   0.021301672 0.020158103 ... View more

I have a dataset with columns Month, A and Q as below:   Month A Q Calc Jan-19 10.00%     Feb-19 20.00% 21.00% 12.10% Mar-19 15.00% 16.00% 14.04% Apr-19 30.00% 29.00% 18.11% May-19 40.00% 39.00% 25.17% Jun-19 30.00% 29.00% 32.47% Jul-19 10.00% 11.00% 36.04%   I want to create Calc, where first answer is 10%*(1+21%)=12.10% The next row onwards uses the previous rows calc so 12.10%*(1+16%)=14.04%   What is the best way of doing this in SAS so it doesnt have to be done in Excel?   Thanks!   ... View more

Hi,   I have a large dataset (20 year period) in the following format:   month numerator denominator Jan-16 10 200 Feb-16 15 300 Mar-16 20 300 Apr-16 10 150 May-16 5 100 Jun-16 30 350 Jul-16 20 400 Aug-16 25 350 Sep-16 15 200 Oct-16 40 450 Nov-16 10 200 Dec-16 40 400   I need to transform to a quarterly view in the following way.   Quarter_end Rate Mar-16 22.5% Jun-16 30.0% Sep-16 15.0% Dec-16 20.0%   Mar-16 (quarter end) = sum of numerator in Jan-16, Feb-16 and Mar-16 divided by denominator in Jan-16 (quarter start) = (10+15+20) / 200   The logic for the other quarters follow in the same way.   I am currently doing this in Excel but it can get messy.   Is there a more efficient way of doing this in SAS?   Thanks in advance ... View more