BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Haydn
Quartz | Level 8

Hi,

 

I have a Category called  "Current" with values of "Y" and "N". I have a measure called "Unique". Is it possible in SAS VA to create a New Aggregated Measure, by only have the value of "Current" being "Y" and returning the measure "Unique" where this condition has been met?

 

 

Cheers

Haydn

1 ACCEPTED SOLUTION

Accepted Solutions
SAS_Mike
Obsidian | Level 7

Hello Haydn,

 

I think I accomplished what you are looking for using a calculated item instead of aggregated measure.  Please take a look at the image I am attaching.

 

If( Current = "Y")

Return Measure

Else "" 

 

Leave else blank and it should interpret it as blank/return nothing.

 

Let me know if that doesn't work.

 

Mike


SAS Example 12-21-15.JPG

View solution in original post

4 REPLIES 4
SAS_Mike
Obsidian | Level 7

Hello Haydn,

 

I think I accomplished what you are looking for using a calculated item instead of aggregated measure.  Please take a look at the image I am attaching.

 

If( Current = "Y")

Return Measure

Else "" 

 

Leave else blank and it should interpret it as blank/return nothing.

 

Let me know if that doesn't work.

 

Mike


SAS Example 12-21-15.JPG
Haydn
Quartz | Level 8
Hi Mike,

Thanks for you reply. I tried your solution and under messages it shows up as, "Conversion required from: Character to: Numeric
SAS_Mike
Obsidian | Level 7

Hi Haydn,

 

It looks like you marked my response as accepted.  If you are having any trouble still let me know.  Perhaps include a screenshot if possible?  I think it was probably an error with the quotation marks.

 

Thanks,

 

Michael

Haydn
Quartz | Level 8
Hi Mike, yep all good, your solution worked. It was my error 🙂

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 4 replies
  • 1899 views
  • 1 like
  • 2 in conversation