An Idea Exchange for SAS software and services

Comments
by Contributor spjcdc
on ‎02-04-2014 04:38 PM

I agree.  Put commas in those large numbers.  I can well imagine that some folks have code that reads the logs and a change such as this would cause their programs to bomb unexpectedly, but perhaps there could be a SAS option that would allow this behavior. 

by Trusted Advisor
on ‎02-17-2015 05:29 PM

Having it as an option would be nice, as well as having the separated be language specific (as not everyone uses commas).  I don't think it should effect the SYSNOBS automatic macro variable to be in the same format, but maybe others disagree.

by Respected Advisor
on ‎02-18-2015 06:49 AM

SAS already has an INTERNAL option for that.

proc options internal;
   run;

option LOGNUMBERFORMAT=1;

data test;
   set sashelp.bweight;
   run;


35         option LOGNUMBERFORMAT=1;
36        
37         data test;
38            set sashelp.bweight;
39            run;

NOTE:
There were 50,000 observations read from the data set SASHELP.BWEIGHT.
NOTE: The data set WORK.TEST has
50,000 observations and 10 variables.
by Trusted Advisor
on ‎02-18-2015 08:05 AM

Well, look at that.  This already exists.  Wonderful.

by Community Manager
on ‎02-18-2015 09:11 AM

And it does respect locale by using the proper conventions for the thousands separator.  Example:

options locale=de;
option LOGNUMBERFORMAT=1; 

data test;
  set sashelp.bweight;
run; 

Result:

NOTE: There were 50.000 observations read from the data set SASHELP.BWEIGHT.
NOTE: The data set WORK.TEST has 50.000 observations and 10 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
by Trusted Advisor
on ‎02-19-2015 09:03 AM

Should change the status of this idea from "Open for voting" to "Delivered"

by Community Manager
on ‎02-19-2015 09:18 AM

I'll look into it.  Since it's INTERNAL and not doc'd, I'll see if there is a roadmap to make this more formally supported.  I can see from internal docs that it's used quite a bit in testing, so I'm sure the option is stable for use.

The option does appear in SAS documentation within some examples.

Chris

by Community Manager
on ‎02-19-2015 04:08 PM

Marking this as DELIVERED.  Since SAS 9.2, the option is INTERNAL and not documented except in the lore maintained by SAS customers such as yourselves.  However, @DaveShea's  idea on this community has rekindled the idea of formally documenting the option.  No promises yet, but the idea is in process.

Keep in mind that the option behavior today might not cover 100% of all numeric output that appears in SAS log messages.  If you use the option to improve the readability of your SAS logs, don't be surprised if you encounter some numbers that don't include the thousands separator.

by Trusted Advisor
on ‎02-19-2015 06:25 PM

Thanks for looking into it.  As it turns out, I've used this option in the past and have totally forgotten about it's existence, go figure.  Makes it much more readable when I'm looking at data steps frequently ranging from hundreds of millions and hundreds of billions.

by Contributor DaveShea
on ‎07-26-2015 03:43 AM

Hi data_null_; and Chris,

Sorry for the delay in responding, I was away down south when all this activity happened on this posting and I only just got to look at it.

Thank you very much for showing the way. I think it would be an excellent idea to make this a formally documented option. Any chance of getting PROC CONTENTS to be sensitive to it as well ?

Cheers,

Downunder Dave.

Wellington

Idea Statuses
Top Liked Authors