information map studio

Converting custom date formats in SAS Information Map Studio

Background Let’s assume you have some dates in a custom format:   date20131007 month102013 SAS Reports need to be able to a) present dates in a human readable format and b) understand dates to allow filtering and other funky stuff. For that reason we need a way of translating these custom dates into SAS dates. Step 1 – Get an Information Map with a date field Use an existing one,… Read More »Converting custom date formats in SAS Information Map Studio

Creating SAS Web Reports from an Oracle data source

Here’s a sparse set of instructions for the steps you need to take to configure SAS to access data from an Oracle data store and surface it through SAS Web Report Studio (as an example). Note that once it’s in a SAS format this can be used in any SAS product, and therefore means you can do all sorts of analytics on it. Hence the VA screenshot. Caveats – Please… Read More »Creating SAS Web Reports from an Oracle data source