Tag: Coding Tips

SAS VA: Dealing with Missing Dates

It’s nearing the new year and you may have already started preparing reports that have the organization’s goals and the progress toward those goals. However your chart may not be displaying correctly. If your data is not setup properly then you’ll notice that you only have one or two months when you want to see the entire year even if there is no data yet. …

This post appeared first on BI Notes for SAS Software Users. Go to the site to subscribe or view more content.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SAS Coding: Use Flowcharts to Learn Inherited SAS Code

I’m a visual person – I always need a picture. As a consultant, many times I’m given a thumb drive full of code and asked to make modifications.  When you are on a project with me, you’ll grow weary of hearing me say “Can you draw it?” Something magical happens for me when I see a flow or see an idea.

One of the most confusing projects I …

Post SAS Coding: Use Flowcharts to Learn Inherited SAS Code appeared first on BI Notes for SAS® Users. Go to BI Notes for SAS® Users to subscribe.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Building a SAS Stored Process Log

Stored Process Log

As a SAS stored process developer, a question sometimes pokes its way into my head: “Are people using the stored processes I write?”  In fact, really I have four questions:

What stored processes are being used? 
Who is using them?
When are they being used?
How are they using them?

I realized what I’ve been missing.  I need a SAS stored process log.
If It Works for a Macro…
As a macro programmer …

Post Building a SAS Stored Process Log appeared first on BI Notes for SAS® Users. Go to BI Notes for SAS® Users to subscribe.

Taming SAS Stored Process Selection List Prompts

Author:

 
I like most things SAS.  But there are of course some features that I wish were implemented differently.  One of those is selection list prompts.  The good news is, even when SAS implements something in a way that I find, well let’s say, surprising, there is often a way to …

Post Taming SAS Stored Process Selection List Prompts appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

Coding: Quick Tip for Exploiting and Identifying SAS Formats

SAS Formats Case Subcategory

Author:

SAS formats are very useful for translating values into other values.  You may want to format values for something more presentable, use the format to do lookups within an ETL process for faster performance, or you may want to trick out a report with numeric values displayed as ranges.  There …

Post Coding: Quick Tip for Exploiting and Identifying SAS Formats appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

Using an Autocall Macro Library in SAS BI

Macro Library

Author:

 a SAS programmer, I am dependent on my SAS autocall macro library.  It stores a bunch of utility macros that I use on a daily basis. When I started learning about stored processes and other BI tools, one of my first thoughts was “How can I access all of my …

Post Using an Autocall Macro Library in SAS BI appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

3 Tips for Testing Large Data on Slow Connections or Escaping Upper Hell

Do you ever find yourself wondering if you are paying for sins from a past life while you wait for SAS Enterprise Guide to show …

The post 3 Tips for Testing Large Data on Slow Connections or Escaping Upper Hell appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

Dashboards:Tips for Designing Dashboards with SAS Code

I realize not everyone is using the SAS BI system, but that does not mean that you don’t need to create a dashboard.  In BASE SAS, dashboards are created using fairly simple SAS code (GKPI, macros, and ODS).  [Remember, you can insert the same PROC GKPI code into  Web Report Studio as …

The post Dashboards:Tips for Designing Dashboards with SAS Code appeared first on Business Intelligence Notes for SAS® BI Users. Written by .