topic Re: this range is repeated, or values overlap in SAS Programming

this range is repeated, or values overlap

qwerty12 — Wed, 08 Mar 2023 11:23:19 GMT

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

Re: this range is repeated, or values overlap

Rick_SAS — Wed, 08 Mar 2023 11:40:26 GMT

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.

Re: this range is repeated, or values overlap

qwerty12 — Wed, 08 Mar 2023 12:48:21 GMT

using NODUPKEY option on PROC SORT by start worked
Thank you