using INFORMAT with PROC SQL

SR_FR — Wed, 10 Mar 2010 15:15:56 GMT

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

Re: using INFORMAT with PROC SQL

Peter_C — Wed, 10 Mar 2010 19:09:41 GMT

only context I imagine using that informat, is interactive update

Re: using INFORMAT with PROC SQL

SR_FR — Thu, 11 Mar 2010 16:23:01 GMT

may be.. I'll check that

thanks

Sébastien

topic using INFORMAT with PROC SQL in SAS Programming

using INFORMAT with PROC SQL

Re: using INFORMAT with PROC SQL

Re: using INFORMAT with PROC SQL