Search found 21 matches
- 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
- 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 ...
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 ...
- 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
I have a dateid series, with range from 1978-2020 ... the mean is 730114.4 ...
any thoughts?
- thanks, Shannon
- 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
I easily spent 3+ hours working trying to figure a way to do that last night ...
thank you
- 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...
- 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:
I am using @left simply because it returns ...
thanks
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
- 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...
- 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 ...
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 ...
- 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 ...
- 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 ...
- 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?? -...
- 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() ...
- 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
thanks
- 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
- 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 ...
- thanks ... I will update when I get the multi page effort to work ...