BookmarkSubscribeRSS Feed
SR_FR
Obsidian | Level 7
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
2 REPLIES 2
Peter_C
Rhodochrosite | Level 12
only context I imagine using that informat, is interactive update
SR_FR
Obsidian | Level 7
may be.. I'll check that

thanks

Sébastien

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1699 views
  • 0 likes
  • 2 in conversation