Wednesday, October 11, 2017

PROC FORMAT Error with CNTLIN

What I was doing:

Using a SQL Server table to feed a PROC FORMAT using CNTLIN.

Error message seen:

ERROR: Cannot mix missing and nonmissing values in the same range

Cause:

START column was defined as character and END column was defined as a numeric (decimal)


No comments:

Cisco Information Server (CIS) and MS OLAP

Ok, so my recent issue was integrating CIS with Microsoft OLAP cubes. The normal way to do this is to set up MS OLAP (SSAS) with a website a...