topic Re: proc format picture question in SAS Procedures

proc format picture question

DanieleTiles — Wed, 30 Sep 2009 16:50:19 GMT

Hi to all,
I've got a simple picture format:

proc format;
picture posval low-high='000,009';
run;

However, I've got this problem: I'd like to represent the number as it would appear with a commax value (so it'd be shown like 200.000 and not as 200,000...in Italy we use a different format :))
I didn't find any hint on how to do it...
Thanks

Daniele

Re: proc format picture question

sbb — Wed, 30 Sep 2009 17:53:52 GMT

You have SAS-standard NLS (National Language Support) formats which address the decimal/comma consideration. You will need to look in the SAS National Language Support (NLS): Reference Guide for details, however I provided a DOC link below which mentions them.

Or, the PICTURE statement you have shown can also be changed from a comma to a period.

Scott Barry
SBBWorks, Inc.

Formats Documented in Other SAS Publications
The main references for SAS formats are SAS Language Reference: Dictionary and the SAS National Language Support (NLS): Reference Guide. See the documentation for your operating environment for host-specific information about formats.
http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a003168458.htm

Re: proc format picture question

DanieleTiles — Thu, 01 Oct 2009 07:34:35 GMT

Hi there,
actually, I had tried to change from comma to dot before writing (otherwise I wouldn't have written! 🙂 )
Thanks for the link, I'll take a look and hopefully solve this problem.
Best regards

Daniele

Re: proc format picture question

Patrick — Thu, 01 Oct 2009 13:49:35 GMT

Hi Daniele

Have a look at the following. I assume one of the options should cover your needs.

HTH
Patrick

options LOCALE=Italian_Italy;
data _null_;
a=200000.001;
put a= best32.2;
put a= nlnum32.2;
put a= nlnumi32.2;
put a= comma32.2;
put a= commax32.2;
run;

options LOCALE=English_UnitedStates;
data _null_;
a=200000.001;
put a= best32.2;
put a= nlnum32.2;
put a= nlnumi32.2;
put a= comma32.2;
put a= commax32.2;
run;

Re: proc format picture question

DanieleTiles — Fri, 02 Oct 2009 14:56:04 GMT

Hi Patrick,
I've tried with the options Locale, but I didn't see any change in the picture format...with normal formats I've no problem in replacing dot with comma.
Only with the picture one...

Re: proc format picture question

Patrick — Sat, 03 Oct 2009 08:01:39 GMT

Hi Daniele

The example below based on http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0305d&L=sas-l&P=31270

What would we do without Google 🙂

HTH
Patrick

proc format ;
picture q low - high = '000.009,999' (decsep="," dig3sep=".");
run ;

data _null_ ;
x = 200 ;
put x= q. ;
x = 200000 ;
put x= q. ;
x = 200000.001 ;
put x= q. ;
run ;

Re: proc format picture question

DanieleTiles — Mon, 05 Oct 2009 10:22:25 GMT

Dear Patrick,
THANKS!! I couldn't find that options, and now I'm happy!! 😄
Best regards!

Daniele

Re: proc format picture question

Tim_SAS — Mon, 05 Oct 2009 13:46:04 GMT

Just as a shout-out for our Publications folks, here's the online documentation for those two options.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473467.htm#a003281531.