How To Pass SAS Macro Variables from VBA Script?

Lily — Thu, 19 Jul 2007 19:48:52 GMT

Hi,

I have an MS Access VBA script which will call a stored SAS procedure. In the procedure, I utilized a macro variable the value of which will come from VBA, i.e., a pull-down text box. How can I pass the value to SAS?

thanks,

Lily

Re: How To Pass SAS Macro Variables from VBA Script?

Cynthia_sas — Thu, 19 Jul 2007 21:30:34 GMT

Hi,
If you are going to invoke the stored process via URL using the Stored Process Web Application, then you would pass the parameter value as a name/value pairs on the URL:
[pre]
http://server:port/SASStoredProcess/do?_program=/Repos/SP-name&region=Asia&type=Summary
[/pre]
where REGION is a parameter (which could come from a form or some other front end) and Asia is the value of the parameter
and,
TYPE is a parameter and Summary is the value of the parameter.

If you are not going to use the Stored Process Web Application for invoking your stored process, then you should consult the samples in the Integration Technologies documentation or work with Tech Support.

cynthia

topic Re: How To Pass SAS Macro Variables from VBA Script? in Microsoft Integration with SAS

How To Pass SAS Macro Variables from VBA Script?

Re: How To Pass SAS Macro Variables from VBA Script?