Hi All, I have received a SAS dataset from the client which contains account level information at quarterly intervals. It's an appended table that contains information like account no.,  MIS date, Outstanding Balance, and Days Past Due. So how could I create a new table to get the quarter on quarter DPDs for each of the account numbers. My original dataset contains records from Mar'12 to Mar'20 and about 52 million records. Below I have provided the sample structure of the table which I intended to achieve. Old Structure       New Structure             MIS Date account no. DPD   Account no. DPD Mar-18 DPD Jun-18 DPD Sep18 DPD Dec-18 DPD Mar-19 DPD Jun-19 Mar-18 101 64   101 64 79 61 76 33 42 Jun-18 101 79                 Sep-18 101 61                 Dec-18 101 76                 Mar-19 101 33                 Jun-19 101 42                 ... View more

How can I determine the relative contribution(R- Square) of predictors in multiple regression models? Dear all, do you have any suggestions about how to estimate the relative contribution of different predictors in a multiple regression model of the type: y = b0 + b1x1 + b2x2 + ... + bnxn I have already finalized the model now I want to see the what is the R square of each of the predictors so I have an idea about the relative contribution of each of the predictors in the overall model? ... View more