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
