HI,
I want to convert in a String variable the number variable that is result of a difference between two period calculated with function RelativePeriod .
Example: 1 = "positive" ; -1 = "negative" etc
But it's not possible because it is a aggregate calculated. Is there a solution?
Then I want to insert a parameter in the "offset interval" but it accepts only numbers. Is there a solution?
Thanks
Hello,
I don't think you can make the output of RelativePeriod into a string, sorry.
For what it is worth, you can apply display rules to aggregated measure values. So you could highlight the positive/negative differences.
A workaround that is sometimes suggested when working with aggregated values is to create an aggregated data source to store the aggregated values.
For the offset parameter, I believe you could do something very inelegant like this:
IF ( 'Param'p = 1 )
RETURN <RelativePeriod expression with offset 1>
ELSE IF ('Param'p =2 )RETURN <RelativePeriod expression with offset 2>
ELSE IF ('Param'p =3 )
RETURN <RelativePeriod expression with offset 3>
And so on.
You could give it a try.
Let us know if that helps.
Thanks,
Sam
Hello,
I don't think you can make the output of RelativePeriod into a string, sorry.
For what it is worth, you can apply display rules to aggregated measure values. So you could highlight the positive/negative differences.
A workaround that is sometimes suggested when working with aggregated values is to create an aggregated data source to store the aggregated values.
For the offset parameter, I believe you could do something very inelegant like this:
IF ( 'Param'p = 1 )
RETURN <RelativePeriod expression with offset 1>
ELSE IF ('Param'p =2 )RETURN <RelativePeriod expression with offset 2>
ELSE IF ('Param'p =3 )
RETURN <RelativePeriod expression with offset 3>
And so on.
You could give it a try.
Let us know if that helps.
Thanks,
Sam
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.