Date:         Thu, 13 Oct 2011 00:52:37 -0400
Reply-To:     bbser 2009 <bbser2009@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         bbser 2009 <bbser2009@GMAIL.COM>
Subject:      update an existing format
Content-Type: text/plain; charset="us-ascii"

Hi all,

I got a problem with the code below, whose purpose was to update a format.
After running it, I got this error message for the last step.

      ERROR: This range is repeated, or values overlap: SYD        .-SYD
..

I do not know what I am missing here. I would appreciate that you would like
to point it out.

Best regards, Max
(Maaxx)
===============
data aports;
retain FmtName "$airport";
set sasuser.acities;
keep Code City FmtName;
rename Code=Start City=Label;
run;
*options fmtsearch=(work.myfmt work.formats library.formats);

proc format library=work.myfmt cntlin=aports;
run;

proc format library=work.myfmt cntlout=tempfmtdata;
  select $airport;
run;

proc sql;
  insert into tempfmtdata(FmtName, Start, End, Label)
    values("AIRPORT","YYC","YYC","Calgary, AB")
    values("AIRPORT","YYZ","YYZ","Toronto, ON");
quit;

proc format lib=work.myfmt cntlin=tempfmtdata;
run;