SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

How To Pass SAS Macro Variables from VBA Script?

Reply
N/A
Posts: 1

How To Pass SAS Macro Variables from VBA Script?

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
SAS Super FREQ
Posts: 8,643

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

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://serverSmiley Tongueort/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
Post a Question
Discussion Stats
  • 1 reply
  • 219 views
  • 0 likes
  • 2 in conversation