Wednesday, February 24, 2021

how to use bysort with function total and tab

I have data include varables ( year , Event_Type , Loss_Amount__USD )

I want state to to sort the data by year , and with the year table I need the total of Loss_Amount__USD within that year for each year soeritly

I tried to do : bysort Settlement_Year: tab BIS_Event_Type___Level_1 , Total Loss_Amount__USD__Millions_
but that didn't work

Array

my data looks like :
Array

No comments:

Post a Comment