Page 2 of 2
Re: Transform annual data into monthly cumulative data
Posted: Wed Oct 24, 2018 3:50 pm
by Priscila
Yes, but from this variable I need to find the maximum value that another variable reaches during the month. This new variable must compare the value at time = 1 with the value at time = 0 and so on, always providing the maximum value.
Re: Transform annual data into monthly cumulative data
Posted: Wed Oct 24, 2018 4:05 pm
by Administrator
You already have all you need.
Code: Select all
maximum value in month = SAMPLE IF TRUE ( new month trigger = 1 :OR: maximum value in month < YOUR LEVEL , YOUR LEVEL , YOUR LEVEL )
Re: Transform annual data into monthly cumulative data
Posted: Wed Oct 24, 2018 6:02 pm
by Priscila
Problem solved.
Thank you.
Re: Transform annual data into monthly cumulative data
Posted: Wed Oct 24, 2018 6:52 pm
by Priscila
Sorry for the nuisance again, but there is some function that takes values over time for a given variable and provides the mean, for example:
variable X = 2,4,3,5,2,2
desired variable = 0,3,0,4,0,2
In this case the average of the variable X is calculated every two time intervals and presented.
Thank you once again.
Re: Transform annual data into monthly cumulative data
Posted: Thu Oct 25, 2018 11:15 am
by Administrator