topic Re: billion or trillion conversion to crores and lakhs in SAS Visual Analytics

billion or trillion conversion to crores and lakhs

SnehasisTTPL — Tue, 28 Oct 2014 12:03:02 GMT

In SAS VA Report Builder for bar diagram, unit of axis are showing in billion or trillion ,I need to show it in 100 crore or 10

lakhs unit.

Re: billion or trillion conversion to crores and lakhs

TejaSurapaneni — Mon, 17 Nov 2014 08:38:32 GMT

Hi TTPL,

I Think there is no another option in Reports to covert billion or trillion into crores and lakhs using bar chart (Object).

Regards,

Teja Surapaneni

Re: billion or trillion conversion to crores and lakhs

MichelleHomes — Mon, 17 Nov 2014 08:51:13 GMT

Hi There,

If a SAS user-defined format has been configured in the associated SAS Application Server for your SAS Visual Analytics environment and also associated with the data item then it is available in SAS Visual Analytics. This is documented in the SAS(R) Visual Analytics 7.1: User's Guide

Kind Regards,

Michelle

Re: billion or trillion conversion to crores and lakhs

TejaSurapaneni — Mon, 17 Nov 2014 09:02:10 GMT

Hi Michelle,

I am also tried user-defined formats to convert millions to lacs but there is no use, The value is not changing millions to lacs (in Reports).

Thanks,

Teja

Re: billion or trillion conversion to crores and lakhs

MichelleHomes — Mon, 17 Nov 2014 09:21:22 GMT

Hi Teja,

You need to ensure the SAS formats catalog is registered in the SAS Application server and the user-defined format is set in the attributes for the data item's metadata. If the configuration is done as directed by the documentation it should work.

If it doesn't work for you then I suggest connecting to your SAS Application server using Enterprise Guide or some other SAS client and test it separate to the SAS Visual Analytics GUI. Perhaps your user-defined format was created in the SAS work formats catalog rather than a permanent library formats catalog.

Kind Regards,

Michelle

Re: billion or trillion conversion to crores and lakhs

TejaSurapaneni — Mon, 17 Nov 2014 09:35:09 GMT

Hi Michelle,

Can you explain little bit...

Thanks,

Teja.

Re: billion or trillion conversion to crores and lakhs

TejaSurapaneni — Mon, 17 Nov 2014 09:38:52 GMT

Hi Michelle,

The attached file is Actually what i am tried.

Re: billion or trillion conversion to crores and lakhs

MichelleHomes — Mon, 17 Nov 2014 09:56:11 GMT

Hi Teja,

From your screenshot you are selecting a SAS defined format. What I was suggesting was to create a SAS user-defined format based on the criteria you need to display crores and lakhs. This is achieved by using PROC FORMAT and ensure the format is created in a permanent catalog on the SAS Application Server. You may want to get your SAS Administrator involved to assist you with this.

Art's paper on PROC FORMAT may provide you some guidance http://www2.sas.com/proceedings/sugi29/236-29.pdf as well as the SAS documentation at Base SAS(R) 9.4 Procedures Guide, PROC FORMAT

Kind Regards,

Michelle

Re: billion or trillion conversion to crores and lakhs

TejaSurapaneni — Mon, 17 Nov 2014 11:15:57 GMT

Hi Michelle Thanks for your Reply,

It is possible in Reports or not?

if it is possible can you explain with one example,

Thanks,

Teja

Re: billion or trillion conversion to crores and lakhs

MichelleHomes — Mon, 17 Nov 2014 11:36:37 GMT

Hi Teja,

As I have previously mentioned, it is possible to use a SAS user-defined format in a Visual Analytics Report.

I am not familiar with the type of format you require for crores and lakhs. If you go through the paper I provided above there is PROC FORMAT code with the picture statement which you can use as an example to create the format you require. Then you need to set it up in your SAS Application Server as I mentioned in the above reply.

Once the SAS user-defined format has been created and deployed on the SAS Application Server, then your data item can refer to the format definition and your values will be in crores and lakhs rather than billions or trillions.

Kind Regards,

Michelle

Re: billion or trillion conversion to crores and lakhs

avinesh — Wed, 19 Nov 2014 06:04:48 GMT

Hi Michelle

Even I am also facing this same issue in VA 6,4.I tried with the user-defined format as you said but I am not able get the solution what I required.

Re: billion or trillion conversion to crores and lakhs

MichelleHomes — Wed, 19 Nov 2014 06:29:41 GMT

Hi,

Is it that your user-defined format not defined correctly? What is your PROC FORMAT code and what is it that you are hoping to achieve? With a better understanding of what you are using for your user-defined format and what your expected result should look like, the community may be able to assist.

Kind Regards,

Michelle

Re: billion or trillion conversion to crores and lakhs

MichelleHomes — Wed, 14 Jan 2015 07:25:13 GMT

Do you still require assistance with this request? Please mark question as answered correctly or helpful so that others know who may come across it in future.

Thanks,

Michelle

Re: billion or trillion conversion to crores and lakhs

puneetwadhwa85 — Thu, 26 Mar 2015 07:38:47 GMT

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

Re: billion or trillion conversion to crores and lakhs

SnehasisTTPL — Thu, 09 Jul 2015 09:47:08 GMT

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

Re: billion or trillion conversion to crores and lakhs

q5pham — Fri, 11 Sep 2015 12:57:22 GMT

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;

Re: billion or trillion conversion to crores and lakhs

SAS_Explorer — Fri, 13 May 2016 06:55:58 GMT

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

Re: billion or trillion conversion to crores and lakhs

TriciaAanderud — Thu, 02 Jun 2016 11:41:18 GMT

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

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

Re: billion or trillion conversion to crores and lakhs

ram1981mehta — Wed, 02 Aug 2017 22:01:30 GMT

Hi Michelle,

I was following your notes , please help me where I am going wrong.

/*Defination of format*/

libname FORLIB1 'C:\.................';

proc format lib=FORLIB1 ;
picture social (round)
1E03-<1000000='000K' (mult=.001 )
1E06-<1000000000='000.9M' (mult=.00001)
1E09-<1000000000000='000.9B' (mult=1E-08)
1E12-<1000000000000000='000.9T' (mult=1E-11);
run;

LIBNAME DATALIB 'C:\............';

DATA DATALIB .SAMPLE_INSIGHT;
SET DATALIB .insighttoy_notexta(OBS=1000);
FOR_TOTAL=ORDERTOTAL FORMAT SOCIAL.;
RUN;

I uploaded the DATALIB .SAMPLE_INSIGHT dataset in public autoloaded folder (sas trial version) , along with that I uploded the format social in the format folder.

When I use the SAMPLE_INSIGHT dataset in the designer , I can see the social format assigned to FOR_TOTAL column, and it is made as a category.

The possible values are 100M,20B.

My requirement is to add them up and display it at 20.1B.

I have attached the document
Thanks,
Ashish

Re: billion or trillion conversion to crores and lakhs

SASKiwi — Thu, 03 Aug 2017 20:47:09 GMT

As I understand it, once a user-defined format is applied to a column in VA it can only be used as a category in VA and cannot be used to customise measures as you appear to be doing.