unstacking only one country

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

dsdsdsdsd
Posts: 21
Joined: Sun Sep 06, 2020 7:33 pm

unstacking only one country

Postby dsdsdsdsd » Sat Nov 07, 2020 4:58 am

hello ...

my goal is to use only a single country, out of a panel data set, for the purpose of a single-country time series ...

I start with an excel file:
COUNTRY | VARIABLE | YR1980 | yr1981 | YR1982
---------------------------------------------------------------
japan | gdp | 111 | 112 | 113
france| gdp | 211 | 212 | 213
brazil | gdp | 311 | 312 | 313
japan | cpi | 121 | 122 | 123
france| cpi | 221 | 222 | 223
brazil | cpi | 321 | 322 | 323

I have imported it into a page, then stacked it ... of course it contains all the data ...

so now I want to unstack it ... but I would like to tell it to only pull out, say, "brazil" ...

and once it pulls out "brazil" data, the "brazil" identifier should no longer exist, as the final destination is time series ...

Is there a way to do this??

(alternative: only import "brazil" in the first place)

- thanks, Shannon

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: unstacking only one country

Postby startz » Sat Nov 07, 2020 8:00 am

Perhaps just

Code: Select all

smpl if country = "brazil"

dsdsdsdsd
Posts: 21
Joined: Sun Sep 06, 2020 7:33 pm

Re: unstacking only one country

Postby dsdsdsdsd » Sat Nov 07, 2020 9:41 am

hello ... thanks for responding ...

where would I include

Code: Select all

smpl if country = "brazil"
?

I am using the Proc/Reshape Current Page/Stack (Unstack) in New Page way of doing it ... but I do not think that I can add a command in the available forms ...

screenshot_eviews_11_07_20.png
screenshot_eviews_11_07_20.png (66.96 KiB) Viewed 15481 times

screenshot_eviews_11_07_20_02.png
screenshot_eviews_11_07_20_02.png (82.12 KiB) Viewed 15481 times

screenshot_eviews_11_07_20_03.png
screenshot_eviews_11_07_20_03.png (80.49 KiB) Viewed 15481 times

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: unstacking only one country

Postby startz » Sat Nov 07, 2020 9:45 am

Try Proc/Contract the current page to have Brazil only. Then you can do Proc/Restructure if you like.

dsdsdsdsd
Posts: 21
Joined: Sun Sep 06, 2020 7:33 pm

Re: unstacking only one country

Postby dsdsdsdsd » Sat Nov 07, 2020 9:55 am

that worked ...

I easily spent 3+ hours working trying to figure a way to do that last night ...

thank you


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 16 guests