How To Pass SAS Macro Variables from VBA Script?

[Lily]

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

[Cynthia_sas]

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