Hi Tom, Thank you for the guidance. As you suggested Proc summary is the best choice. I tried running both proc freq and proc summary. 1. Proc freq - i got the percent frequency count and percentage of total frequency in the output dataset - so if i remove the noprint option and run i am getting the exact number which i am looking out for. 2. proc summary - here i got the type , freq and weight in the output dataset. how can i go about in converting or transpoing the dataset to the exact percentage i am getting in proc freq. Please guide, Thanks and Regards, S.S.Pradeep ... View more