Date:         Wed, 12 Jul 2000 09:19:09 +0200
Reply-To:     "Laproi, L.G.E (Louis)" <Louis.Laproi@REAAL.NL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Laproi, L.G.E (Louis)" <Louis.Laproi@REAAL.NL>
Subject:      Re: PROC MDDB: Problem with IN= option
Content-Type: text/plain; charset="iso-8859-1"

Hi all,

I get the distinct impresion that MDDB stores the formatted value.
Maybe that is also the reason that you cannot change the formats in the
metabase for EIS purposes.

cull


-----Oorspronkelijk bericht-----
Van: Marc Ravet [mailto:Marc.R_a_v_e_t@SWING.BE]
Verzonden: dinsdag 11 juli 2000 20:48
Aan: SAS-L@LISTSERV.UGA.EDU
Onderwerp: 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
> >


**********************************************************************
Dit e-mailbericht is alleen bestemd voor de geadresseerde(n).
Gebruik door anderen is niet toegestaan. Indien u niet de
geadresseerde(n) bent wordt u verzocht de verzender hiervan
op de hoogte te stellen en het bericht te verwijderen.
Door de electronische verzending kunnen aan de inhoud van
dit bericht geen rechten worden ontleend.

**********************************************************************