using INFORMAT with PROC SQL

[SR_FR]

just wondering if INFORMAT is something that can be used with PROC SQL...

An exemple :

PROC SQL ;
CREATE TABLE work.test
(date NUM INFORMAT=ddmmyy10.,
note1 NUM INFORMAT=numx4. ,
note2 NUM INFORMAT=numx4. ,
somme NUM INFORMAT=eurox4.);
INSERT INTO test
VALUES (21/12/1990,12,4,9,5,€200);

you're guessing that the program is not working....

value for note1 should be 12.4
value for note2 should be 9.5

adding quotes if not possible too...

So, what is the use of INFORMAT while creating a table with PROC SQL ?

none ?

best regards

Sébastien

[Peter_C]

only context I imagine using that informat, is interactive update

[SR_FR]

may be.. I'll check that

thanks

Sébastien