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
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.
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.
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.
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 )
LIBNAME DATALIB 'C:\............';
DATA DATALIB .SAMPLE_INSIGHT;
SET DATALIB .insighttoy_notexta(OBS=1000);
FOR_TOTAL=ORDERTOTAL FORMAT SOCIAL.;
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
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.