How can I stack data into pivot form

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

chairake
Posts: 9
Joined: Fri Nov 30, 2018 9:31 pm

How can I stack data into pivot form

Postby chairake » Tue Jan 08, 2019 2:36 am

Hi,

I would like to know is there a way to command time series data into stack data like pivot form as example below

If I can command directly to simple platform as I show in the picture please tell me.

thank you so much

Chairat

-----------------------------------------------------------------------------------------
I have 3 form of sale data in different material and region
vol_(*)_(**)
Growth_(*)_(**)
MA3_(*)_(**)

while (*) are names of material that are a,b,c,d
(**) are region that are wk,me,e,w,n,ne,s

Here is the stack data form I want
ID01 Var01 (Material) Var02 (Region) Vol Growth MA3
2000m1 A wk 100 2% 1%
2000m2 A wk 110 1% 0%
...
...
...
2018m12 A wk 200 5% 0%
2000M1 B wk 500 4% -3%
.....

and so on
Attachments
Capture.PNG
Capture.PNG (12.62 KiB) Viewed 145 times

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 6 guests