As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tip of the Day:January 5

From sasCommunity
Jump to: navigation, search

sasCommunity Tip of the Day

Peter Crawford came up with this suggestion of using the NLMNY format in handling formats outside of the United States. To use this approach, one must first change the locale settings which can be achieved by using the locale system option.

After using this option, one can then apply the currency informat and format easily on data. Below is an example of the currency coding.

options locale = English_UnitedKingdom;
 
data _null_;
  a = PUT(1234.1234,NLMNYI32.2);
  b = PUT(-1234.1234,NLMNYI32.2);
  c = PUT(1234.1234,NLMNY32.2);
  d = PUT(-1234.1234,NLMNY32.2);
  reading = input( "£12,345.67", nlmny20. ) ;
  put _all_;
  put 'in dollar style ' reading dollar12.2 ;
run;
 
a=GBP1,234.12 b=-GBP1,234.12 c=£1,234.12 d=-£1,234.12

For Nation Language Support (NLS) for SAS in other countries, on: dates and times, number and money formats and informats, sort order and message language, (and so on) see SAS' NLS Reference Guide.

Submitted by Peter Crawford and Murphy Choy. Contact me at my Discussion Page.



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip