SAS Learning Post

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJanuary 27, 2012 1

When developing content in SAS BI Dashboard, such as indicators, ranges, and dashboards, knowing how to name them is pretty important. If changes are required later (for instance to improve the administrators capability of partial promoting content) much more work is required to ensure the links between the objects isn't

English

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJanuary 25, 2012 4

New job, same technology, huge customer value

As many of you have already noticed, my LinkedIn profile and the blog profile blurb have changed. I took on an exciting new job in the SAS Solutions OnDemand team. The official title is Software Development Manager, but what I really do is lead a team of fraud solution architects.

English

Programming Tips

Data table with garbage punctuation in Names, various formats for phone numbers and height and weight data entered in mixed metric and imperial units.

SAS JediJanuary 13, 2012 13

Jedi SAS Tricks: These aren't the droids... Episode 1

In the Star Wars movie, Obi-wan could just wave his hand, mutter a few words, and the stormtroopers would "move along". How the power of the Force makes ridding yourself of problematic characters so much easier! I recently was invited to become an alternate instructor for Ron Cody’s SAS Business

English

Programming Tips

Miss SAS AnswersJanuary 9, 2012 0

Calculated values in PROC REPORT Compute Blocks

Dear Miss SAS Answers, In PROC REPORT can I use one calculated (computed) variable in the calculation of another computed variable? In the example below, I’m trying to use the value of the Bonus column to calculate the Total column: compute Bonus; Bonus =sal.sum*0.05; endcomp; compute Total; total=sum(sal.sum, Bonus.sum); endcomp;

English

Advanced Analytics | Data Visualization | Programming Tips

Angela HallDecember 8, 2011 3

Building custom measures for OLAP cubes

In one minute (and 10 seconds, but are you measuring that?) you can add a custom measure (also known as calculated members) to your OLAP cube. Watch this video to create a simple calculation multiplying units * price. Remember that this mechanism is not just used for multiplications, you can

English

Learn SAS | Programming Tips

Charu ShankarDecember 7, 2011 8

Mmm... Dr. G and the M&Ms

“Do you really serve M&Ms every Wednesday? Tell us the story!” clamored a wide-eyed class after sampling the M&Ms lighting up the breakout area. Seeing how hard they worked on their exercises, it seemed ok to have a slight diversion from technology. Besides as you’ll find out, the story has

English

Advanced Analytics | Data Visualization | Programming Tips

Angela HallDecember 5, 2011 0

OLAP users can fall into the abyss of detail data

OLAP cube developers might have noticed that the amount of time required to generate any aggregation (including the NWAY) can negatively impact their productivity. Developers remove the NWAY aggregation (following the sample screens in a prior post) to significantly reduce build time and allow quick modifications to the cube definition.

English

Programming Tips

SAS JediNovember 18, 2011 18

Jedi SAS Tricks: Building a Name Suffix variable list

If you’ve taken one of my SAS classes you may recall “Mark’s 3 rules of programming”, the first of which is “Lazy programmers are GOOD programmers.” One of the things I love about best about SAS programming is the plethora of functions and shortcuts built into the language, all designed

English

Data Visualization | Programming Tips

Angela HallNovember 9, 2011 0

Limit the number of drill-through to detail records available from OLAP cubes

Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell's measure. The maximum number of records, by default, is set to 300,000. Feasibly the report user could download all

English

Learn SAS | Programming Tips

Charu ShankarNovember 3, 2011 6

Retail therapy the SAS way

It’s mid-afternoon. Day 2 of the PRG2 class. Students return satiated from lunch. Some slipped into this course without taking PRG1 so they missed out on some basics. I’m trying to explain how SAS thinks. I use slides, draw pix, do everything except break into dance to get their attention.

English

Blogs

Blogs

Programming Tips