BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
KOKIUSMAT
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee

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

View solution in original post

1 REPLY 1
Sam_SAS
SAS Employee

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 1 reply
  • 306 views
  • 1 like
  • 2 in conversation