topic Re: formatting output in SAS Programming

formatting output

SAS_ASS — Fri, 04 Jan 2019 12:38:04 GMT

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!

Re: formatting output

PeterClemmensen — Fri, 04 Jan 2019 13:22:20 GMT

What do you mean by real values?

Re: formatting output

Tom — Fri, 04 Jan 2019 13:23:36 GMT

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?

Re: formatting output

SAS_ASS — Fri, 04 Jan 2019 14:43:28 GMT

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...

Re: formatting output

Tom — Fri, 04 Jan 2019 14:49:22 GMT

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

Those are really large F statistics.

Re: formatting output

ballardw — Fri, 04 Jan 2019 15:10:07 GMT

@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.

Re: formatting output

SAS_ASS — Fri, 04 Jan 2019 19:00:19 GMT

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....

Re: formatting output

ballardw — Fri, 04 Jan 2019 22:02:39 GMT

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.