When I create an aggregated measure, I realized that I I can't call that measure in the advanced filter dialog box. The solution I found was to import that aggregated measure as part of an aggregated data source then create an advanced filter with the measure. Even then, I realized that SAS VA cannot filter a list based on the value of the agregated measure. For example, in your videa at 20:12 : in the list that is aggregated by month: how can you filter out the rows where the Unit Yield (rate) as shown in the list is less than 85%? I have been struggling with this for 3 days now and it seems like it's not possible in SAS VA 8.5
A great resource for you is our SAS Communities 2.sas.com/6053wVCYR. These communities are a service hosted by SAS to facilitate the exchange of technical information pertaining to SAS products, services and best practices. For assistance with getting answers fast, click here 2.sas.com/6054wVCYr to see some helpful tips on how to post a great question! If you are not able to find the assistance you need, please feel free to speak with Technical Support by calling 800-727-0025, option 2.
great demo
Very clear, thank you!
Glad it was helpful!
When I create an aggregated measure, I realized that I I can't call that measure in the advanced filter dialog box. The solution I found was to import that aggregated measure as part of an aggregated data source then create an advanced filter with the measure. Even then, I realized that SAS VA cannot filter a list based on the value of the agregated measure. For example, in your videa at 20:12 : in the list that is aggregated by month: how can you filter out the rows where the Unit Yield (rate) as shown in the list is less than 85%? I have been struggling with this for 3 days now and it seems like it's not possible in SAS VA 8.5
A great resource for you is our SAS Communities 2.sas.com/6053wVCYR. These communities are a service hosted by SAS to facilitate the exchange of technical information pertaining to SAS products, services and best practices. For assistance with getting answers fast, click here 2.sas.com/6054wVCYr to see some helpful tips on how to post a great question! If you are not able to find the assistance you need, please feel free to speak with Technical Support by calling 800-727-0025, option 2.