BookmarkSubscribeRSS Feed
Calcite | Level 5

Godd morning all!

I have a VA Report in which I have lots of metrics grouped by Day, Hour and quarter of hour.

I neeed to compare the average of the values grouped by day with values of the previous day and calculate the delta.

I mean...

Let's suppose that metric average for 24/03/2015 is 10, the metric average for 25/03/2015 is 30, I need to show a row in a table in which I have:

DATE: 25/03/2015


DELTA: 20 (30 - 10)

%DELTA: 66,67% [100*(30 - 10)/30]

If I could calculate easily VALUE_FOR_YESTERDAY I'll achieve the goal!

I try to use pre-defined functions like Difference for previous period using Date, by I suppose that I can use it only to compare one day with the previous Month...

Can you help me?

Fluorite | Level 6

If you want to calculate with the previoud row.. then it is better to use LAG funtion. or DIF

Calcite | Level 5

Thank you for your quick answer...

Can you explain me a little more about LAG and DIF functions?

Fluorite | Level 6

LAG function is something which refers to the previous row.

for ex:

Name    Age

A           20

B          50

C         40

New= age-lag(age)

this gives you

Name    Age    New

A           20      .

B          50      30

C         40      10

And DIF is ,you can directly write the function DIF(age) you get the difference.

With Lag you can do any calculation with the previous row. and also with the previous row of any variable with the present row,

Calcite | Level 5

Thank you very much!!!

Let me try your solution

Quartz | Level 8


dif and lag do NOT exist in visual analytics in either the create aggregated measure or create calculated item sections.




Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 5 replies
  • 3 in conversation