3 ms·
At my workplace we use SAS Enterprise Guide for some of this stuff. I like it because it has a drag and drop GUI that non technical users can utilise to extract
by bigger_cheese 12y ago
At my workplace we use SAS Enterprise Guide for some of this stuff. I like it because it has a drag and drop GUI that non technical users can utilise to extract data (It executes SQL queries in background) and do simple operations (like aggregations, statistics, graphs, merging, filtering etc) At the same time it has a decent programming language underpinning it and pretty advance statistical capabilities.
On the down side it still suffers from some of the problems the article references. Some non programmers, even quite technical people simple don't grasp concept of querying and joins.
It is also horrendously easy for the auto generated SQL to be horribly inefficient the default appearance of the plots and other graphical output looks ugly etc, which leads to people doing things like extracting subsets of data from SAS and then pasting it into excel to manipulate it. Which is kind of self defeating.