SAS/Access

SAS/Access

Score 8.0 out of 10
SAS/Access

Overview

What is SAS/Access?

SAS/Access is a data integration solution, from SAS.
Read more

Recent Reviews

Read all reviews

Popular Features

View all 11 features
  • Connect to traditional data sources (5)
    10.0
    100%

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!

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is SAS/Access?

SAS/Access is a data integration solution, from SAS.

Entry-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.

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

9.7Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

8.5Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

8.8Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

9.7Avg 8.2
Return to navigation

Product Details

What is SAS/Access?

SAS/Access is a data integration solution, from SAS.

SAS/Access Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

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).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

 (16)

Attribute Ratings

Reviews

(1-5 of 5)
Companies can't remove reviews or game the system. Here's why
Larry Burns | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
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
SAS/Access is best suited for large numbers of databases but can be easily used for single databases as well.
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
85%
8.5
Simple transformations
90%
9.0
Complex transformations
80%
8.0
Data Modeling (6)
73.33333333333333%
7.3
Data model creation
90%
9.0
Metadata management
90%
9.0
Business rules and workflow
90%
9.0
Collaboration
90%
9.0
Testing and debugging
80%
8.0
feature 1
N/A
N/A
Data Governance (2)
95%
9.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
100%
10.0
  • Increase of data across campus
  • Less downtime
  • More collaborate and federated data
I have always received excelled service working with SAS technical support. Additionally, the tool is used so widely that there are many online resources and use cases that allow you to see many other uses or support routes.
Jim Metcalf | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
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
SAS/Access is incredibly well-suited for the enterprise-wide data access (read and write) to any data source in your enterprise, no matter the complexity of the schema.
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations
N/A
N/A
Data Modeling
N/A
N/A
Data Governance (2)
100%
10.0
Integration with data quality tools
100%
10.0
Integration with MDM tools
100%
10.0
  • Priceless value.we could not conduct our research without SAS/Access.
With SAS, you pay a license fee annually to use this product. Support is incredible. You get what you pay for, whether it's SAS forums on the SAS support site, technical support tickets via email or phone calls, or example documentation. It's not open source. It's documented thoroughly, and it works.
Score 8 out of 10
Vetted Review
Verified User
SAS/Access is used by my main customer as an efficient way of bringing data from the enterprise data warehouse into SAS for crunching and general customer insight work. It's also used in some cases to reinject data into the warehouse so that people using other BI tools can access it. Using SAS for statistical analysis as well as an ETL tool allows the users to kill two birds with one stone. They can extract the data themselves and then transform it like they want.

The SAS users are located in several business units with the main ones being risk and marketing. For marketing, it's a question of getting data from several different platforms in order to get a clear customer picture. For risk, it's also about getting data from several platforms but the purpose is to size the risk associated with actual and future loans.
  • SAS supports the main database connection options that allow you to optimize the performance of your extracts and loads.
  • Simplicity of the syntax for a basic connection.
  • Ability to configure by an administrator in a BI environment so that all users can benefit from the connection without having to establish it by themselves.
  • Easier management in the administration platform. Connecting these can be a challenge.
Really best suited for tasks where some statistical analysis is needed.
Purely ETL work should be done with a different tool.
Data Source Connection (2)
90%
9.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
90%
9.0
Simple transformations
90%
9.0
Complex transformations
90%
9.0
Data Modeling (1)
70%
7.0
Testing and debugging
70%
7.0
Data Governance (2)
40%
4.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
N/A
N/A
  • Hard to say because it's a part of a global solution. Definetaly help reduce cost by allowing users to use only one tool and not 2.
  • Datastage
Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.
Score 10 out of 10
Vetted Review
Verified User
We are using SAS/Access to extract and join data from a variety of platforms to create new datasets in a form usable by business partners.
  • Able to read a variety of databases e.g. Teradata
  • Can use familiar SQL statements to extract the data
  • Can be used to extract data from a wide variety of platforms
  • SAS/Access currently meets my needs and I expect will evolve as new data sources and platforms emerge.
Extracting from large databases in order to subset and filter for specific purposes is a suitable use for SAS/Access.
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
N/A
N/A
Simple transformations
N/A
N/A
Complex transformations
N/A
N/A
Data Modeling (5)
N/A
N/A
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
N/A
N/A
Collaboration
N/A
N/A
Testing and debugging
N/A
N/A
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
  • Bring usable data together quickly for downstream consumption e.g. modelling and reporting.
September 22, 2017

Access Your Data

Nikardi Jallah | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
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.
SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
85%
8.5
Simple transformations
80%
8.0
Complex transformations
90%
9.0
Data Modeling (5)
56%
5.6
Data model creation
70%
7.0
Metadata management
80%
8.0
Business rules and workflow
70%
7.0
Collaboration
60%
6.0
Testing and debugging
N/A
N/A
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
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.
Return to navigation