BookmarkSubscribeRSS Feed
MarcelHaas
Calcite | Level 5

Hi all.

I have Categories X, that can have values X_1 and X_2 and Y, that can have values Y_1 and Y_2. The variable That I want is defined as the product of the fraction of all records for entity E that have X_1 and Y_1. For entity E I have many records. So for a given entity, I have many lines that in column X show either X_1 or X_2 and the same for Y, and in some graph I want 1 number per entity that has (number of X_1 for entity E divided by total number of records for E, times the number of Y_1 divided by the total number of records for E). Anyone has an idea of how I can do that?

Thanks in advance!

Marcel

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 0 replies
  • 704 views
  • 0 likes
  • 1 in conversation