So I know how to do this from SAS but client wants me to build an VBA 
application so that everything can be done from Excel side without their 
seeing SAS at all.

1) Choose some parameters from Excel.
2) Pass the information such as SAS dataset names or filtering criteria to 
PC SAS
3) Take the outcome and populate a worksheet in the invoking Excel 
spreadsheet.

Does anyone has any example program to get me started?

On Nov 1, 2:22=A0pm, "Kenneth M. Lin" <kenneth_m_...@sbcglobal.net>
wrote:
> So I know how to do this from SAS but client wants me to build an VBA
> application so that everything can be done from Excel side without their
> seeing SAS at all.
>
> 1) Choose some parameters from Excel.
> 2) Pass the information such as SAS dataset names or filtering criteria t=
o
> PC SAS
> 3) Take the outcome and populate a worksheet in the invoking Excel
> spreadsheet.
>
> Does anyone has any example program to get me started?

Personally, I have not done it yet, but you can check this link out,
which gives sample code:

www.dartmouth.edu/~bburnham/tdi/SAS_Integration.ppt

HTH

Ya

"Ya"  wrote in message 
news:1bc13527-f451-4238-8b9b-49e84a6fa791@t13g2000yqm.googlegroups.com...

On Nov 1, 2:22 pm, "Kenneth M. Lin" <kenneth_m_...@sbcglobal.net>
wrote:
> So I know how to do this from SAS but client wants me to build an VBA
> application so that everything can be done from Excel side without their
> seeing SAS at all.
>
> 1) Choose some parameters from Excel.
> 2) Pass the information such as SAS dataset names or filtering criteria to
> PC SAS
> 3) Take the outcome and populate a worksheet in the invoking Excel
> spreadsheet.
>
> Does anyone has any example program to get me started?

Personally, I have not done it yet, but you can check this link out,
which gives sample code:

www.dartmouth.edu/~bburnham/tdi/SAS_Integration.ppt

HTH

Ya

This is actually pretty great.  However, it redirects the SAS Log and Lst to 
other platform.

What I would like to have is run a SAS command from VBA to create a SAS 
dataset but dump the output into Excel spreadsheet.  I suppose I could do 
PROC PRINT then parse the output but would love to see something more 
elegant.  For example, if I am ODBCing from Excel to Access, there's a 
buffer place that has the resulting query result and I could parse it record 
by record.