topic Re: PROC FORMAT for percentage format in SAS Programming

PROC FORMAT for percentage format

weizhongma — Sat, 19 Oct 2013 05:06:51 GMT

I used following syntex to format the number to percentage. However for number of 0.858369, it gives 85%. Is there a way to get correct percetage of 0.85%?

proc format library = fmt;

picture pctfmt low-high='000.00%';

run;

Thanks!

Regards,

Weizhong

Re: PROC FORMAT for percentage format

Jagadishkatam — Sat, 19 Oct 2013 05:16:52 GMT

Hi,

Please try the below picture format

proc format;

picture val low-high='9.99%';

run;

data class;

val=put(0.858369,val.);

run;

Thanks,

Jagadish

Re: PROC FORMAT for percentage format

weizhongma — Sat, 19 Oct 2013 07:19:10 GMT

Thanks! Jagadish.

However my data mixed of numbers such as 20, 100 and 0.858369. If there way to wark around? Thanks!

Re: PROC FORMAT for percentage format

data_null__ — Sat, 19 Oct 2013 11:32:28 GMT

You need to RTM. Look for the round option. You will also need more digit selectors for the larger numbers and what about negative.

Re: PROC FORMAT for percentage format

Jagadishkatam — Sat, 19 Oct 2013 12:52:56 GMT

in that case you can use the below picture format

proc format fmtlib;

picture val low-<1='9.99%'

1<-high='009%';

run;

Thanks,

Jagadish

Re: PROC FORMAT for percentage format

data_null__ — Sun, 20 Oct 2013 15:14:06 GMT

What about 1.

Re: PROC FORMAT for percentage format

Jagadishkatam — Sun, 20 Oct 2013 15:56:50 GMT

Thank you data_null_, please find below my corrected code

proc format fmtlib;

picture val low-<1='9.99%'

1-high='009%';

run;

Thanks,

Jagadish

Re: PROC FORMAT for percentage format

data_null__ — Mon, 21 Oct 2013 10:18:24 GMT

What about the sign if the value is negative?

Re: PROC FORMAT for percentage format

Jagadishkatam — Mon, 21 Oct 2013 12:36:03 GMT

Thank you data_null_, updated the picture format to consider the negative values

proc format fmtlib;

picture val low-<0='09.99%' (prefix='-')

0-<1='09.99%'

1-high='009%';

run;

Thanks,

Jagadish