I want to give the Order/ranking to my data set TAXDEPT (output in Rank col.) as shown below using PROC SQL. My source data set is in below form now: SiteID is already in sorted form. where ever SiteTax == allTax, i have to give ranks like 1,2,3,... where ever SiteTax != allTax, i have to give sub-ranks like 3.1, 3.2, ....4.1, 4.2, .... like for SiteID 211 below i need like; 4.1, 4.2, 4.3 TAXDEPT: Country SiteID SiteTax Rank All Country allSite allTax 1 Austria allSite allTax 2 Austria 32 allTax 3 Austria 32 a1 3.1 Austria 211 allTax 4 Austria 211 a2 4.1 Austria 211 a3 4.2 Austria 211 a9 4.3 Austria 330 allTax 5 Austria 330 b2 5.1 Austria 330 b3 5.2 Austria 330 b1 5.3 Austria 330 c2 5.4 Canada allSite allTax 6 Canada 211 allTax 7 Canada 211 q1 7.1 Canada 211 q3 7.2 Canada 211 q2 7.3 Canada 579 allTax 8 Canada 579 8.1 Canada 579 8.2 Canada 579 8.3 Canada 666 allTax 9 Canada 666 9.1
... View more