Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Importing SAS tables (.sas7bdat)

  
   Database Forums (Home) -> ODBC RSS
Next:  Internships, part time jobs, and fresher jobs for..  
Author Message
Ross

External


Since: Apr 11, 2006
Posts: 5



(Msg. 1) Posted: Fri Dec 26, 2008 4:33 am
Post subject: Importing SAS tables (.sas7bdat)
Archived from groups: microsoft>public>sqlserver>odbc (more info?)
What is the best way to get data into my SQL server tables from SAS tables?
I know that I can export from SAS to .csv and then import .csv to SQL Server
but I would like to directly import from SAS, perhaps thru an ODBC connection.

Suggestions?

Thanks

Ross

 >> Stay informed about: Importing SAS tables (.sas7bdat) 
Back to top
Login to vote
vfrojas

External


Since: Feb 28, 2009
Posts: 1



(Msg. 2) Posted: Sat Feb 28, 2009 3:01 pm
Post subject: RE: Importing SAS tables (.sas7bdat) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Create an ODBC connection to your SQL server. Set up an odbc connection in
SAS environment. Create your sas dataset in sas. Use Proc Copy to copy and
update your SQL Server database. For more info go to:
http://oscarvalles.com/setting-up-odbc-with-SAS-PC

There is a video tutorial there.

"Ross" wrote:

> What is the best way to get data into my SQL server tables from SAS tables?
> I know that I can export from SAS to .csv and then import .csv to SQL Server
> but I would like to directly import from SAS, perhaps thru an ODBC connection.
>
> Suggestions?
>
> Thanks
>
> Ross

 >> Stay informed about: Importing SAS tables (.sas7bdat) 
Back to top
Login to vote
James Dionne

External


Since: Mar 17, 2010
Posts: 1



(Msg. 3) Posted: Wed Mar 17, 2010 7:36 am
Post subject: Find an answer? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Ross have you found an answer to your question? I am facing a similar situation and have been hunting for the correct way to use the SAS ODBC driver to no avail.

Jim



Ros wrote:

Importing SAS tables (.sas7bdat)
26-Dec-08

What is the best way to get data into my SQL server tables from SAS tables?
I know that I can export from SAS to .csv and then import .csv to SQL Server
but I would like to directly import from SAS, perhaps thru an ODBC connection.

Suggestions?

Thanks

Ross

Previous Posts In This Thread:

On Friday, December 26, 2008 7:33 AM
Ros wrote:

Importing SAS tables (.sas7bdat)
What is the best way to get data into my SQL server tables from SAS tables?
I know that I can export from SAS to .csv and then import .csv to SQL Server
but I would like to directly import from SAS, perhaps thru an ODBC connection.

Suggestions?

Thanks

Ross


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorials/aspnet/20f7912e-6fa7-40eb-b31b-b6...d4f2c6a
 >> Stay informed about: Importing SAS tables (.sas7bdat) 
Back to top
Login to vote
Robert Martinez

External


Since: Jul 14, 2010
Posts: 2



(Msg. 4) Posted: Wed Jul 14, 2010 2:14 pm
Post subject: Try This [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I have not personally tried it, but looks to be a good start:

http://www.sas.com/apps/demosdownloads/setupcat.jsp;jsessionid=1AAA3F0...48E55E5

Good luck



James Dionne wrote:

Find an answer?
17-Mar-10

Ross have you found an answer to your question? I am facing a similar situation and have been hunting for the correct way to use the SAS ODBC driver to no avail.

Jim

Previous Posts In This Thread:

On Friday, December 26, 2008 7:33 AM
Ros wrote:

Importing SAS tables (.sas7bdat)
What is the best way to get data into my SQL server tables from SAS tables?
I know that I can export from SAS to .csv and then import .csv to SQL Server
but I would like to directly import from SAS, perhaps thru an ODBC connection.

Suggestions?

Thanks

Ross

On Wednesday, March 17, 2010 10:36 AM
James Dionne wrote:

Find an answer?
Ross have you found an answer to your question? I am facing a similar situation and have been hunting for the correct way to use the SAS ODBC driver to no avail.

Jim


Submitted via EggHeadCafe - Software Developer Portal of Choice
Win A Free License of SandDock for Silverlight
http://www.eggheadcafe.com/tutorials/aspnet/b603164c-1365-45cf-aee7-a5...d6cf704
 >> Stay informed about: Importing SAS tables (.sas7bdat) 
Back to top
Login to vote
Robert Martinez

External


Since: Jul 14, 2010
Posts: 2



(Msg. 5) Posted: Wed Jul 14, 2010 2:40 pm
Post subject: Forgot to mentione the OLEDB [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
These are OLEDB Providers as well:

http://www.sas.com/apps/demosdownloads/setupcat.jsp?cat=SAS+Providers+for+OLE+DB




Robert Martinez wrote:

Try This
14-Jul-10

I have not personally tried it, but looks to be a good start:

http://www.sas.com/apps/demosdownloads/setupcat.jsp;jsessionid=1AAA3F0...48E55E5

Good luck

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Composite UI Pattern And Enterprise Settings
http://www.eggheadcafe.com/tutorials/aspnet/14dd2b7f-9da4-4a45-bc93-ce...ba5c5ee
 >> Stay informed about: Importing SAS tables (.sas7bdat) 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
importing data from DBase to sql 2005 - I need to import data from DBASE databases to SQL 2005. Is it possible in SQL 2005? I imported the same data to a SQL 2000 before, but now in sql2005 I can't make it in the same way. One option would be to import dbase from access and then from sql..

Importing Schema and Data into SQLExpress - I just installed SQLExpress and I ant to import a TurboImage database (schema and data). The turboImage database is on a HP3000 but I am able to connect to it through Microsoft Access. I thought it would be easy to similary import the Data in..

Importing ISAM data into SQLServer - Hello, My company has some old ISAM datasets we need to resuscitate. We would like to import the data into SQLServer. It looks like there are some ISAM ODBC drivers available, but I was wondering how well it works. There would seem to be a step where...

relinking tables using MS Access - I'm new to SQL and am in the process of migrating to a SQL backend for my Access 2000 front end. I'm going the ODBC route to get my databases up and running quickly and then move to an Access Project but I'm haveing problems understanding the relinkin...

OpenQuery with dBase tables - Hi, I upgraded our SQL Server from 2000 to 2005. Since then, OpenQuery against xBase tables behaves uncommonly: At the server machine, I can use OpenQuery(LServer,'select * from \\host \path\table) and it works fine. If I use the same query from a..
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]