BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
naveenraj
Quartz | Level 8

Hi All,

 

I have a requirement where i have to import a .db3 file into SAS. Is it possible to import a .db3 file into SAS.

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

ODBC (Open Database Connectivity) lets a process connect to database data via a standardized interface. Once a database system provides an ODBC driver, every ODBC-capable software can connect to it transparently (no special knowledge of the target necessary). So you need to have the ODBC driver for SQlite installed (.db3 is the standard file extension for SQlite files), and SAS/ACCESS to ODBC licensed.

View solution in original post

8 REPLIES 8
Reeza
Super User

I've used the ODBC driver to connect to SQLite DBs. So yes, you can connect to DB3 files. 

naveenraj
Quartz | Level 8

hi @Kurt_Bremser and @Reeza Thank you for your replies. 

 

Can you be a bit more detailed as i do not understand what you were saying.

 

i am having a .db3 file on my system and i need to import it. On checking with SAS docs, it was saying use proc dbf. But i am not able to import it. 

Kurt_Bremser
Super User

ODBC (Open Database Connectivity) lets a process connect to database data via a standardized interface. Once a database system provides an ODBC driver, every ODBC-capable software can connect to it transparently (no special knowledge of the target necessary). So you need to have the ODBC driver for SQlite installed (.db3 is the standard file extension for SQlite files), and SAS/ACCESS to ODBC licensed.

Kurt_Bremser
Super User

@naveenraj wrote:

 

i am having a .db3 file on my system and i need to import it. On checking with SAS docs, it was saying use proc dbf. But i am not able to import it. 


PROC DBF is for importing/exporting dBase files. But the .db3 extension is not only used by dBase, but also by the SQlite system. If your .db3 file is not a dBase file, PROC DBF will fail.

 

Check with your data provider the exact nature of the file.

naveenraj
Quartz | Level 8

Hi @Kurt_Bremser

 

Please let me know if i understand this correctly. SAS EG cannot import .db3 sqllite files directly. 

 

Instead we have to create a ODBC to the sqllite DB's and create libraries through which we can import data to SAS environment

Reeza
Super User

Depends on what you mean by directly. It's the same method as to connect to any database really. 

 

DB3 is a database not a file. 

 

At the same time DB3 is a text file so you can open it with a text editor so you could theoretically process it with a datastep but that wouldn't be very fun. 

Kurt_Bremser
Super User

To avoid this kind of hassles, it is always best to use a text-based file format for data transfer between systems.

Any DB system can export to csv, and read back from csv. This, of course, includes SAS.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 2276 views
  • 0 likes
  • 3 in conversation