Please refer data below Customer1 Customer2 Customer3 Customer4 Customer5 Jan-18 $5,000 $8,000 $5,250 $6,125 $3,000 Feb-18 $5,100 $8,300 $5,500 $6,625 $3,050 Mar-18 $5,200 $8,600 $5,750 $7,125 $3,100 Apr-18 $5,300 $8,900 $6,000 $7,625 $3,150 May-18 $5,400 $9,200 $6,250 $8,125 $3,200 Jun-18 $5,500 $9,500 $6,500 $8,625 $3,250 Jul-18 $5,600 $9,800 $6,750 $9,125 $3,300 Aug-18 $5,700 $10,100 $7,000 $9,625 $3,350 Sep-18 $5,800 $10,400 $7,250 $10,125 $3,400 Oct-18 $5,900 $10,700 $7,500 $10,625 $3,450 Nov-18 $6,000 $11,000 $7,750 $11,125 $3,500 Dec-18 $6,100 $11,300 $8,000 $11,625 $3,550 For each customer, I am trying to create a curve that fits the past 12 months of data. Essentially, if it is a Polynomial fit (Y = Ax^2+Bx+C ), I am looking for coefficients A,B, C & the error ( MSE or RMSE etc..). I have used Proc Orthoreg/Reg etc.. to get the results but, this will alow me to do this for 1 account at a time. If I am dealing with large volume of accts, this is not an option at all. So, I don't think I can use SAS procedures for this. Is/Are there function(s) available in SAS that allows me to do that. I am looking for something similar to the "Polyfit" function in Python. If not, is there a way to achieve the same results using SAS? Thanks
... View more