Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: PROC SQL, stored procedures (SQL)& input parameters to SQL database
Started 3 months ago by ~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; ...
Site: SAS Discussion Forums  SAS Discussion Forums - site profile
Forum: SAS Procedures   SAS Procedures - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: sas.com

Other posts in this thread:

Linus H replied 3 months ago
This thread might give you something... /Linus http://support.sas.com/forums/thread.jspa?threadID =3757
Size: 306 bytes
Customize:  Customize "<b>Reply 1</b>: PROC SQL, stored procedures (SQL)& input parameters to SQL database :: SAS Procedures :: SAS Discussion Forums"

~LB replied 2 months, 3 weeks ago
Thanks Linus!
Size: 119 bytes
Customize:  Customize "<b>Reply 2</b>: PROC SQL, stored procedures (SQL)& input parameters to SQL database :: SAS Procedures :: SAS Discussion Forums"

 

Top contributing authors

Name
Posts
~LB
2
user's latest post:
PROC SQL, stored procedures...
Published (2009-09-25 14:01:00)
Thanks Linus!
Linus H
1
user's latest post:
PROC SQL, stored procedures...
Published (2009-09-16 02:23:00)
This thread might give you something... /Linus http://support.sas.com/forums/thread.jspa?threadID=3757

Related threads on "SAS Discussion Forums":

Syntax in a Stored Process / Proc SQL for checking fields...  SAS Discussion Forums - site profile SAS Stored Processes - forum profile Syntax in a Stored Process / Proc SQL for checking fields for blank values
Syntax in a Stored Process / Proc SQL for checking fields for blank values
Stopping proc tabulate or proc sql from dispayling output...  SAS Discussion Forums - site profile ODS and Base Reporting - forum profile Stopping proc tabulate or proc sql from dispayling output in ods pdf
Stopping proc tabulate or proc sql from dispayling output in ods pdf
Questions about proc SQL & proc transpose  SAS Discussion Forums - site profile SAS Procedures - forum profile Questions about proc SQL & proc transpose
Questions about proc SQL & proc transpose
How the Proc sql join is differ From Oracle database sql...  SAS Discussion Forums - site profile Integration with Microsoft - forum profile How the Proc sql join is differ From Oracle database sql joins
How the Proc sql join is differ From Oracle database sql joins
Allowing for Multiple Selections in an sql - stored process?  SAS Discussion Forums - site profile SAS Stored Processes - forum profile Allowing for Multiple Selections in an sql - stored process?
Allowing for Multiple Selections in an sql - stored process?
PROC SQL: Select records based on a variable value in the...  SAS Discussion Forums - site profile SAS Procedures - forum profile PROC SQL: Select records based on a variable value in the last record.
PROC SQL: Select records based on a variable value in the last record.
Proc sql: Does something similar to "Partition...  SAS Discussion Forums - site profile SAS Macro Facility, Data Step and SAS Language Elements - forum profile Proc sql: Does something similar to "Partition by" exist?
Proc sql: Does something similar to "Partition by" exist?
Parameterizing Proc SQL with Arrays and Iterating Using...  SAS Discussion Forums - site profile SAS Macro Facility, Data Step and SAS Language Elements - forum profile Parameterizing Proc SQL with Arrays and Iterating Using Nested Loops
Parameterizing Proc SQL with Arrays and Iterating Using Nested Loops
Proc Sql Vs Pass thru  SAS Discussion Forums - site profile SAS Enterprise Guide - forum profile Proc Sql Vs Pass thru
Proc Sql Vs Pass thru
Emailing output of Proc Sql in EG - Problem  SAS Discussion Forums - site profile ODS and Base Reporting - forum profile Emailing output of Proc Sql in EG - Problem
Emailing output of Proc Sql in EG - Problem

Related threads on other sites:

MySQL stored proc vs MS-SQL stored proc  WebDeveloper.com - site profile SQL - forum profile MySQL stored proc vs MS-SQL stored proc
MySQL stored proc vs MS-SQL stored proc
Calling T SQL stored proc from CLR stored proc  Microsoft TechNet Forums - site profile .NET Framework inside SQL Server - forum profile Calling T SQL stored proc from CLR stored proc
Calling T SQL stored proc from CLR stored proc
MS SQL stored proc  http://www.digitalpoint.com - site profile Databases - forum profile MS SQL stored proc
MS SQL stored proc
Dts , stored proc with output parameters - Dev Articles  Dev Articles Forums - Programming Help and Tutorials for all developmenttechnologies - site profile Microsoft SQL Server - forum profile Dts , stored proc with output parameters - Dev Articles
Dts , stored proc with output parameters - Dev Articles
Writing a SQL stored proc to generate a new hierarchy for...  Twitter / markadams65 - site profile markadams65 - forum profile Writing a SQL stored proc to generate a new hierarchy for a hospital chain 11:31 AM Jun 22nd from web
Writing a SQL stored proc to generate a new hierarchy for a hospital chain 11:31 AM Jun 22nd from web
Debugging a stored proc. sql server mgmt studio idea:...  Twitter / bdavison - site profile bdavison - forum profile Debugging a stored proc. sql server mgmt studio idea: just kidding just kidding just kidding http://tinyurl.com/4fhuu5 9:23 AM Oct 7th from web
Debugging a stored proc. sql server mgmt studio idea: just kidding just kidding just kidding http://tinyurl.com/4fhuu5 9:23 AM Oct 7th from web
Datagridview not populating from stored proc with 2...  MCSE braindumps - site profile .NET Languates / VB - forum profile Datagridview not populating from stored proc with 2 parameters
Datagridview not populating from stored proc with 2 parameters
Error in row -2147467259 calling sql stored proc from...  Discussions in microsoft.public.vb.database.ado - site profile microsoft.public.vb.database.ado - forum profile Error in row -2147467259 calling sql stored proc from excel 2003 in microsoft.public.vb.database.ado
Error in row -2147467259 calling sql stored proc from excel 2003 in microsoft.public.vb.database.ado
Can't run SQL stored proc from VBA  MDBMakers.com - Powered by vBulletin - site profile Client-Server - forum profile Can't run SQL stored proc from VBA
Can't run SQL stored proc from VBA
Linq to SQL Stored proc vs Dataset stored proc  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile Linq to SQL Stored proc vs Dataset stored proc
Linq to SQL Stored proc vs Dataset stored proc
Thread profile page for "PROC SQL, stored procedures (SQL)& input parameters to SQL database" on http://www.sas.com. This report page is a snippet summary view from a single thread "PROC SQL, stored procedures (SQL)& input parameters to SQL database", located on the Message Board at http://www.sas.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity