Input Excel Range Selection to SAS Stored Process

[Shakir_Juolay]

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?

[Shakir_Juolay · Accepted solution]

What I need is mentioned in this paper

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

[KatS_SAS]

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

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