Hi All, Pls help me out to get the desired output from the below sas file layout : Sas file layout: AccountName Sector Centrename District State Aptech Limited Media and Entertainment ANDHERI WEST-ARENA Mumbai Maharashtra Aptech Limited Security BORIVALI-ARENA Mumbai Maharashtra Aptech Limited Security C.G. ROAD-ARENA Ahmedabad Gujarat Aptech Limited Media and Entertainment SION-ARENA Nagpur Maharashtra Aptech Limited Agriculture SURAT, CITYLIGHT-ARENA Surat Gujarat Aptech Limited Media and Entertainment VILE PARLE WEST-ARENA Mumbai Maharashtra Brainware ltd Organised Retail Brainware Consultancy Pvt Ltd. (Howrah) Howrah West Bengal Brainware ltd Organised Retail Brainware Consultancy Pvt Ltd. (Saltlake) Kolkata West Bengal Brainware ltd Healthcare Brainware Consultancy Pvt. Ltd. [Group of Institutions (Barasat)] Parganas North West Bengal Brainware ltd Organised Retail Brainware Consultancy Pvt. Ltd. [Group of Institutions (Barasat)] Parganas North West Bengal Brainware ltd Security Brainware Consultancy Pvt. Ltd. [Group of Institutions (Barasat)] Parganas North West Bengal Desired Output: AccountName count_centrename count_District District Sector State Aptech Limited 4 2 Mumbai,Nagpur Media and Entertainment,Security Maharashtra Aptech Limited 2 2 Ahmedabad,Surat Security, Agriculture Gujrat Brainware Ltd 3 3 Howrah,Kolkata,Parganas North Organised Retail,Healthcare,Security West Bengal 1. 'district' and 'sector' should have distinct values only. 2. Count of centre should be for distinct training centre only. 3. 'AccountName' in layout file is not in sorted order. Thank you to anyone who can help me to get the desired output. Warm Regards,
... View more
