In a couple of my previous blogs I discussed how to audit who made changes to data in a SAS environment. In the last couple of weeks I have been asked how to do the same thing for SAS Visual Analytics reports and explorations. The Visual Analytics administrator overview report
You may have noticed that when using date information in SAS Visual Analytics, that the date data values can be displayed in a variety of ways. You may see your dates displayed like Jan1916, 03Jun1915, or 03/12/16, for example. In this blog I’ll help you understand SAS date and time
In my last post, Expert tips for first-time attendees of SAS Global Forum 2016, I asked members of the SAS Global Users Group Executive Board what advice they had for users attending SAS Global Forum for the first time. In this post, they share tips for returning attendees. Each year,
Being able to access information about your operating system from within SAS can be incredibly useful. For example, if you have a directory that contains an unknown number of CSV files that you would like to read into SAS, you certainly would not want to have to write an IMPORT
In this post, I continue the journey of getting data profiling results into SAS Visual Analytics. In my first blog I described the process of collecting DataFlux Data Quality profiling metrics to load a datamart. Now we load this datamart into memory (LASR) and then plug a VA report on
In my previous post, Introducing data-driven loops, I suggested a way of implementing programming loops with a list of index variables pulled from an external data table. These ordinary programming loops iterate during code execution while processing some data elements of an input data table. SAS macro loops, on the
I recently received a call from a colleague that is using parallel processing in a grid environment; he lamented that SAS Enterprise Guide did not show in the work library any of the tables that were successfully created in his project. The issue was very clear in my mind, but
It’s hard to believe, but SAS Global Forum 2016 is less than two months away. As chair of this year’s conference, I’ve been preparing for the event for nearly two years. Now, it’s right around the corner! Lately, I’ve been spending a lot of time reading and contributing to the
SAS Global Forum 2016 is the largest gathering of SAS users in the world, with more than 5,000 data scientists, analytic professionals and business leaders expected for this year’s event at The Venetian in Las Vegas, April 18-21. While many users make the event a part of their professional development
The SAS Data Loader directive ‘Copy Data to Hadoop’ enables you to copy data from DBMS to Hadoop Hive tables. The SAS Data Loader for Hadoop can be configured to copy data from any external database which offers JDBC database connectivity. SAS Data Loader uses the Apache Sqoop™ and Oozie
