01-25-2018 02:45 PM
Is it possible to use proc expand with SAS EQ using GUI? I've already built out a large query and don't want to throw a random program in the middle of it.
I'm trying to get YTD numbers for example if I have 4 in January and 5 in February then my YTD in February would be 9.
01-25-2018 03:48 PM
I used "Create Time Series Data" but when I chose "Interval" as "Month (DATE) it still displays Jan Feb March April May as their own values I.ei. (5, 4, 1, 3, 6) instead of 5, 9, 10, 13, 19