Thanks for the help. However, I was stuck at one point before calculating Rank. If anyone could help me with that as well. I am using a PROC SQL before calculating Ranks. I am summing up all the monthwise Sales into one column. But somehow the column is populated as blank. I check for values in individual columns, all of them contain either 0 or numeric data. Please find below the code for the same. PROC SQL; CREATE TABLE INTMD_PLAN1 AS SELECT SRA_1,Plan_Name, sum(Month1_TotalUnits_Junior,Month2_TotalUnits_Junior,Month3_TotalUnits_Junior,Month4_TotalUnits_Junior,Month5_TotalUnits_Junior,Month6_TotalUnits_Junior, Month7_TotalUnits_Junior,Month8_TotalUnits_Junior,Month9_TotalUnits_Junior,Month10_TotalUnits_Junior,Month11_TotalUnits_Junior,Month12_TotalUnits_Junior) AS Total_Units_Junior FROM INTMD_PLAN WHERE SRA_1 IS NOT NULL GROUP BY SRA_1,Plan_Name; QUIT; Thanks in advance! ... View more

Hi PGStats, Would this code give this type of result ? Customer_Id      Plan_Name    Sales     Rank 1                       A                   50          1 1                       B                   40          2 1                       C                   30          3 2                       E                   40          1 2                       F                   30          2 2                       D                   20          3 ... View more

Hi xia Keshan, We do have Sales data in the dataset based on which ranking is to be done. For eg the data set would look something like this : Customer_Id      Plan_Name    Sales     Rank 1                       A                   50          1 1                       B                   40          2 1                       C                   30          3 2                       E                   40          1 2                       F                   30          2 2                       D                   20          3 In order to assign new ranks to next customer, I guess we need to retain the rank as well. Correct me if I am wrong. Let me know if the above code would still work for this requirement ? ... View more