BookmarkSubscribeRSS Feed
lilianmisofi
Calcite | Level 5

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%
2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

What is SAS VAAR?

lilianmisofi
Calcite | Level 5

SAS visual analytics without data explorer function

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 1265 views
  • 0 likes
  • 2 in conversation