Thanks ballarddw your suggested code has worked. Appreciate that.    Also, will make a note the information you provide for future reference. A little new to this community and still finding my way around 🙂 ... View more

I'm still unclear what you really want to achieve BUT if this is about creating an Excel that got a column with input validation as Excel drop downs then: That's something I needed some time ago as well. As per my investigation it's not something that you can really do with SAS but you can do it with Python and it's no problem to call Python out of SAS, pass SAS data to Python and then have Python create the Excel. That's the way I've implemented this. ... View more

Hi All, Thanks for the feedback. Definitely have some sort of platform to work with now. I think I will try my luck with developing and running a stored process as our company has all the required prerequisites. @AllanBowe thanks for the advice and your take on it. If I have any questions and if I need to pursue your suggestion, I will message you directly and go from there. ... View more