Hi,
I want to get an overview of the average returns (mean_port) for each portfolio number (change5) for each interest rate group (interest3). My data is as following:
I have tried the following code:
But that doesn't give me the desired results. Does someone know how to do this? The output should give 15 different summaries, for each level of interest3 (ranking 1 to 3) all values for each change5 (ranking 1 to 5).
Thanks
I want to get an overview of the average returns (mean_port) for each portfolio number (change5) for each interest rate group (interest3). My data is as following:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float time double mean_port float(change5 interest3) 738 3.04435198 5 1 739 2.2211704491304345 5 1 740 1.7787239991304349 5 1 741 4.260685091086957 5 1 742 3.9937772433695646 5 1 743 1.6834335358695651 5 1 472 4.030927347586207 1 2 473 2.6186064764406787 1 2 474 -1.3769768093103445 1 2 475 3.2940550017543857 1 2 476 5.25704224310345 1 2 518 4.716494105406251 1 2 519 5.318503456718752 1 2 520 1.316603170390626 1 2 521 4.144502554374999 1 2 522 5.156305800156249 1 2 523 3.893352732031249 1 2 524 2.517724156718751 1 2 525 3.813243186562501 1 2 526 1.5631468396874995 1 2 527 5.190297880781248 1 2 528 2.1100833622950823 1 2 529 4.41122791 1 2 530 3.0685434312903226 1 2 531 3.0657228609836062 1 2 532 1.7923587693650793 1 2 533 2.6580123563548392 1 2 534 2.617864592250001 1 2 535 2.7895783601666664 1 2 536 .5556802800000001 1 2 537 .16628890361016926 1 2 end format %tm time
Code:
foreach interest3 in interest3{
forvalues i=1/5 {
sum mean_port if (change5 == `i')
}
}
Thanks
Comment