Search found 21 matches

by dsdsdsdsd
Sun Nov 08, 2020 1:20 pm
Forum: General Information and Tips and Tricks
Topic: mean of date series is 730114.4?
Replies: 4
Views: 15625

Re: mean of date series is 730114.4?

ok ... now I understand ... thanks
by dsdsdsdsd
Sun Nov 08, 2020 8:37 am
Forum: General Information and Tips and Tricks
Topic: mean of date series is 730114.4?
Replies: 4
Views: 15625

Re: mean of date series is 730114.4?

...I am not sure I understand the implications of that ...

if 1983 is stored as a number, then does that mean that it is stored as 1,983? ... and if so then wouldn't (1,983 + 1,984)/2 = 1,983.5?

- thanks ...
by dsdsdsdsd
Sat Nov 07, 2020 8:06 pm
Forum: General Information and Tips and Tricks
Topic: mean of date series is 730114.4?
Replies: 4
Views: 15625

mean of date series is 730114.4?

hello ...

I have a dateid series, with range from 1978-2020 ... the mean is 730114.4 ...

any thoughts?

- thanks, Shannon

screenshot_eviews_11_07_20_04.png
screenshot_eviews_11_07_20_04.png (111.22 KiB) Viewed 15594 times
by dsdsdsdsd
Sat Nov 07, 2020 9:55 am
Forum: General Information and Tips and Tricks
Topic: unstacking only one country
Replies: 4
Views: 15657

Re: unstacking only one country

that worked ...

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

thank you
by dsdsdsdsd
Sat Nov 07, 2020 9:41 am
Forum: General Information and Tips and Tricks
Topic: unstacking only one country
Replies: 4
Views: 15657

Re: unstacking only one country

hello ... thanks for responding ... where would I include 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_e...
by dsdsdsdsd
Sat Nov 07, 2020 6:54 am
Forum: General Information and Tips and Tricks
Topic: renaming series ... adding an increasing suffix
Replies: 1
Views: 13190

renaming series ... adding an increasing suffix

hello ...

I have series: yr05 , yr06 , ...

I want: yr1980 , yr1981 , ...

I have tried variations of:

Code: Select all

rename yr* @left( "yr" + @str( @val(*) + 1975)  ,  999 )


I am using @left simply because it returns ...

thanks
by dsdsdsdsd
Sat Nov 07, 2020 4:58 am
Forum: General Information and Tips and Tricks
Topic: unstacking only one country
Replies: 4
Views: 15657

unstacking only one country

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 fran...
by dsdsdsdsd
Mon Sep 14, 2020 11:12 am
Forum: General Information and Tips and Tricks
Topic: importing excel with blank cells: sometimes ellipses, sometimes NA's
Replies: 1
Views: 13038

Re: importing excel with blank cells: sometimes ellipses, sometimes NA's

SOLUTION:

the problem was that in he excel file the first row of data for the columns through 'O' were blank and so eViews was creating them as alpha columns/series ...
by dsdsdsdsd
Mon Sep 14, 2020 3:08 am
Forum: General Information and Tips and Tricks
Topic: importing excel with blank cells: sometimes ellipses, sometimes NA's
Replies: 1
Views: 13038

importing excel with blank cells: sometimes ellipses, sometimes NA's

hello ... I have imported an excel sheet and for some reason it is treating cells differently after the 'O' column (which is the 15th column) from excel ... in the picture you can see the excel sheet with four cells highlighted ... and in the right you can see those same cells highlighted, but with ...
by dsdsdsdsd
Mon Sep 14, 2020 3:01 am
Forum: General Information and Tips and Tricks
Topic: using upper() on a series?
Replies: 4
Views: 16196

Re: using upper() on a series?

aha ... fair enough ... thanks ...
by dsdsdsdsd
Fri Sep 11, 2020 10:27 am
Forum: General Information and Tips and Tricks
Topic: using upper() on a series?
Replies: 4
Views: 16196

Re: using upper() on a series?

aha ... slightly new question: as it turns out I was using that lowercase country as an ID for that table/page ... now that I created the uppercase version, country_U, I may as well get rid of the lowercase series ... but because it is an ID/index column I cannot ... is there a way of doing that?? -...
by dsdsdsdsd
Fri Sep 11, 2020 9:10 am
Forum: General Information and Tips and Tricks
Topic: using upper() on a series?
Replies: 4
Views: 16196

using upper() on a series?

hello ... I am attempting a copy() between two pages ... I believe the problem is case sensitivity between the @src and @dest ... I tried copy() ... ... @src @upper(country) ... where 'country' is the source series with lowercase, but of course upper() is not intended to work on a series ... copy() ...
by dsdsdsdsd
Wed Sep 09, 2020 5:07 pm
Forum: Programming
Topic: loop through series in a panel
Replies: 7
Views: 8030

Re: loop through series in a panel

that worked ...

thanks
by dsdsdsdsd
Wed Sep 09, 2020 10:44 am
Forum: Programming
Topic: loop through series in a panel
Replies: 7
Views: 8030

Re: loop through series in a panel

I am using copy to match merge ... but the src page does not have an id ... I looked under properties and options, but I couldn't find anything ... is there a default id name? copy(options) wf_src::pg_src\datasrc_country wf_dest::pg_dest\country ??? crossid screenshot_eviews_2.png
by dsdsdsdsd
Wed Sep 09, 2020 9:52 am
Forum: Programming
Topic: loop through series in a panel
Replies: 7
Views: 8030

Re: loop through series in a panel

ok... I will try that, but may I ask, please, is it possible to do it as I was attempting? I suppose this is really a question of: is it possible to iterate down a column in a panel?

- thanks ... I will update when I get the multi page effort to work ...

Go to advanced search