DATA Step, Macro, Functions and more

using INFORMAT with PROC SQL

Reply
Contributor
Posts: 43

using INFORMAT with PROC SQL

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
Valued Guide
Posts: 2,177

Re: using INFORMAT with PROC SQL

only context I imagine using that informat, is interactive update
Contributor
Posts: 43

Re: using INFORMAT with PROC SQL

may be.. I'll check that

thanks

Sébastien
Ask a Question
Discussion stats
  • 2 replies
  • 263 views
  • 0 likes
  • 2 in conversation