topic Proc format for negative numbers in SAS Procedures

Proc format for negative numbers

Fontaines03 — Fri, 24 Feb 2012 18:15:22 GMT

Hi,

I would like to know how to use the proc format to transform my data as follow:

12.4562 to 12.46

1.232 to 01.23

-2.5 to -02.50

I 've tried with this :

proc format;

picture show (round) low-high=09.99;

run;

but I loose the minus for negative numbers.

Re: Proc format for negative numbers

MikeZdeb — Fri, 24 Feb 2012 18:42:11 GMT

hi ... one idea ...

proc format;

value x

low-<0 = [z6.2]

other = [z5.2]

;

run;

data test;

input x @@;

format x x.;

datalines;

12.4562 1.232 -2.5

;

Obs x

1 12.46

2 01.23

3 -02.50

Proc format for negative numbers

ballardw — Fri, 24 Feb 2012 18:43:12 GMT

For your example data this works:

picture show (round)

0-high = 99.99

low - <0=099.99 (prefix='-')

;

But no guarantees for other numbers.

Proc format for negative numbers

sassharp — Fri, 24 Feb 2012 18:45:01 GMT

proc format;

picture pctpic (round) low-<0 ='009.99' (prefix='-' )

0-high='009.99'

;

run;

Use some thing like this

Proc format for negative numbers

Fontaines03 — Fri, 24 Feb 2012 19:04:44 GMT

thank you very much