PROC FORMAT Error with CNTLIN

October 12, 2017
By

This post was kindly contributed by Computing from Out in Left Field - go there to comment and to read the full post.

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)

This post was kindly contributed by Computing from Out in Left Field - go there to comment and to read the full post.

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors





Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.