Displat Thousands as unit digit

Reply
New Contributor
Posts: 3

Displat Thousands as unit digit

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 Smiley Happy

Super Contributor
Posts: 282

Re: Displat Thousands as unit digit

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.

Super Contributor
Posts: 340

Re: Displat Thousands as unit digit

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;

Ask a Question
Discussion stats
  • 2 replies
  • 203 views
  • 1 like
  • 3 in conversation