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, ... View more

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/sample-report.html   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, ... View more

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   ... View more

Hi,   I used your guidelines . proc format lib=TTT; 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; DATA sample; SET insighttoy_notexta(OBS=1000); formatted_total=ORDERTOTAL;   format formatted_total social.; RUN;   I uploaded the sample dataset to sas va, then when I am using the same in SAS VA designer the system is recognize the social format and I can see 1mi, 2mi figures.   The problem is that I cannot convert it to measure  i.e. I want to display the total of 1m + 2m as 3m . I am getting 2 different rows of 1mi and 2mi .   Any suggestions.   Thanks, Ram     ... View more

Hi,   I used your guidelines . proc format lib=TTT; 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; DATA sample; SET insighttoy_notexta(OBS=1000); formatted_total=ORDERTOTAL;   format formatted_total social.; RUN;   I uploaded the sample dataset to sas va, then when I am using the same in SAS VA designer the system is recognize the social format and I can see 1mi, 2mi figures.   The problem is that I cannot convert it to measure  i.e. I want to display the total of 1m + 2m as 3m . I am getting 2 different rows of 1mi and 2mi .   Any suggestions.   Thanks, Ram ... View more