is there anyway we can display a stored process results in an excel by calling it through the VBA code in excel.I can open the a sas dataset as recordset and displayed in an excel sheet. But for the purpose of a cutomized solution I would like to run the SP through VBA in the excel sheet and display the results.( Or even better if I can run a stroed process , which is a proc summary statement,and open the results through the recordset object .) Not sure if it's possibe. But Just exploring new options 🙂
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.