Working with account numbers can require adding a leading zero. You can use the Z format but it can be a little tricky. Not so long ago I showed you how to use the Z format to create a new data item in Information Map Studio. However, I noticed many people are still searching for this information and when I was using it myself I was not able to find much on it. This post explains how to create a new column in Enterprise Guide following by the actual coding steps in PROC SQL: Creating a New Column in SAS Enterprise Guide Query Builder To add the leading zeros, you have to use the Z format and a numeric variable. Using the Query Builder, you can create a new column in your data. In this example, you’ll see how to change the numeric ACCNO to a character variable with the leading zeros. This example starts with the ACCNO_TWO dataset. To create the new column, do this: From SAS Enterprise Guide, open the Query Builder with the ACCNO_TWO dataset. Select Computer Columns button. In the Computer Columns window, select the New button (not shown). From the New Computed Column window, select […]
Tag: Datasets, Libraries
SAS BI: Looking at Google Analytics for Popular Blog Topics
This past week I have been studying the Google Analytics data to determine the best topics to discuss in the upcoming month and to prepare the SAS Glo Fo 2012 conference. Google Analytics allows me to measure which posts get the most hits when posted and continue to be popular or referenced. I’ll unveil my little known, but highly coveted analytics process. How’s that for some hype? Getting the Google Analytics Data In a past article, I discussed how I extracted the data from Google Analytics using Excellent Analytics. The following figure shows my query in the Excellent Analytics tool, the data results, and the results in SAS Enterprise Guide. The data consists of the date, post path and title (with URL), source (how person came to site), and visitor type. It’s probably obvious why I would want the date, post, and source but what is not so obvious is visitor type. Visitor Type allows me analyze what topics bring new visitors to the site as well as the topics that retain visitors. Cleaning Up the Data My original plan was to use MS Excel to complete this analysis since I thought it would be simple. However, I realized that […]