Programming always involves the considerations for the efficiency and the memory usage. For efficient programming in SAS/IML, my shortcut is to look at the tip sheet from Rick Wicklin and search ways to simplify the codes. As for the memory management…
SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch
Google Analytics uses data from your Website to prepare a neat looking application where you can explore your data and answer what I consider your first-level questions. First-level questions are the most basic things you might want to know, such as How many? What Time Period? It is the second- and third-level questions where the analysis and action plans come into play. After all, it’s not enough to know how many people visited the site – you need to know what segment attracted them and how do you keep them coming back for more. [More articles about Google Analytics here] Reviewing the Google Analytics Dashboard In the Google Analytics site from the Home tab, you can design a dashboard to review what you consider key measurements for your site. This dashboard is easy to use and works great for checking daily traffic. However, these measurements answer your basic questions, such as the counts. It’s more difficult to use the information for in-depth discovery. For instance, in the following figure I am comparing month over month traffic for the site using the Dashboard. This number indicates the total visits for each month. So, what can I learn from these metrics? Traffic […]
SAS and IWA: Two Hops
In an earlier post I mentioned that I would jot down a few notes about my experiences with SAS® software and Integrated Windows Authentication (IWA). This is the first of these posts and concerns the initial configuration. Chances are, if you knew…
Reading your mind: Writing SAS code in the new Enterprise Guide editor
I taught my first SAS Enterprise Guide course more than 10 years ago using version 1.2. At that time, I would estimate 95% of my students did not know how to write SAS code and had no desire to learn the syntax! They just wanted to take advantage o…
SAS Enterprise Guide: Quick Tip for Selecting Text in Columns
Earlier in the week I discussed how I used Google Analytics to help me discover topics of the most interest. SAS Enterprise Guide was a popular topic, so here’s a quick tip that I like to use when working with text in columns. Moving Text around in SAS Enterprise Guide When it comes to data entry, I can assure you that I put the “Z” in lazzzzzzzzzzzzzy. Blech, I hate it more than pie charts. It’s the first thing I’ll have my home robot do when they finally become as normal as a refrigerator. So here’s a tip to save you some keystrokes. When you copy text in SAS EG, you generally have to copy entire rows, but sometimes you just need a list of variable names or the variable values. When you need to copy a column of data, do the following: Hold the ALT key while clicking and dragging to select the column. The column turns blue so you know it works. Press Ctrl+C to copy the column. Click where you want to place the text and press Ctrl+V to paste it. Then you can make any edits you desire. Applying this Trick Other Areas You can […]
6 ways to count odd numbers in SAS/IML
SAS/IML has a number of vector-wise subscripts/operators/functions available, which can make many things easy. A cheat sheet about them can be found at Rick Wicklin’s blog.
To try out those wonderful features( and their combinations?), I designed a…