Dear listers,

Please help me....I am trying to aggregate the current balance of the some 900,000 accounts. the ammount comes in billiions. I am not able to print it to the external file.

The sql procedure is used to sum the current balances and the resulting value is stored in a macro variable. I am trying to write the value of the macro variable to an external file. well it is writing properly, but the format for the number is different.

In the following program the value of a1 and b is written as

value of a1 1.2345679E14

value of b 123456790000000 But i want it to be *

123456789123456 or 123,456,789,123,456.

**********************program*****************

data _null_;

a = 123456789123456 ;

call symput ('a1', a);

run;

data _null_;

b = input("&a1",15.);

put " value of a1 &a1 ";

put " value of b " b;

format b 15.2;

run;

*************************************************

please help me......

Thanks,

Kumar *