billion or trillion conversion to crores and lakhs

[ram1981mehta]

Hi,

Thanks for replying to my post.I am attaching my requirements , it's part of the retail insights report (Sample report)

https://www.sas.com/en_gb/software/business-intelligence/visual-analytics/demo/retail-insights/sampl...

I am attaching the screen shot of my requirements, I want to display a measure i.e. in millions.

Can you please suggest any ideas.

Thanks,

[SASKiwi]

Well using SAS user-defined formats as described in this post is not going to work as they can't be applied to measures. I'm wondering if the VA 7.4 text object may help here. We haven't upgraded to 7.4 yet so I can't try it out.

[puneetwadhwa85]

Hi All,

Did anyone got answer to this thread.... even I am trying to do so but no solution yet. Please reply back soon if you got solution.

Regards

Puneet

[SnehasisTTPL]

Hi Puneet,

You can do it in SAS VA level.

1. new calculated column>Amounts in Crores=Actual amount/10000000

2.Create a new calculated column>Amounts in Lakhs=Actual amount/100000

[q5pham]

It took me a while to look for the solution to the same question you raised. Here is the code I found from http://robslink.com/SAS/democd18/mixture.sas and it perfectly works. In case some of you are still looking for it.

/* User-defined format to show million (or billion) format */
proc format;
     picture kmb
        0-999='000,009.9' (prefix='$')
        1000-999999='009k' (prefix='$' mult=1e-3)
        1000000-999999999='009m' (prefix='$' mult=1e-6)
        1000000000-high='000,000,009b' (prefix='$' mult=1e-9)
        ;
run;

.

[SAS_Explorer]

Hi @MichelleHomes, @q5pham

I'm also trying the same, Let me tell what all I did.

1. In SMC I've created a library pointing to "C:\SAS\Config\Lev1\SASApp\SASEnvironment\SASFormats"

2. Using the below code I've created a format

libname udfmt 'C:\SAS\Config\Lev1\SASApp\SASEnvironment\SASFormats';
proc format library = udfmt;
	picture INR low-high='00,00,00,00,000.00';
RUN;
data test1;
	a=54233521212;
  format a INR.;
run;

options fmtsearch=(udfmt);

3. I got a "formats.sas7dcat" file at the directory "C:\SAS\Config\Lev1\SASApp\SASEnvironment\SASFormats"

Now, How to register and deploy this catalogue at SAS Application Server so that I can use it in SAS VA?

Regards,

SAS Explorer

[TriciaAanderud]

Refer to this SAS note for guidance about using formats with the default library:

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