Subscribe to DSC Newsletter

Tricia Aanderud
  • Raleigh, NC
  • United States
Share on Facebook
Share

Tricia Aanderud's Friends

  • Abdoulaye Tandia
  • Sean Flanigan
  • vikram jha
  • Muhammad Riaz
  • Vincent Granville
 

Tricia Aanderud's Page

Latest Activity

Tricia Aanderud's blog post was featured

Things to Consider for Mobile BI Design

Rather it's the wave of the future or just a passing fad,  if you are designing information for the mobile BI users then this change applies to you!  There's a simple reason - what will your fancy report look like on a teeny-tiny, itty-bitty tablet? Cramped? Sliding off the page? Not ready for prime time?   [Read more about mobile BI predictions in my Mobile BI Is Arriving Soon... It Could…See More
Aug 15, 2013
Tricia Aanderud posted a blog post

Push SAS Further with JQuery and AJAX - It's Easy!

In the Jurassic SAS in the BI/EBI World blog, Don Henderson shows fun and cool ways to push SAS a little further, which is using SAS Server Pages, JQuery and AJAX.Check out his startling and beautiful results.  SAS Server…See More
Jul 30, 2013
Tricia Aanderud posted a blog post

3 Tips for Escaping Upper Hell (aka Slow Connections with Large Data)

Ever find yourself waiting for your data to appear and you start wondering if you are paying for sins from a past life?  Dante must have been thinking of this situation as he created his Circles of Hell.  There is no way the agony of waiting for data to appear with a looming deadline did not make his list!Often it seems like the closer the deadline, the slower the connection.  When working with data locally, the data appears in moments.…See More
Jun 4, 2013
Tricia Aanderud posted a blog post

View a SAS table in Excel using a Web Query and a Stored Process

Guest Post by Stig EideStig Eide showed me a trick for using the Excel web query to look at SAS data. Very clever trick!Want to view a SAS table in Excel but you don't have the Add-In for Microsoft Office installed? This post describes an alternative method. Excel has a nice feature where you are allowed to query a web page for data. I will describe how you can set up the query against a stored process, and how to pass parameters.First, you need to create a stored process that can return a HTML…See More
Feb 21, 2013
Tricia Aanderud posted a blog post

Does your SAS code know what time it is? It’s %NOW

Written By Quentin McMullenIn 1986 the Beastie Boys released their classic debut album, License to Ill, and the last track posed a question: “What’s the time?”  The Beasties answered with an anthem, “It’s time to get ill.”  I think Peter Crawford, SAS programmer extraordinaire, would have answered more simply.  What time is it?  It’s %now.%Now – a Timestamp Macro%Now generates a timestamp.   It’s a simple SAS macro, but despite its simplicity, it has a lot to teach about macro design.  In fact,…See More
Dec 20, 2012
Tricia Aanderud posted a blog post

Put all Your Code in an Elephant Trunk!

Last week while searching for a code snippet through several folders of information, I realized that the code was still on my old computer ... ugh! One of my weekend projects was to organize my code examples somewhere -  I'm going to try Evernote, which I have been using to organize other items. Evernote uses an elephant for it's mascot - because elephants never forget. That's what I need!Easy to Organize and Find Code Evernote uses a concept of notebooks -…See More
Dec 17, 2012
Tricia Aanderud posted a blog post

SAS Prompt Framework: SAS Shared Prompts are Scrumpdillyicious for a Stored Process!

When I was growing up, a big treat on a summer afternoon was to get a Dairy Queen ice cream cone dipped in chocolate. Dairy Queen advertised their treats as scrumpdillyicious, which they were to a seven year old!  If you are not aware, SAS ships some shared prompts that you can use with your stored process … and you guessed it … I think they are scrumpdillyicious!Locating the Shared PromptsSAS ships about 15 shared…See More
Nov 12, 2012
Tricia Aanderud posted a blog post

SAS BI Dashboard: Putting Adding Branding to the Dashboard!

After creating a dashboard, the customer asks to have their logo and colors added so their organization branding is available.  Using the SAS Flex Theme Designer, you can change the SAS BI Dashboard colors and logos. In this post I showed you some basics for using the SAS Flex Theme Designer but…See More
Nov 5, 2012
Tricia Aanderud posted a blog post

SAS Administration: Fetch Big Data Faster Across ODBC

By Steve Overton On my current “big data” project, I’m connecting SAS to PostgreSQL using the ODBC access engine.  At first I was seeing pretty bad performance – specifically I wasn’t able to view the ~2.2 billion sample records I created.  After adding 2 simple lines to the odbc.ini…See More
Nov 1, 2012
Tricia Aanderud posted a blog post

SAS Stored Process: Using Alternating Background Color with PROC REPORT

I remember when I began learning how to program using SAS.  One of my first tasks was to create a set of reports that listed the trouble tickets from the customer.  This was before it was easy to get information from SAS to Excel and the goal was to have the reports on the website so it could be reviewed easily.All Hail My SAS Heroes!PROC REPORT results were ugly and hard to read - the manager did not complain but he wasn't impressed.  What a breakthrough when I found…See More
Oct 30, 2012
Tricia Aanderud's blog post was featured

BI Dashboard: Flex Theme Designer Makes it Personal

The first thing many customers want to do is make their SAS BI Dashboard to look more like "them". They want their organizational branding (their logo, colors, and corporate identity). If that task has fallen on your, here's some guidance about how to accomplish that task.What the Heck is the Flex Theme Designer?The SAS BI Dashboard is an Adobe Flash application. It can be customized using…See More
Oct 18, 2012
Tricia Aanderud posted a blog post

BI Dashboard: Flex Theme Designer Makes it Personal

The first thing many customers want to do is make their SAS BI Dashboard to look more like "them". They want their organizational branding (their logo, colors, and corporate identity). If that task has fallen on your, here's some guidance about how to accomplish that task.What the Heck is the Flex Theme Designer?The SAS BI Dashboard is an Adobe Flash application. It can be customized using…See More
Oct 18, 2012
Tricia Aanderud posted a blog post

SAS Code: Show the Values of All Macro Variables in Your SAS Session

SAS Business Intelligence applications use global macro variables to store information about the environment as well as prompt values entered by a user. When developing a Stored Process it is often helpful to review the values of these macro variables. A simple %PUT statement, %PUT _GLOBAL_ ; , will write a listing of the values of all global macro variables to the log, but the formatting leaves a lot to be desired. This post describes a simple utility macro, %PrintMacVars, which can be used to…See More
Oct 12, 2012
Tricia Aanderud posted a blog post

Working with Big Data in SAS BI

Steve Overton is working on his SAS Global Forum 2013 paper idea! I don't want to give away his secret - but he wants to show some ways to work with Big Data. First he has to load the big data into his demo system - here's some tricks he has learned.Do you know some others? Share them!SAS Administration: Process Data Faster in RDBMS by Buffering the Data in MemoryBy By default,…See More
Oct 3, 2012
Tricia Aanderud posted a blog post

SAS Portal and BI Dashboard: Customizing the Tabs

You can customize the SAS Portal and SAS BI Dashboard Web Browser titles in just a few moments. Here’s another branding trick that Kushal Ramani sent to me. He also sent some these branding tricks for Web Report Studio and SAS Portal. For this example, you are…See More
Sep 27, 2012
Tricia Aanderud posted a blog post

SAS Stored Process: Benefits of Minimalist Programming

By MinimalismSAS stored processes can do a lot.  While I haven’t taken on the life of a true minimalist, recently I have come to see the benefits of limiting my stored process source code to just one statement.  And the best part of this practice is, I can still do everything I want.When you create a stored process, SAS writes the source code somewhere (see Tricia’s post on…See More
Sep 20, 2012

Profile Information

Short Bio:
Writer, programmer, speaker, SAS Consultant Visit my blog: http://www.bi-notes.com
My Website or LinkedIn Profile (URL):
http://www.bi-notes.com
Field of Expertise:
Business Analytics
Years of Experience in Analytical Role:
10
Professional Status:
Technical, Consultant
Interests:
Networking
What is your Favorite Data Mining or Analytical Website?
http://www.bi-notes.com
What Other Analytical Website do you Recommend?
http://dashboard-spy.com
Your Company:
And Data Inc
Industry:
Consulting
How did you find out about AnalyticBridge?
Invitation

Tricia Aanderud's Blog

Things to Consider for Mobile BI Design

Posted on August 15, 2013 at 10:30am 0 Comments

Rather it's the wave of the future or just a passing fad,  if you are designing information for the mobile BI users then this change applies to you!  There's a simple reason - what will your fancy report look like on a teeny-tiny, itty-bitty tablet? Cramped? Sliding off the page? Not ready for prime time?   [Read more about mobile BI predictions in my Mobile BI Is Arriving Soon... It Could…

Continue

Push SAS Further with JQuery and AJAX - It's Easy!

Posted on July 30, 2013 at 2:41am 0 Comments

In the Jurassic SAS in the BI/EBI World blog, Don Henderson shows fun and cool ways to push SAS a little further, which is using SAS Server Pages, JQuery and AJAX.

Check out his startling and beautiful results.  …

Continue

3 Tips for Escaping Upper Hell (aka Slow Connections with Large Data)

Posted on June 4, 2013 at 5:23am 0 Comments

Ever find yourself waiting for your data to appear and you start wondering if you are paying for sins from a past life?  Dante must have been thinking of this situation as he created his Circles of Hell.  There is no way the agony of waiting for data to appear with a looming deadline did not make his list!

Often it seems like the closer the deadline, the slower the connection.  When working with data locally, the data appears…

Continue

View a SAS table in Excel using a Web Query and a Stored Process

Posted on February 21, 2013 at 5:30am 0 Comments

Guest Post by Stig Eide

Stig Eide showed me a trick for using the Excel web query to look at SAS data. Very clever trick!


Want to view a SAS table in Excel but you don't have the Add-In for Microsoft Office installed? This post describes an alternative method. Excel has a nice feature where you are allowed to query a web page for data. I will describe how you can set up the query against a stored process, and how to pass parameters.

First, you need…

Continue

Comment Wall

You need to be a member of AnalyticBridge to add comments!

Join AnalyticBridge

  • No comments yet!
 
 
 

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service