Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

% sub total by categories in VAAR

Reply
Occasional Contributor
Posts: 5

% sub total by categories in VAAR

Hello There,

I need to create a field of "% base" in SAS VAAR, based on the subtotal of each category. I have three attributes of year_month, Control_ind and program flag. The % base will be based on the subtotal of year_month, control_target and program flag as follows.
 
Could you please suggest how I can do it in SAS VAAR? Many thanks for your help!
 
year_monthCONTROL_INDPROGRAM_FLAGTotal% base
201705   N1A908067.91%
  1B536874.68%
  1C209021.82%
  1D95800.83%
  1E123201.07%
  2A988358.61%
  2B13677111.91%
  2C56500.49%
  2D470784.10%
  2E43260.38%
  2F338392.95%
  3A25262322.01%
  3B1077779.39%
  4A453323.95%
  522840619.90%
 N Total 1147932100.00%
Super User
Super User
Posts: 9,829

Re: % sub total by categories in VAAR

Posted in reply to lilianmisofi

What is SAS VAAR?

Occasional Contributor
Posts: 5

Re: % sub total by categories in VAAR

SAS visual analytics without data explorer function

Ask a Question
Discussion stats
  • 2 replies
  • 167 views
  • 0 likes
  • 2 in conversation