Yesterday Rick showed how to use Cholesky decomposition to transform data by the ROOT function of SAS/IML. Cholesky decomposition is so important in simulation. For those DATA STEP programmers who are not very familiar with SAS/IML, PROC FCMP in SAS m…
Best practices for refreshing production OLAP cubes
Unlike prior versions of SAS OLAP technology, 9.2 provides more options for maintaining and refreshing OLAP cubes. With this comes some discussion about what each one does alone, and how pairing these techniques really provides SAS OLAP Server Administ…
Harness the power of the cloud for learning SAS
Since this is my first post on The SAS Training Post blog, please allow me to introduce myself. My name is Kathy and I am an instructor at SAS Headquarters in Cary, NC. I teach SAS courses in our on-campus training center, at regional training ce…
SAS Add-In to MS Office: Refreshing the Data & Breaking the Link
If you use SAS Add-In to Microsoft Office – specifically Excel, then you already know how awesome it is to link to the SAS data on the server. First, if you are using data that needs to be refreshed – just a click of the button brings you the new rows and your report or charts are updated immediately. Awesome! Let the analysis begin … Refreshing Your MS Office Report with SAS Data Using the SAS Add-In to MS Excel (or Word or PowerPoint), you can build charts from the SAS data sets. You may have a report that you create each month based on an Oracle table that is extracted into SAS. On the first day of each month the data is made available, which is great because you report is due the next day and your manager gets upset when it’s not on his desk. [He’s a fan of your work – what can you say?] Let’s make your job a little easier so you can get back to answering your fan mail. Using the SAS Data button from the SAS ribbon, you can peruse the SAS Server to find the desired data. With the found data, you […]
Using Geo-Special Awareness to Get That Extra Edge Out of Predictive Analytics
The way to get that extra edge out of the analysis is to get your hands on the key drivers, transform them wisely and exploit the correlations. The data mining tools are very good at the first steps for most types of data. However, two main gaps are st…
How to open a SAS table in SAS Web Report Studio
Business users of SAS are finding the Web Report Studio capabilities incredibly beneficial for viewing, creating, and sharing reports on the Web. The easy-to-use query and reporting software provides a point-and-click interface for building reports f…