Category: SAS

GEO Dimensions in OLAP Cubes

I’ve written about this topic before, but find that more people are interested in how this works. Hoping to provide more detail below. Let me know if I missed anything!

When using the ‘GEO’ dimension type in SAS OLAP Cubes, users will not see anything…

Calling Chris – How many ways does EG retrieve data?

Well if anybody else can answer this then give Chris a race for his money Based on my previous post it got me thinking about hoe EG retrieved the data. It looked to me like EG retrieved the preview data into the EG project for the table selected, but failed to run the SAS query on the workspace server. […]

SAS 9.2 Clients can’t talk to SAS 9.2 Workspace Server – Wrong version

SAS are doing a Grid install on Linux at a customer site, interesting process to watch I must say. One of issues they struck was when they tried to get Enterprise Guide 4.3 to run some code on the 9.2 Workspace server (pre Grid component install). EG could see the metadata and data, it could […]

Using SAS and Python to normalize database

Many occasions, data needs to be normalized to speed up query operations before entering a database. Interestingly, SAS’s data step array cannot accept mixed data types including both numeric and character ones, which makes it unusable for such a pur…

Example 8.25: more latent class models (plus a graphical display)

In recent entries (here, here, here and here), we’ve been fitting a series of latent class models using SAS and R. One of the most commonly used and powerful package for latent class model estimation is Mplus. In this entry, we demonstrate how to use…

Jedi SAS Tricks: Email from the Front – Part 2

In my last blog post, I discussed how to use SAS options to send unattended email using an SMTP server. In this segment, I’ll tackle creating “pretty” email (using HTML) and sending out emails with attachments. First, I produced a basic repo…

Golden Nuggets of Helpful Information

I’ve been answering the most random set of questions over the last few days. In the process, I rediscovered some great resources; gems that are worthy of a mention here.

Currently, you cannot change the e-mail address that you use to log in to s…

Golden Nuggets of Helpful Information

I’ve been answering the most random set of questions over the last few days. In the process, I rediscovered some great resources; gems that are worthy of a mention here. Currently, you cannot change the e-mail address that you use to log in to support….