Displat Thousands as unit digit

[avigdo]

hello,

I am looking for a format (like "SIZEKB" without the "KB" near the numbers) or another solution in order to display thousands as unity:

For example: to display 17,549 as 17.5.

in addition, if there is a solution for millions also, i will appreciate...

TNX

[Amir]

Hi,

You could try dividing by the grouping (e.g. 1000) and then use the round function, e.g.:

data _null_;

  x=round(17549/1000,0.1);

  put x=;

run;

Regards,

Amir.

[user24feb]

You could use a picture statement:

Proc Format;
  Picture MyThous Low-High='000000.0' (Mult=0.01);
Run;

Data B;
  Value=913837.32; V=Put(Value,MyThous.); Output;
Run;

Proc Print Data=B; Run;