Date: Fri, 7 Sep 2007 00:32:07 -0000
Reply-To: gopilth@YAHOO.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: gopilth@YAHOO.COM
Organization: http://groups.google.com
Subject: Re: problem with format catalog
In-Reply-To: <807575.98015.qm@web54201.mail.re2.yahoo.com>
Content-Type: text/plain; charset="us-ascii"
On Sep 6, 3:12 pm, k_monal...@YAHOO.COM (monal kohli) wrote:
> Have you checked the values for start and end in the dataset format_test.There has to be duplicates and that's why you are getting this error.If they are character values ,make sure the spaces are removed ,otherwise it will be considered as two seperate values.
>
> HTH
> Mona
>
>
>
> ----- Original Message ----
> From: "gopi...@YAHOO.COM" <gopi...@YAHOO.COM>
> To: SA...@LISTSERV.UGA.EDU
> Sent: Thursday, September 6, 2007 2:49:54 PM
> Subject: problem with format catalog
>
> Hi,
> I want to create a format catalog . I cleaned the data, made sure
> there are no duplicate values and the used cntlin option in proc
> format but this is the ERROR I get: This range is repeated, or values
> overlap: 2-2
> and no catalog is created.Can any one suggest what to do.
>
> following is the code I used
>
> proc freq data=format_test;
> tables fmtname*start*label/list missing out=dup(where
> =(count >=2));
> quit;
>
> proc format cntlin=format_test lib=library;
> options nofmterr;
> run;
> quit;
>
> Thanks in advance.
> Gopi
>
> ____________________________________________________________________________________
> Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7- Hide quoted text -
>
> - Show quoted text -
Thanks for the response.
There are no duplicate values in the data set. I checked that by using
the proc freq above is my code. Can you pls check it and advise.
Thank you,
Gopi.
|