topic Re: values overlap CNTLIN in New SAS User

values overlap CNTLIN

erickdt — Wed, 31 Jul 2019 21:34:31 GMT

Hi there!

I got the follow error when I try to use CNTLIN:

ERROR: For format $CD_BLOQUEIO, this range is repeated, or values overlap: 16-16.

data BASE;
input CD_BLOQUEIO CD_PESO;
datalines;
57 3
58 4
59 5
60 16
61 16
62 1
;

DATA CD_BLOQUEIO ;
SET BASE (RENAME = (cd_peso = START CD_BLOQUEIO= LABEL));
FMTNAME = "$CD_BLOQUEIO" ;
RUN;

PROC FORMAT
CNTLIN = CD_BLOQUEIO;
RUN;

My format should be based on "CD BLOQUEIO"....
If CD BLOQUEIO equal 60 my result applyng format should 16 ,as well if my CD_BLOQUEIO equal 61.

Is it rigth? Thanks in advanced

Re: values overlap CNTLIN

Reeza — Wed, 31 Jul 2019 21:41:17 GMT

You have your START and LABEL variables set backwards. Try reversing them and see if that's what you want. START is what your variables currently look like, LABEL is what you want them to look like.

Re: values overlap CNTLIN

erickdt — Wed, 31 Jul 2019 22:24:54 GMT

Hi Reeza, thanks for the fast reply... it works!

however i have another question....

In my case I've COD_BLOQUEIO equal 72 and isn't at the format.... applying the format my variable keep still the same value "72".. is it possible "clean" the value of the variable if value isn't at the format? thanks in advanced, again!

Re: values overlap CNTLIN

Reeza — Wed, 31 Jul 2019 22:32:05 GMT

You can use the OTHER option to create a format value for anything not in your list.

In this example it's set to error but you can set it to whatever you'd like:

https://documentation.sas.com/?docsetId=proc&docsetTarget=n1e19y6lrektafn1kj6nbvhus59w.htm&docsetVersion=9.4&locale=en

@erickdt wrote:

Hi Reeza, thanks for the fast reply... it works!

however i have another question....

In my case I've COD_BLOQUEIO equal 72 and isn't at the format.... applying the format my variable keep still the same value "72".. is it possible "clean" the value of the variable if value isn't at the format? thanks in advanced, again!

Re: values overlap CNTLIN

Tom — Wed, 31 Jul 2019 23:04:14 GMT

Why are you defining a character format using numeric variables?