Date:         Mon, 30 Oct 2000 16:21:45 EST
Reply-To:     Bernard Tremblay <imaginasys@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bernard Tremblay <imaginasys@HOTMAIL.COM>
Subject:      Re: Proc Format CNTIN= Problem
Comments: To: Gary.M.McQuown@FRB.GOV
Content-Type: text/plain; charset=iso-8859-1; format=flowed

Hi Gary,

   What PROC FORMAT is trying to tell you is that you have duplicate entry
in your format.  There is more than one START pointing to different LABELS.
It don't show in the part of the file you sent. But I suggest that you sort
the file B2 by start and look for duplicate or extract duplicates with SQL.
Then take action to avoid duplicates...

      Regards,
         \\\|///
       \\  - -  //
        (  @ @  )
+-----oOOo-(_)-oOOo--+-----------------------------------+
| Bernard Tremblay   |                                   |
|            CSST    | Tel:  (418) 528-9313              |
|                    | Fax:  (418) 528-1493              |
|                    | Int:  Bernard.Tremblay@csst.qc.ca |
+----------------------------+---------------------------+
|    Imaginasys enr  | Res:  (418) 658-1411              |
|                    | Int:  bertrem@videotron.ca        |
|                    | Hot:  imaginasys@hotmail.com      |
+--------------Oooo--+-----------------------------------+
       oooO   (   )
      (   )    ) /
       \ (    (_/
        \_)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: Gary McQuown <Gary.M.McQuown@FRB.GOV>
>Reply-To: Gary.M.McQuown@FRB.GOV
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Proc Format CNTIN= Problem
>Date: Mon, 30 Oct 2000 16:04:46 -0500
>
>Hello,
>
>
>I am receiving the following error when I attempt to create a format from
>the results of a proc contents
>
>with the following code:     proc format cntlin=b2;
>
>
>ERROR: This range is repeated, or values overlap: .-..
>
>There are 1,700+ variables in the data set, but all a valid SAS (v6.12)
>names.
>
>The following is a snip of the proc contents I want to turn into a format.
>
>                      The SAS System                                1
>
>                    OBS    LABEL     START     FMTNAME    TYPE
>
>                      1      1      A10_1        nc        n
>                      2      1      A10_2        nc        n
>                      3      1      A10_3        nc        n
>                      4      1      A10_3V       nc        n
>                      5      1      A10_4V       nc        n
>                      6      2      A3_1_1       nc        n
>                      7      2      A3_1_2       nc        n
>                      8      2      A3_1_3       nc        n
>                      9      2      A3_1_4       nc        n
>                     10      2      A3_1_5       nc        n
>
>Thanks,
>
>Gary McQuown


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.