Desktop productivity for business analysts and programmers

Proc Expand without code

Reply
Contributor
Posts: 50

Proc Expand without code

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!

Frequent Contributor
Posts: 149

Re: Proc Expand without code

Posted in reply to mmagnuson

yes.  tasks/time series/prepare time series data

Contributor
Posts: 50

Re: Proc Expand without code

Posted in reply to tomrvincent

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?

Contributor
Posts: 50

Re: Proc Expand without code

Posted in reply to 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

 

 

Super User
Posts: 22,820

Re: Proc Expand without code

Posted in reply to mmagnuson

It should add a new column

Ask a Question
Discussion stats
  • 4 replies
  • 155 views
  • 0 likes
  • 3 in conversation