topic Re: Statement Picture Formatting giving extra 0 in SAS Procedures

Statement Picture Formatting giving extra 0

RDS2020 — Thu, 08 Oct 2020 05:49:14 GMT

Hi All,

I am trying to fix value shown by Statemnt PICTURE:-

Existing program is using below format

proc format;
picture dollarydoos
1000 - 9999 = '0999.9' (prefix= '$' multiplier = 0.1 )

Actual Value-1234

Shown as -012.3

even when i am trying this

1000 - 9999 = '999.9' (prefix= '$' multiplier = 0.1 ) still result is same.

How can i make 1234 shown as 123.4 or even 123. I would like to remove this extra 0

Re: Statement Picture Formatting giving extra 0

ballardw — Thu, 08 Oct 2020 06:58:03 GMT

@RDS2020 wrote:

Hi All,

I am trying to fix value shown by Statemnt PICTURE:-

Existing program is using below format

proc format;
picture dollarydoos
1000 - 9999 = '0999.9' (prefix= '$' multiplier = 0.1 )

Actual Value-1234

Shown as -012.3

even when i am trying this

1000 - 9999 = '999.9' (prefix= '$' multiplier = 0.1 ) still result is same.

How can i make 1234 shown as 123.4 or even 123. I would like to remove this extra 0

Do yo actually mean that your value is a negative 1234?

I don't believe any of your "results" as none of them show a dollar sign.

I am not sure what you mean by "remove this extra 0". I don't see any 0 in the result either.

Consider:

proc format;
picture dollarydoos
100 - 9999 = '0009.9' (prefix= '$' 
                         multiplier=1
                         )
;


data _null_;
  x= 1234;
  put x= dollarydoos.;
run;

After the multiple you used was applied the result 123.4 was outside of the range of 1000-9999 specified for the format.

Please show code for exactly how you are testing the result of the format. Include assigning the value and using it to display the value.

Re: Statement Picture Formatting giving extra 0

Kurt_Bremser — Thu, 08 Oct 2020 07:24:21 GMT

A "9" in the picture forces the digit to be displayed; a "0" allows SAS to omit leading zeroes.

See the documentation of the PICTURE Statement.

Re: Statement Picture Formatting giving extra 0

RDS2020 — Thu, 08 Oct 2020 08:17:22 GMT

Nope its not negative. it is converting 1234 value to 012.3instead of 123.4. 1234 is well in range of 1000-9999

Re: Statement Picture Formatting giving extra 0

Kurt_Bremser — Thu, 08 Oct 2020 08:41:19 GMT

First, the multiplier is applied to the value; then, the integer value resulting from that calculation is placed into the picture:

proc format;
picture dollarydoos
  1000 - 9999 = '0009.9' (
    prefix= '$' 
    multiplier=1
  )
;
run;

data _null_;
x= 1234.555;
put x= dollarydoos.;
run;

Re: Statement Picture Formatting giving extra 0

ballardw — Thu, 08 Oct 2020 10:26:14 GMT

@RDS2020 wrote:
Nope its not negative. it is converting 1234 value to 012.3instead of 123.4. 1234 is well in range of 1000-9999

Did you run my code example?

Re: Statement Picture Formatting giving extra 0

RDS2020 — Thu, 15 Oct 2020 00:51:42 GMT

Hi @ballardw ,

Yes i tries it. It is giving

x=$123.4

so since it is multiplied by 1 shudnt it show 1234.5 and shouldnt have changed the value.

Formatting shouldnt change the actual value, isnt it so?

Thanks,

RDS

Re: Statement Picture Formatting giving extra 0

ballardw — Thu, 15 Oct 2020 14:25:42 GMT

@RDS2020 wrote:

Hi @ballardw ,

Yes i tries it. It is giving

x=$123.4

so since it is multiplied by 1 shudnt it show 1234.5 and shouldnt have changed the value.

Formatting shouldnt change the actual value, isnt it so?

Thanks,

RDS

So what exactly is your question? You started off claiming that you wanted, or expected, 123.4 as the output.

Formatting does NOT change the value of any variable. Ever. However it will significantly change how the value may appear in output.