topic Re: Input Excel Range Selection to SAS Stored Process in Microsoft Integration with SAS

Input Excel Range Selection to SAS Stored Process

Shakir_Juolay — Mon, 25 Nov 2019 13:25:33 GMT

I want to create a SAS Stored Process using Enterprise Guide, that I will call from Excel using SAS Add-In and it will take the data from an Excel range as input that I will specify when prompted to.

I would like to know if the above is feasible or not, if yes, then how?

Re: Input Excel Range Selection to SAS Stored Process

Shakir_Juolay — Wed, 04 Dec 2019 13:27:55 GMT

What I need is mentioned in this paper

https://support.sas.com/resources/papers/proceedings11/050-2011.pdf

Re: Input Excel Range Selection to SAS Stored Process

KatS_SAS — Tue, 10 Dec 2019 20:08:56 GMT

As well as Joe's paper, there is a Sample available on the support.sas.com web page:

http://support.sas.com/kb/42983