Proc Expand without code

[mmagnuson]

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.

Thanks!

[tomrvincent]

yes.  tasks/time series/prepare time series data

[mmagnuson]

Thanks! so for Time ID Variable I'd do the "Month" then "Time Series Variable" I'd do the number I'm trying to add?

[mmagnuson]

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

[Reeza]

It should add a new column