Hi There, I have sourced two different data sets. One is quarterly and one is monthly. The quarterly data contains dates that are end of each quarter. I have used Proc Expand to convert the monthly data in quarterly. However upon converting the stored date value is different and even though i'm putting in 'observed=end' the stored date value is actually the beginning of the quarter. Therefore when i merge there are multiple entries for each quarter. Below is the merged dataset When i change the date format to show the full date it is Is there command i can run to make one row for each quarter? Thanks
... View more