Date:         Tue, 11 Jul 2000 20:47:56 +0200
Reply-To:     Marc Ravet <Marc.R_a_v_e_t@SWING.BE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Marc Ravet <Marc.R_a_v_e_t@SWING.BE>
Organization: Belgacom Skynet SA/NV
Subject:      Re: PROC MDDB: Problem with IN= option

No. It's wrong.
It's an old error from 6.12.

The length of the variable and the length of the format MUST be the same.

So, by instance,when you create "cpp.cppcust", you must write

LENGTH uselab $20;
FORMAT useslab $20.;

Without this precaution, the update is impossible.


Marc Ravet
Flux Consultancy
Bruxelles
Belgium

Deepak Mathur <Deepak.Mathur@ORANGE.CO.IN> wrote in message
news:B64DA4C3562BD411B3A300508B5C4C8964D3E8@STANEXCH01...
> NO ! It doesn't work ... I gave a FORMAT explicitly for each variable ,
even
> then this error occurs
>
> _________________________________________________________________________
> Knowledge is Power.
>
> Deepak Mathur, IT
> Ground Floor.
> Extn: 5031
> Orange:18299
> _________________________________________________________________________
>
>
>
> > -----Original Message-----
> > From: Andreas Grueninger [SMTP:grueninger@IBGRUENINGER.DE]
> > Sent: Tuesday, July 11, 2000 1:40 AM
> > To:   SAS-L@LISTSERV.UGA.EDU
> > Subject:      Re: PROC MDDB: Problem with IN= option
> >
> > I would try this one:
> >
> > proc mddb data=cpp.cppcust(where=(month=3))
> >           in=mddb1
> >           out=mddb2;
> >     FORMAT useslab $20. disconne $2. agen diff_nos act_nom 3.;
> > run;
> >
> >
> > Ingenieurbuero Grueninger
> > Uhlbergstr. 15
> > 72631 Aichtal (Germany)
> > email: grueninger@ibgrueninger.de
> >