Excel & SAS

BI Tools
Management Console

SAS Visual Analytics 7.4: Modern Theme Vs Classic Theme

At the SAS Global Forum 2016 the SAS Viya platform was announced and part of the platform was SAS Visual Analytics and SAS Visual Statistics converting to the HTML5 interface. Noticeable changes were that the Designer and the Explorer have merged into one interface and there is a spiffy new color Modern theme. Dr. Goodnight […]

Read More
lincoln loves sas
Add-In for MS Office
BI Tools
Data Visualization

SAS Add-In for MS Office: Abe Lincoln Sends Glee in a Snowstorm

It’s been really snowy and cold in North Carolina for the past week.  About 5″ of snow fell in 2 hours, which unleashed pandemonium. Power was out for some, flights were cancelled because the airport shutdown, and many people even left their cars beside the road electing to walk home or stay in a hotel […]

Read More
Stored Processes

SAS Stored Process: Shake, Rattle, and a lil’ DelGobbo Style

One of the great things about attending user conferences such as WUSS is that you get to meet all kinds of fun and interesting people.  Vince DelGobbo is a witty, smart, and clever SAS developer, who also happens to work at SAS Institute.  Vince works with the SAS Stored Process development – so you know […]

Read More
Coding & Data
Enterprise Guide

SAS Enterprise Guide: Import Odd Spreadsheet Data

Perhaps you took my advise a few weeks back and took advantage of the amazing (trumps blare!) SAS Enterprise Guide ability to import MS Excel spreadsheets.  However, if your spreadsheet is a little different – then you may run into some issue when you go to import it.  For instance, look at this import: Oh […]

Read More
Coding & Data
Enterprise Guide

SAS Enterprise Guide: Import the Excel Spreadsheet – Easy Peasy

One SAS Enterprise Guide feature I particularly like is the ability to import Microsoft Excel data quickly and easily.  SAS offers many ways to work with Excel spreadsheets but often I find I just want to extract data from Excel and get on with my job. Tip – Click on any picture to see a […]

Read More