topic Re: Displat Thousands as unit digit in SAS Programming

Displat Thousands as unit digit

avigdo — Tue, 07 Oct 2014 11:20:42 GMT

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 — Tue, 07 Oct 2014 11:59:53 GMT

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 — Tue, 07 Oct 2014 12:29:24 GMT

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;