TrustRadius
SAS/Access is a data integration solution, from SAS.SAS/Access to extract data from large databasesWe 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.,10,Bring usable data together quickly for downstream consumption e.g. modelling and reporting.SAS/ACCESS is a must for the every day SAS data analyst.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.,8,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.,DatastageAccess Your DataI 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.,9,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.,MySQL,ArcGIS, IBM SPSS
Unspecified
SAS/Access
11 Ratings
Score 8.1 out of 101
TRScore

SAS/Access Reviews

SAS/Access
11 Ratings
Score 8.1 out of 101
Show Filters 
Hide Filters 
Filter 11 vetted SAS/Access reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-3 of 3)
  Vendors can't alter or remove reviews. Here's why.
Horst Wolter profile photo
February 20, 2018

Review: "SAS/Access to extract data from large databases"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Read Horst Wolter's full review
No photo available
February 22, 2018

Review: "SAS/ACCESS is a must for the every day SAS data analyst."

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Read this authenticated review
Nikardi Jallah profile photo
September 22, 2017

SAS/Access Review: "Access Your Data"

Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Read Nikardi Jallah's full review

SAS/Access Scorecard Summary

Feature Scorecard Summary

Connect to traditional data sources (3)
8.8
Connecto to Big Data and NoSQL (2)
9.1
Simple transformations (2)
8.1
Complex transformations (2)
8.6
Data model creation (1)
7
Metadata management (1)
8
Business rules and workflow (1)
7
Collaboration (1)
6
Testing and debugging (1)
6.4
Integration with data quality tools (2)
7.6
Integration with MDM tools (1)
8

About SAS/Access

SAS/Access is a data integration solution, from SAS.
Categories:  Data Integration

SAS/Access Technical Details

Operating Systems: Unspecified
Mobile Application:No