format issue

[brophymj]

When I run this, the format for field1 should be 12,346,756 but it's 12346756

data test;

   infile datalines DLM = ',';

   input

  field1      : comma10.0

  lossyr                   : 20.

;

  DATALINES ;

12346756,2014

;

[Kurt_Bremser]

Correct my previous version of this post.

You are only _using_ an ínformat, but you have not assigned any display format.

Add

format

  field1  comma10.0

  lossyr  20.

;

[mohamed_zaki]

data test;

   infile datalines DLM = ',';

format field1 COMMA10. lossyr 20.;

input field1 lossyr;

DATALINES ;

12346756,2014

;

run;

[RW9]

Yes, you have read the data in as comma10.0, i.e. the input reads the data in that format, buy you have not applied a format to the variable.

data test;

   infile datalines DLM = ',';

   input

  field1 : comma10.0

  lossyr : 20.;

  format field1 comma10.0;

  DATALINES ;

12346756,2014

;

run;