SAS/Access gives you power to know
SAS/Access is used in our department and university-wide to provide a connection to various databases to our SAS Viya and SAS 9.4 server …
SAS/Access
SAS/Access
SAS/Access
Overview
What is SAS/Access?
SAS/Access is a data integration solution, from SAS.
Read moreRecent Reviews
Popular Features
View all 11 features- Connect to traditional data sources (5)10.0100%
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SAS/Access, and make your voice heard!
Pricing
View all pricingEntry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
1 person want pricing too
Alternatives Pricing
What is Toad Data Point?
Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and…
What is TIBCO Cloud Integration?
TIBCO Cloudâ„¢ Integration is an enterprise iPaaS platform. It offers a drag-and-drop and API- led design approach for user-friendliness.
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is SAS/Access?
SAS/Access is a data integration solution, from SAS.
SAS/Access Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
SAS/Access is a data integration solution, from SAS.
Reviewers rate Connect to traditional data sources and Integration with MDM tools highest, with a score of 10.
The most common users of SAS/Access are from Enterprises (1,001+ employees).
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (16)
Attribute Ratings
Reviews
(1-3 of 3)- Popular Filters
Companies can't remove reviews or game the system. Here's why
February 29, 2020
SAS/Access gives you power to know
SAS/Access is used in our department and university-wide to provide a connection to various databases to our SAS Viya and SAS 9.4 server setups as well as local based research servers. SAS/Access allows for greater, concerted efforts to connect multiple databases.
- Secure connections to databases
- Managed access to databases and data
- Customized access to databases
- Can be dense to understand
95%
9.5
85%
8.5
73.33333333333333%
7.3
95%
9.5
- Increase of data across campus
- Less downtime
- More collaborate and federated data
February 28, 2020
SAS/Access...the universal adapter that ties together all of your data sources across the enterprise
The Healthy Nevada Project (healthynv.org) uses SAS/Access to bind the SAS 9.4 analytics platform to electronic healthcare records stored in Microsoft SQL Server. SAS/Access is used across the entire project to extract research data. Without the capabilities of SAS/Access, we would be unable to deliver phenotypic data to geneticists so they can perform genome-wide association studies (GWAS). The product is incredibly robust. In the millions of extracts we have performed, we have never encountered a software defect with SAS/Access. As a result, SAS/Access is "invisible" to the team. It just works. Every. Single. Time. The ACCESS product line from SAS is rich in that there are twenty-five different "adapters" that let SAS connect to data sources as disparate Oracle, DB2, Sybase, Hadoop, Impala, SQL Server, MySQL, Greenplum, HAWQ, Netezza....and the list goes on. If your analytics platform is SAS and you have disparate data sources then SAS/Access is your best friend.
- Seamless access to disparate data sources
- Unparalleled data access speed
- Frictionless
- Syntax for the connection string can be tricky
- Specification of the data source driver can be tricky
100%
10.0
N/A
N/A
N/A
N/A
100%
10.0
- Priceless value.we could not conduct our research without SAS/Access.
September 22, 2017
Access Your Data
I currently use SAS/Access to analyze data coming in from the state level Behavioral Health Risk Factor Surveillance System and the Youth Risk Behavior Survey. I focus on tobacco data and SAS is extremely important when looking at this data. I use SAS STAT to analyse the data using survey procedures. Because BRFSS and YRBS are complex surveys I must use the survey procedures in SAS to get weighted frequencies, means and estimates. It is extremely easy to use SAS for these analyses, because the procedures are pretty repetitive. However, I do wish that the strata, weight, and cluster variables did not have to be typed with each procedure done. When using STATA or SPSS these variables are entered once, and the weighted results are automatically given when writing procedure. No need to enter them in for each. However, I am more comfortable with SAS coding and really like that it is user friendly. The online support for SAS is wonderful as well.
- SAS/Access is great for manipulating large and complex databases.
- SAS/Access makes it easy to format reports and graphics from your data.
- Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs.
- SAS/Access coding is not as simple as SQL query language. SAS/Access requires the user to have prior knowledge of SAS coding and data-set manipulation.
- SAS/Access support is not as good as Base SAS support, there is not much help if you want to do a specific format or data merge with your datasets.
- SAS/Access is a bit expensive compared to SQL, but if you already have Base SAS it is not as expensive.
95%
9.5
85%
8.5
56%
5.6
80%
8.0
- SAS/Access has worked so that people do not have to be retrained in SQL.
- We have more access to all relational and un-relational databases.
- However, not many people are familiar with SAS/Access making it hard for collaboration.
SAS/Access can work well with MySQL. There are some coding differences between the two, for example how missing values are handled or rules for variable names. MySQL has simpler coding, but if you are familiar with Base SAS, it is not too difficult to learn. With SAS/Access the user has more freedom with formatting the databases from the data source that they are pulling from. Also, modeling and analysis is easier in SAS. SQL does not do much with graphics or modelling.