this range is repeated, or values overlap

[qwerty12]

data ttspilot_fmt;
set n2p.tts_pilot_uid_092917 end=eof;
if MPIN ='0000103759' then delete; 
start = strip(UID);
label = "Y";
fmtname = "$ttsuid";
keep start label fmtname;
output;
if eof then do;
  start = 'other';
  label = ' ';
  output;
end;
run;

proc format cntlin=ttspilot_fmt;
run;

Error - For format $TTSUID, this range is repeated, or values overlap: U461405348103759-U461405348103759.

Error - For format $TTSUID, this range is repeated, or values overlap: U461405348103759-U461405348103759.

can anyone guide where could be exact issue, where to do changes in code part to overcome this error

[Rick_SAS · Accepted solution]

My guess is that the input data set has duplicate values. You can remove the duplicate values by using the NODUPKEY option on PROC SORT:

proc sort data=n2p.tts_pilot_uid_092917 nodupkey out=Want;
by UID;
run;

Then use the WANT data set to create the format.

If that doesn't work, please post 4-5 observations of the UID variable so we can see the form of the data.

[qwerty12]

using NODUPKEY option on PROC SORT by start worked
Thank you