09-19-2013 03:01 PM
Is there any good comprehensive example of a development in VBA or VB.Net so as to develop a simple VB sub procedure to run a SAS program, import in Excel a dataset generated by the same and thereafter carryout the Excel VBA/VB Macros. Please see if you can refer to a simple developing and good learning source of information.
Thanx in advance.
09-19-2013 06:30 PM
Many examples of what I've seen people do with data exported from SAS to Excel could have had the steps done in Excel within SAS first. I would strongly suggest looking at these projects to see if everything could be done in one platform to minimize maintenance issues.
For example, code that I learned for SAS in 1987 still runs. There may be better ways to accomplish some of the tasks now but the code works. I'm not sure you can say that upgraded versions of Excel has kept compatibility of code that well.
09-19-2013 11:56 PM
No doubt Ballard! The steps are sought to be carried out in SAS first but to run the SAS macros from VB VB.Net or VBA I haven't found any way yet to input the arguments to the same SAS macros. Furthermore, as I was advised to use ODS rather than DDE I have not been able to locate any good user friendly example in terms of reformatting, manipulating or placing the data in custom ways on worksheets. Even no reply was received on my question
With a VB.Net and VBA background sure have found the same to be having a good interactivity with DBMS and Office Suite.