topic Re: proc format cntlin error ranges are overlap or missing. in SAS Programming

proc format cntlin error ranges are overlap or missing.

raja777pharma — Thu, 03 Feb 2022 02:50:42 GMT

Hi ,

I am createing format by using attached excel sheet , but i am getting below error.

Error: For Format VISIT_FMT , this range is repeated, or values overlap: .-..;

proc format cntlin=in_excel_ds;run;

Thank you,

Rajasekhar.

Re: proc format cntlin error ranges are overlap or missing.

Reeza — Thu, 03 Feb 2022 03:26:44 GMT

EDIT: Tested and confirmed - you have duplicates - find and remove those - use PROC SORT.

You also need to tell SAS it's a character format - TYPE=C. Add that into the data set and it works fine.

79
80 proc format cntlin=Sorted;
NOTE: Format $VISIT_FMT is already on the library WORK.FORMATS.
NOTE: Format $VISIT_FMT has been output.
80 ! run;

Re: proc format cntlin error ranges are overlap or missing.

Tom — Thu, 03 Feb 2022 04:49:56 GMT

From browsing the XLSX file in this forum you appear to have two different formats in that same XLSX file that are both trying to use the same NAME. Notice how you have two **OTHER** start values?

The first one is probably a character format and the second one looks like a numeric format. So either add a FMTTYPE variable or add the $ to the front of the name of the character format. Or do both.

You probably do not want both a START and an END for a CHARACTER format. Ranges of character values are messier for text with varying lengths. And it looks like you also don't need them for the numeric format. I did not notice any cases in scanning the file where END is different than START. So just drop END and avoid the risk of it accidentally being different and causing a range of values instead of a single value.