topic Re: format issue in SAS Procedures

format issue

brophymj — Tue, 17 Feb 2015 08:52:31 GMT

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 — Tue, 17 Feb 2015 09:06:52 GMT

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 — Tue, 17 Feb 2015 09:07:00 GMT

data test;

infile datalines DLM = ',';

format field1 COMMA10. lossyr 20.;

input field1 lossyr;

DATALINES ;

12346756,2014

;

run;

RW9 — Tue, 17 Feb 2015 09:07:28 GMT

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;