PROC SQL, stored procedures (SQL)& input parameters to SQL database

[_LB]

Hello all;
I am now just learning PROC SQL. I have a MS SQL database that I need to connect to. The SQL admin has made it that I have to pass along specific input parameters called:

@BeginDate smalldatetime,
@EndDate smalldatetime

into a stored procedure
which are dates.

Where do I put these parametrs? I have tried different variations without success.

Code is below;
Thank you for your help.

Lawrence

proc sql;
connect to oledb(provider=sqloledb dsn='SQLMCB23' properties=("Integrated Security"=SSPI "Persist Security Info"=True));
create table table1 as select * from connection to oledb (prcCRBSIpull);
quit; Message was edited by: ~LB

[LinusH]

This thread might give you something...

/Linus

http://support.sas.com/forums/thread.jspa?threadID=3757

[_LB]

Thanks Linus!