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

SAS VA Interaction with 2 Datasets

Reply
Contributor
Posts: 23

SAS VA Interaction with 2 Datasets

Good morning, 

 

I am currently using v7.4 and trying to get a graph to show the distinct number of people who have the same code by income range. Due to size limitations, I cannot add additional variables to my detailed dataset. 

 

When I filter my report by code and year, I would like to get a count of the number of CUSTid by range to display in the graph. I was expecting to be able to link my datasets by YEAR and CUSTid but I can't seem to figure it out. Any ideas?

 

Original Dataset

details

CODEYEARCUSTidTOTAL_PAID
AAA2017123456100
AAA2017112233400
BBB2017123456350
BBB2017556677100
BBB2017778899100

 

Summary

YEARCUSTidGRAND_TOTAL
201712345645000
201711223310000
20175566778500
2017778899250
Ask a Question
Discussion stats
  • 0 replies
  • 60 views
  • 0 likes
  • 1 in conversation