CODEWITHSUNDEEP
statastata-macros
dimitriy
dimitriy

Reputation: 9460

Scalar formatting problem with number of digits

I am trying to write a command that ereturns a scalar that is percentage rounded to 2 decimal places. The percentage can be negative or positive, with unknown number of digits before the decimal point.

Here's MRE that shows the problem I am having.

#delimit;

capture program drop my_note;
program my_note, eclass;
    local my_x: display %-9.2f 92.23999999999999;
    ereturn scalar my_x = `my_x';
end;

ereturn clear;
my_note;
ereturn list;

display %-9.2f 92.23999999999999;
display 92.23999999999999;

I am puzzled why display seems to do the right thing (turn 92.23999999999999 to 92.24, though regardless of format), but that e(my_x) does not seem to inherit that format.

Upvotes: 1

Views: 1118

Answers (1)

TheIceBear
TheIceBear

Reputation: 3255

When you create your scalar you copy the value of the local `my_x'. That value is still 92.23999999999999 as : display is not changing the underlying data, only how it is displayed. Think of it as the data in 5.00e+2 and 500 is the same, it is just how that value is shown that differs.

You need to use strings to work with how the value is displayed. However, there are two issues with strings in your code example.

  1. While scalars normally can hold both strings and numeric values, returned scalars can not hold strings (don't ask me why). Would it be possible to return a local instead?

  2. In %-9.2f you specify that the display format to be 9 characters long so your scalar will be e(my_x) : "92.24 ". You can adjust %-9.2f, but since you are now working with strings you can remove excessive spaces using the trim() function.

Try the code below and see if that works given the context of this function. If not tell us more about what you are about to do.

#delimit;

capture program drop my_note;
program my_note, eclass;
    local my_x: display %-9.2f 92.23999999999999;
    ereturn local my_x = trim("`my_x'");
end;

ereturn clear;
my_note;
ereturn list;

Upvotes: 5

Related Questions