Help using Base SAS procedures

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

Reply
Regular Contributor
Regular Contributor
Posts: 170

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

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
Super User
Posts: 5,438

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

This thread might give you something...

/Linus

http://support.sas.com/forums/thread.jspa?threadID=3757
Data never sleeps
Regular Contributor
Regular Contributor
Posts: 170

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

Thanks Linus!
Ask a Question
Discussion stats
  • 2 replies
  • 146 views
  • 0 likes
  • 2 in conversation