formatting output

[SAS_ASS]

Dear Folks,

I have a problem with the output values of cluster procedure in SAS Enterprise Miner.

There are values like 26E4.

How can I format them into real values?

Thanks!

[PeterClemmensen]

What do you mean by real values?

[Tom]

That is a real value. 26 * 10**4 .

Perhaps you are just using too short a format or column width when trying to display the value?

[SAS_ASS]

Thanks for your answer!

I mean something like an integer value.

This is part of my output.

Well I'm not sure about that 26E4 = 26*10*4??

This is actually what I'm trying to figure out...

[Tom · Accepted solution]

That is scientific, or exponential notation.  26E4 is 26 times 10 to the fourth power. So 260,000. 

Those are really large F statistics.

[ballardw]

---

@SAS_ASS wrote:

Dear Folks,

I have a problem with the output values of cluster procedure in SAS Enterprise Miner.

There are values like 26E4.

How can I format them into real values?

Thanks!

---

It would appear that for some reason you have a BEST4. format applied to the variable in question. You could change the format, either permanently in the data set or in any procedure that uses the data to something with more digits. I might suggest starting with BEST12. to get an idea whether you have decimal portions that you need to display while retaining some flexibility of not displaying many too many more characters than needed.

[SAS_ASS]

Thanks for your answer! The problem is..the variable only exists in the output and the procedure runs in the Enterprise Miner, so I have no idea how to change that....

[ballardw]

The procedure output is likely controlled by a template. If you are pushing the limits of the procedure that designers expected to have fewer than 10000 as the maximum value they may have set such a format.

I don't have access to Enterprise Miner but I would suspect that tools in the general SAS environment should allow you to change the format in an output data set such as in Proc Print adding a FORMAT statement for that variable to use a wider format like BEST6. (or 8 or 12) or Proc Datasets to permanently change the format in the data set.