Help with Aggregated Measure

[Haydn]

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

[SAS_Mike · Accepted solution]

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

[Haydn]

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]

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]

Hi Mike, yep all good, your solution worked. It was my error 🙂