@pransh wrote: hi how did u solve the second question? You are resurrecting a thread that is very old, more than 12 years old. You would be better off starting your own question. The original poster did not provide any example data so no solution is actually possible, just general guidelines.   Be prepared to provide example data in the form of a data step or reference use of one of the SAS supplied data sets like SASHELP.CLASS. Ask your questions in terms of the data you reference. ... View more