I am trying to duplicate the Excel LINEST function in a SAS EG project. This Excel function returns the "slope of best fit" using the "Least Square Reqression Line Equation" method. I do not need to produce a graph, but only the numerical value of the slope as denoted in the Excel results. The table has 4 fields; Name of Agency 12 13 14 As an example., here are values in the 12, 13, and 14 fields: 12: 2 13: 1.5 14: 3 In the Excel file the LINEST function returns a slope value of.5 for these three data points. I need help: 1. Determining which SAS EG Regression function will duplicate these calculations 2. Assistance in how to enter the field names into the function itself (Dependent variable, Explanatory variable, etc.). I had no luck using the "noodle around" method of problem-solving. Thanks so much for assistance. William
... View more