Tag: Datasets

SAS Global Forum: Is Google Analytics and SAS BI a good subject?

I’m really excited, Angela and I were invited to speak at the SAS Global Forum in Orlando in April. We were asked to talk about the SAS BI package and we have narrowed down our topic to SAS Information Map Studio, SAS Web Report Studio, and, if time allows, the SAS Information Delivery Portal.  The point of the presentation is learning about the SAS BI clients – getting the data has proved to be a journey of it’s own. Step 1: Need some interesting data … The hardest part of preparing a teaching presentation is find data that presents some mystery and allows you to tell a story that resonates. Right now the leading topic is  along the lines of “How do you let people know you have a book out there?  How do you build excitement?”  For us, building a companion website (this blog) that gave the users an idea of the book content was our answer.  Plus the website would be a continuation of the book information for the users.   The next question is – “How do you know it’s working?” Using the data that Google Analytics collects for this blog, I have been researching what kind of […]

SAS EG: 3 Quick Tips for Working with Data

In 2002, I started out using BASE SAS 8 and it wasn’t until nearly two years later that I learned how to use SAS Enterprise Guide.  I quickly grew to love it.  It made it so much easier to build charts and just keep my data organized.  Today I just want to share some quick tips that I use SAS Enterprise Guide to review my data quickly. Tip #1  Look at the Dataset Some people don’t realize they can view the dataset in the metadata – just like you can in BASE SAS.  All you have to do it double-click and dataset is added to the Project Tree.  You can then double-click the dataset and view it.  [Not too long I discussed datasets and metadata libraries.] Tip #2: View Unique Values for a Variable You can use PROC FREQ to see all values for a variable but that involves typing.  Sometimes I’m in the middle of a some code so I don’t want to add another program or maybe I’m just too lazy. Select Filter and Sort on your dataset.  In the Filter tab, add the variable you want to view – for instance I needed to know the company […]

SAS Prompts: When do you use a Variable Prompt?

If you have spent anytime building SAS  prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data l…