Category: SAS

Unable to Open Excel Files from SAS Web Report Studio

Was assisting an individual with an issue on the SAS Discussion Forum and we discovered why some users would not get the prompt to save/view excel content in excel rather than in the web browser.

Essentially, the file type options were different for t…

Communication is easy

Communication is easy? Wishful thinking?
Keith Collins, our CTO and VP of Technology, once told me “communication is hard.”
That may seem a completely obvious statement to most of Peer Revue’s
readers, but recall I’m a code monkey. We developers t…

Communication is easy

Communication is easy? Wishful thinking? Keith Collins, our CTO and VP of Technology, once told me “communication is hard.” That may seem a completely obvious statement to most of Peer Revue’s readers, but recall I’m a code monkey. We developers think …

En Route to Steeltown North!

I don’t know about you folks, but Thanksgiving has to be one of my favourite holidays – in terms of food for sure! I like to think of it as a dry-run for the huge family feasts which inevitably define the December holiday season around my household. …

Data Cleansing Brings Out the Nerd in Me

For a brief moment in time, I worked in the Data Warehousing R&D Division at SAS. I was there at the same time that DataFlux joined the SAS family and data cleansing found its way into the product line. I don’t know why I find it so fascinat…

Default value to macro variable

NOTE: This is a great one we picked up from our friends over at the SAS community. We have run across this literally hundreds of times while programming SAS macros. You need to have a default value for a variable and you don’t want to write another macro to set it if it doesn’t exist. […]

Example 8.9: Contrasts

In example 8.6 we showed how to change the reference category. This is the natural first thought analysts have when their primary comparisons aren’t represented in the default output. But our interest might center on a number of comparisons which don…

SAS Macros to Search and Report Errors and Warnings from your SAS Logs

How many a times at work have you gone thru the logs looking for ERROR, WARNINGS, NOTES etc for more information about the generated problem?…I’ve been doing a lot like that lately for developing / debugging / lines of code for more information…I j…