Here are some tips for How to share your SAS knowledge with your professional network.
Tip of the Day:January 5
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
Submitted by Peter Crawford and Murphy Choy. Contact me at my Discussion Page.
Feel free to comment on this tip.