topic How to call a SAS macro from VBA in SAS Programming

How to call a SAS macro from VBA

deleted_user — Tue, 15 Jul 2008 17:19:12 GMT

Hi,
Can anybody please tell me how to call (or run) a SAS macro with parameters, from VBA.

My macro is something like this

%para2sas(response=,indvars=,strata=);

I have created listboxes to get user inputs from VBA ,but the problem is to connect them with the SAS macro.

Thank you in advance..

Re: How to call a SAS macro from VBA

deleted_user — Thu, 17 Jul 2008 12:27:23 GMT

hi,

call SAS in batch mode with SYSPARM System Option

M.

Re: How to call a SAS macro from VBA

deleted_user — Fri, 18 Jul 2008 04:24:55 GMT

Thank you very much M.
Bye