topic Re: Proc Format in SAS Programming

Proc Format

SASPhile — Wed, 25 Apr 2012 15:11:21 GMT

In the dataset shown below, why is the rskgrp showing 6?instead of 12

PROC FORMAT;
VALUE WEIGHT
   0.000-0.249 = " 1"
   0.250-0.499 = " 2"
   0.500-0.749 = " 3"
   0.750-0.999 = " 4"
   1.000-1.249 = " 5"
   1.250-1.499 = " 6"
   1.500-1.999 = " 7"
   2.000-2.499 = " 8"
   2.500-2.999 = " 9"
   3.000-3.999 = "10"
   4.000-4.999 = "11"
   5.000-5.999 = "12"
   6.000-HIGH = "13"
   ;
RUN;

data _sk;
totalwt=5.9991;
RISKGRP=PUT(TOTALWT,WEIGHT.);
run;

Re: Proc Format

Astounding — Wed, 25 Apr 2012 15:30:29 GMT

SASPhile,

The value you have selected, 5.9991, is not defined within the format. So expressing it as "12" was never an option. Therefore, the PUT function returns the actual value (5.9991), but uses the width of 2 to express that value (since 2 is the width of the WEIGHT. format).

When you get into some of the intricacies, there is a FUZZ factor available, but it is usually set much smaller than 0.0001. You would be better advised to define your format so that there are no gaps. Consider whether this would be appropriate:

5 - < 6 = "12"

Good luck.

Re: Proc Format

FloydNevseta — Wed, 25 Apr 2012 15:37:20 GMT

Your ranges are not continuous. Either fix your formats like this:

PROC FORMAT;

VALUE WEIGHT

0.000-<0.25 = " 1"

0.250-<0.5 = " 2"

0.500-<0.75 = " 3"

0.750-<1 = " 4"

1.000-<1.25 = " 5"

1.250-<1.5 = " 6"

1.500-<2 = " 7"

2.000-<2.5 = " 8"

2.500-<3 = " 9"

3.000-<4 = "10"

4.000-<5 = "11"

5.000-<6 = "12"

6.000-HIGH = "13"

;

RUN;

...or round the value you want to format to 3 decimals before you apply the format like this:

totalwt=round( 5.9991, .001 );

Re: Proc Format

Ksharp — Thu, 26 Apr 2012 04:44:33 GMT

Astounding has given you a answer, you need an option for your format.

PROC FORMAT;

VALUE WEIGHT(fuzz=.001)

0.000-0.249 = " 1"

0.250-0.499 = " 2"

0.500-0.749 = " 3"

0.750-0.999 = " 4"

1.000-1.249 = " 5"

1.250-1.499 = " 6"

1.500-1.999 = " 7"

2.000-2.499 = " 8"

2.500-2.999 = " 9"

3.000-3.999 = "10"

4.000-4.999 = "11"

5.000-5.999 = "12"

6.000-HIGH = "13"

;

RUN;

data _sk;

totalwt=5.9991;

RISKGRP=PUT(TOTALWT,WEIGHT.);

run;

Ksharp

Re: Proc Format

Jagadishkatam — Thu, 26 Apr 2012 06:34:38 GMT

Alternatively you can increase the decimal portion from "0.999" to "0.9999". i executed the code below in SAS and it worked.

PROC FORMAT;

VALUE WEIGHT

0.000-0.2499 = " 1"

0.250-0.4999 = " 2"

0.500-0.7499 = " 3"

0.750-0.9999 = " 4"

1.000-1.2499 = " 5"

1.250-1.4999 = " 6"

1.500-1.9999 = " 7"

2.000-2.4999 = " 8"

2.500-2.9999 = " 9"

3.000-3.9999 = "10"

4.000-4.9999 = "11"

5.000-5.9999 = "12"

6.000-HIGH = "13"

;

RUN;

data _sk;

totalwt=5.9991;

RISKGRP=PUT(TOTALWT,WEIGHT.);

put totalwt= riskgrp=;

run;

Output:

totalwt=5.9991 riskgrp=12