Naming unstacked series

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

jthodge
Posts: 77
Joined: Tue Oct 21, 2008 5:52 am

Naming unstacked series

Postby jthodge » Fri Mar 11, 2011 12:14 pm

I have a simple question. How do I unstack data without having the name of the unstacked series included in the names of the new series? (i.e. I just want the new series to take on the associated values of the unstacking identifier). For example, I would like to transform the unstructured workfile:
DATEID VARCODE QUANTITY
1994M01 COPR_AA 69.000000
1994M02 COPR_AA 76.000000
1994M03 COPR_AA 71.000000
1994M04 COPR_AA 83.000000
1994M05 COPR_AA 79.000000
1994M06 COPR_AA 65.000000
1994M07 COPR_AA 75.000000
1994M08 COPR_AA 80.000000
1994M09 COPR_AA 75.000000
1994M10 COPR_AA 71.000000
1994M11 COPR_AA 67.000000
1994M12 COPR_AA 69.000000

to a monthly workfile:
OBS COPR_AA
1994M01 69.000000
1994M02 76.000000
1994M03 71.000000
1994M04 83.000000
1994M05 79.000000
1994M06 65.000000
1994M07 75.000000
1994M08 80.000000
1994M09 75.000000
1994M10 71.000000
1994M11 67.000000
1994M12 69.000000

How would I phrase the pageunstack command to do this? I am using Eviews 7.1

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Naming unstacked series

Postby EViews Gareth » Fri Mar 11, 2011 12:27 pm

Not sure it is possible. You'll have to use the rename command afterwards

jthodge
Posts: 77
Joined: Tue Oct 21, 2008 5:52 am

Re: Naming unstacked series

Postby jthodge » Fri Mar 11, 2011 12:38 pm

That's the strategy that I'm using as a work-around:
rename quantity* *
(after deleting the "quantity" group that is created during unstacking process)

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Naming unstacked series

Postby EViews Gareth » Fri Mar 11, 2011 12:43 pm

Yep.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests