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

_LB — Tue, 15 Sep 2009 21:24:58 GMT

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

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

LinusH — Wed, 16 Sep 2009 06:23:52 GMT

This thread might give you something...

/Linus

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

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

_LB — Fri, 25 Sep 2009 18:01:22 GMT

Thanks Linus!

topic Re: PROC SQL, stored procedures (SQL)& input parameters to SQL database in SAS Procedures

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

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

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