sorry forgot to add excel in previous message ... View more

Hi, were you able to get any solution for this questions?  I am working on same requirement and unable to find if i generate Drop down list in excel automatically using SAS EG (proc report & ODS). ... View more

Thanks so much. It worked, i used macro to create multiple sheets with different columns with the above dynamic code .Only this is its taking so much time when there is more data.   ex- it took 25minutes to process 60k rows.   sorry for the delayed response, i was sick so unable to test the code earlier. ... View more

Yes with INDEX it worked.Thanks so much 🙂 ... View more