Subscribe to DSC Newsletter

Tricia Aanderud's Blog Posts Tagged 'sas' (10)

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 Prompts

SAS…

Continue

Added by Tricia Aanderud on November 12, 2012 at 6:00am — No Comments

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…

Continue

Added by Tricia Aanderud on November 1, 2012 at 5:55am — No Comments

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…

Continue

Added by Tricia Aanderud on October 18, 2012 at 5:40am — No Comments

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,…

Continue

Added by Tricia Aanderud on October 12, 2012 at 6:29am — No Comments

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 Memory

By…
Continue

Added by Tricia Aanderud on October 3, 2012 at 7:02am — No Comments

Can Your System Win the Gold?

Steve Overton posted this article:

 

When troubleshooting data performance problems, IO problems, or simple library connectivity, I use a simple snippet of code to push the data storage to the limits.  It is useful because it stresses the data storage component, whether it be a SAS dataset on local file storage or an external database like Oracle, and it provides useful performance metrics.  To make it even better, since this is a SAS Macro it can easily be…

Continue

Added by Tricia Aanderud on August 8, 2012 at 4:30am — No Comments

SAS Enterprise Guide: Best Practice for Centralized User Storage

Steve Overton shares this tip for SAS Enterprise Guide users and administrators!

fileslink SAS Enterprise Guide: Best Practice for Centralized User Storage

 

A nice feature of SAS Enterprise Guide is the “Files” folder.  This provides direct access to the file system where the workspace server is running.  You can take advantage of this by configuring a central location where users can store data, SAS…

Continue

Added by Tricia Aanderud on June 11, 2012 at 4:44am — No Comments

SAS Enterprise Guide: Import Odd Spreadsheet Data

Perhaps you took my advise a few weeks back and took advantage of the amazing (trumps blare!) SAS Enterprise Guide ability to import MS Excel spreadsheets.  However, if your spreadsheet is a little different – then you may run into some issue when you go to import it.  For instance, look at this…

Continue

Added by Tricia Aanderud on May 30, 2012 at 3:27pm — No Comments

Web Report Studio: Adding Drill-Down Filter Based on a Date

When I was creating the Summary and Detailed reports for the SAS Global Forum paper, I was demonstrating how to link from the weekly chart to the detailed report about the week.  On my first try with my Week Filter based on the date value – it just would not work.  Eeek!  To fix the problem I made a new data item that was a character value.  This posts talks about my strategy.  [You can read our paper "…

Continue

Added by Tricia Aanderud on May 22, 2012 at 4:20am — No Comments

SAS Stored Processes: 3 Tips to Improve Your Prompts

Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break.  Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap!…

Continue

Added by Tricia Aanderud on May 16, 2012 at 6:01am — No Comments

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