cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
CPAZ
Calcite | Level 5 CPAZ
Calcite | Level 5

Query Builder in 4.3 and ODBC connectivity

Posted 04-28-2011 12:33 PM (1571 views)
Hello, I haven't used EG since verion 2.0! Can the query builder in 4.3 connect to ODBC without having to download the table first?

Thanks,
Chris
0 Likes
Reply
1 REPLY 1
ChrisHemedinger
Community Manager ChrisHemedinger
Community Manager

Re: Query Builder in 4.3 and ODBC connectivity

Posted 05-12-2011 08:53 AM (1522 views)  |   In reply to CPAZ
Yes, if you use SAS/ACCESS to ODBC to define a SAS library to access the table.

Otherwise, you have to use File->Open->ODBC -- and that pulls all of the data into your session via the EG client. That can be slow for large data.

Chris
SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
0 Likes
Reply

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Watch Creating Custom Steps in SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • ‎04-28-2011 12:33 PM
  • 1572 views
  • 0 likes
  • 2 in conversation