Search found 24 matches

by pelleenglund
Mon Jun 12, 2023 12:36 am
Forum: Programming
Topic: Convert panel data to time series
Replies: 3
Views: 3239

Re: Convert panel data to time series

But I get this result (see attachment), but only for annual data. For quarterly data, I get time series format.
by pelleenglund
Fri Jun 09, 2023 5:41 am
Forum: Programming
Topic: Convert panel data to time series
Replies: 3
Views: 3239

Convert panel data to time series

Hello, When I import quarterly panel data and use the "Unstack" command to convert it to time series, it works excellent. But when I do the same with annual panel data, it takes the form of a unstructured page instead of a dated page with frequency "annual". Is this a bug or am I...
by pelleenglund
Thu Feb 03, 2022 6:06 am
Forum: Data Manipulation
Topic: Import Linux based table
Replies: 3
Views: 5373

Re: Import Linux based table

Thanks Jason. Apparently, I can't attach file with extension .px. Can I email them?
by pelleenglund
Wed Feb 02, 2022 8:38 am
Forum: Data Manipulation
Topic: Import Linux based table
Replies: 3
Views: 5373

Import Linux based table

Hello, I am trying to import a px table that has been created in Linux. It works fine, except that some special Swedish letters (å, ä and ö) translates into e.g. Ã¥. If I import the same table that has been created in Windows, this does not happen, and it works excellent. The simple code I use is: T...
by pelleenglund
Fri Apr 03, 2020 1:41 am
Forum: Data Manipulation
Topic: Percentage change with daily data
Replies: 1
Views: 3434

Percentage change with daily data

Hi,

It seems that you can't use funcions such as @pcy with daily data. Do you know if that is possible in any other way? One way is off course to use a loop and calculate it but it would be very much appreciated if there is any other solution to this.

Best regards,
Pelle
by pelleenglund
Tue Oct 29, 2019 8:28 am
Forum: Bug Reports
Topic: Minus sign disappears to Excel
Replies: 5
Views: 9032

Re: Minus sign disappears to Excel

I have now tried to change the decimal separator to "." in Excel and then it works fine. But previously it also worked with "," which is the standard we are using.
by pelleenglund
Tue Oct 29, 2019 7:55 am
Forum: Bug Reports
Topic: Minus sign disappears to Excel
Replies: 5
Views: 9032

Re: Minus sign disappears to Excel

No the minus signs aren't ok then either, so maybe it's Excel one should blame then.
I just wonder what could happened with the new Office version :roll:
by pelleenglund
Tue Oct 29, 2019 1:55 am
Forum: Bug Reports
Topic: Minus sign disappears to Excel
Replies: 5
Views: 9032

Re: Minus sign disappears to Excel

It has always occurred with Office 365. But it works fine if you paste it into the command window and Notepad, then the minus signs remain.
by pelleenglund
Thu Oct 24, 2019 7:14 am
Forum: Bug Reports
Topic: Minus sign disappears to Excel
Replies: 5
Views: 9032

Minus sign disappears to Excel

Hello, When simply copying (with Ctrl+ C and Ctrl+ V) a series from Eviews 11 (version Sep 17) to Excel the minus sign disappears if the value is greater than -1 but not otherwise. That is, -0.8 becomes 0,8 -2 becomes -2 (as it should) The Office version we are using is 365 ProPlus, and we're also u...
by pelleenglund
Fri Sep 27, 2019 1:57 am
Forum: Data Manipulation
Topic: Sort panel data
Replies: 3
Views: 6199

Re: Sort panel data

Thanks for ýour answer.

The reason I asked had to do with the new geomap objects. It doesn't seem to connect the map id (e.g. a municipality code) with the corresponding code in the dataset for a panel. But it works fine if you only look for one year separately.

/Pelle
by pelleenglund
Thu Sep 26, 2019 5:50 am
Forum: Data Manipulation
Topic: Sort panel data
Replies: 3
Views: 6199

Sort panel data

Hello, I wonder if one could sort panel data in Eviews by year instead of ID (see example below)? Right now I can only get all years for the first ID, then all years for the next and so on. ID Year Series 1 1995 12 2 1995 .. 3 1995 .. 1 1996 .. 2 1996 3 1996 1 1997 2 1997 3 1997 Best regards, Per
by pelleenglund
Fri Feb 08, 2019 2:55 am
Forum: Programming
Topic: Change auto aspect ratio
Replies: 1
Views: 2282

Change auto aspect ratio

Hi,

I wonder if you could change the auto aspect ratio in graphs with code instead of clicking on each graph and change it manually? Couldn't find anything in the help guide.

Best regards,
Per
by pelleenglund
Mon Sep 17, 2018 5:51 am
Forum: Suggestions and Requests
Topic: Extract legend from graph object
Replies: 1
Views: 8981

Extract legend from graph object

Hi!

Is there a way to extract the legend from a graph object? You can get the series with the "Makegroup"-command, but something similar for the legend would be great!

Best regards,
Pelle
by pelleenglund
Wed Jun 27, 2018 12:16 am
Forum: Suggestions and Requests
Topic: Zero disappears with round
Replies: 2
Views: 6639

Re: Zero disappears with round

Oh missed that argument, thanks a lot!
by pelleenglund
Tue Jun 26, 2018 4:21 am
Forum: Suggestions and Requests
Topic: Zero disappears with round
Replies: 2
Views: 6639

Zero disappears with round

Hi,

I wonder if there is a way that I can get the zero to show upp when using @round with one decimal? To illustrate what I mean, this code will prompt up 2, but I would like 2.0.

!i = 2.04
!j = @round(!i, 1)
@uiprompt(@str(!j))

Best regards,
Pelle

Go to advanced search