How to convert my the measure into my own measure type

[sandeep_18]

Hi Guys,

I have a measure called Amount  332567.I can able to convert into dollars like 332,567 .But I want to convert into 3,33,567(It means 3 lakhs,33 thousand ,567).Can we create any measure so that it will be converted as 3,33,567??

Help me out of this 

Thanks and Regards,

Sandeep

[Sathish_jammy]

Try this: 

proc format;

picture indianc

low-high='99,99,999';

run;

data test;

a=333567.0;

format a indianc.;

run;

[sandeep_18]

Thanks for the reply .But I wan to do this in SAS Visual Analytics.

[SASKiwi]

What version of Visual Analytics are you using? As long as you don't use the DATATYPE option available in PICTURE formats then they can be used in VA 7.x:

http://support.sas.com/kb/47/100.html