Calcite | Level 5

## Re: billion or trillion conversion to crores and lakhs

Hi,

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

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,

PROC Star

## Re: billion or trillion conversion to crores and lakhs

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.

Calcite | Level 5

## Re: billion or trillion conversion to crores and lakhs

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

Fluorite | Level 6

## Re: billion or trillion conversion to crores and lakhs

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

Obsidian | Level 7

## Re: billion or trillion conversion to crores and lakhs

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;```

.

Obsidian | Level 7

## Re: billion or trillion conversion to crores and lakhs

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

Lapis Lazuli | Level 10

## Re: billion or trillion conversion to crores and lakhs

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

Tricia Aanderud