Search found 20 matches

by centroid
Fri May 05, 2023 1:58 am
Forum: Data Manipulation
Topic: convert Date series into Series indicating Year/Quarter
Replies: 1
Views: 3730

convert Date series into Series indicating Year/Quarter

I would like to turn a Series containing dates in the format yyyy-mm-dd(as an example "2023-05-05") into a series of Years-Quarters in the format yyyyQq (as an example "2023Q2"). How can I do this?

I tried different things, but with no success.
by centroid
Fri Sep 24, 2021 8:57 am
Forum: Suggestions and Requests
Topic: large-scale macro-model database
Replies: 1
Views: 44288

large-scale macro-model database

I would like to know whether there exists a publicly available large-scale macroeconomic model database shared and curated by Eviews users? For example, a multi-country model that would be calibrated from data downloaded from FRED or OECD sources or other freely available sources would be very usefu...
by centroid
Mon Aug 02, 2021 12:11 am
Forum: Data Manipulation
Topic: resize current page - inserting observations message
Replies: 1
Views: 8578

resize current page - inserting observations message

I have a question. My initial workfile is indexed through cross-section identifiers. Now I run Proc-Structure/Resize-Current-Page in order to convertthe page structure into a panel. I am getting the message "Resize involes inserting 1 observation". Why is this happening? How can I avoid th...
by centroid
Thu Jul 01, 2021 1:02 am
Forum: Data Manipulation
Topic: Crash when opening a very big Eviews file - Troubleshooting
Replies: 2
Views: 9573

Crash when opening a very big Eviews file - Troubleshooting

I have a big Eviews file (330 MB; wf1). It downloads data from ODBC sources. It consists of various pages which were interlinked through automatically updated series. Eviews 12 on Windows 10 is installed. I had various file backups, in order to restore the data if something goes wrong. The problem s...
by centroid
Mon Jun 28, 2021 4:29 am
Forum: Data Manipulation
Topic: formula updated automatically - including an if statement
Replies: 1
Views: 8660

formula updated automatically - including an if statement

In properties - values - formula (in a series object) automatically updated arithmetic transformations can be performed taking other series as inputs. Can I include somehow "if/else"-statements in order to make case distinctions in properties - values -formula?
by centroid
Tue Jun 08, 2021 2:14 pm
Forum: Data Manipulation
Topic: "integrate" a time series variable
Replies: 3
Views: 10637

"integrate" a time series variable

How do I sum a time series variable through a command which I could use in a formula link? My idea is to use a command for a discrete time version of an integral S(t)=Integral_{t_0}^t s(t) dt, given a time series whose increment should be added up, given some initial value. I would prefer to avoid s...
by centroid
Wed Mar 17, 2021 4:55 am
Forum: Data Manipulation
Topic: pagestack with links to original data for automatic update
Replies: 1
Views: 8473

pagestack with links to original data for automatic update

I have a page with quarterly data, linked to an external database (DBnomics). Now, I would like to create a panel page, linked to the quarterly data. I used the command "pagestack poolname @ series1 series2 series3". I cannot create a link for automatic update, if new data is added in the ...
by centroid
Thu Mar 04, 2021 7:06 am
Forum: Data Manipulation
Topic: extract year of each observation from series
Replies: 1
Views: 8757

extract year of each observation from series

I have a series with date entries. The data is "unstructured" and therefore not sorted by this date series. How do I extract the year and/or the month of each observation? As a result I would like to get self-updating series, containing the year and month of the observation in one or two s...
by centroid
Mon Mar 01, 2021 6:29 pm
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

Re: ODBC 32-bit databases and Eviews 12

Thanks, that worked.
by centroid
Mon Mar 01, 2021 7:10 am
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

Re: ODBC 32-bit databases and Eviews 12

Unfortunately, the numbers are still not imported correctly.

Another question: how do I import the series from ODBC as characters? My ODBC is read-only.
by centroid
Mon Mar 01, 2021 2:11 am
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

Re: ODBC 32-bit databases and Eviews 12

I could narrow down the problem as follows and summarize what I have done so far: - my data series in ODBC has two additional decimal numbers after the comma (something like 90.00 or 90.50 for example) - it is correctly displayed in MS Query whilst in the Eviews import wizard - it is considered as n...
by centroid
Sun Feb 28, 2021 4:25 pm
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

Re: ODBC 32-bit databases and Eviews 12

How do I set Eviews numerics to comma separation instead of period separation?
by centroid
Sat Feb 27, 2021 4:50 pm
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

ODBC and import of non-integer numbers

I am importing also non-integer numbers from an ODBC database. In the preview in Microsoft query it looks all fine, but after importing the respective columns, the numbers somehow get crunched into something extremely big, seemingly of integer type. How can I solve this problem?
by centroid
Fri Feb 26, 2021 2:05 am
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

Re: ODBC 32-bit databases and Eviews 12

In the meanwhile I found an old download of 32-bit Eviews 9 Enterprise.

Another question: How do I import german letters (ö,ä,ü) into an Eviews Workfile from an ODBC database?
by centroid
Thu Feb 25, 2021 2:47 pm
Forum: Data Manipulation
Topic: ODBC 32-bit databases and Eviews 12
Replies: 16
Views: 28415

Re: ODBC 32-bit databases and Eviews 12

I am not sure, I use also another application with these 32-bit ODBC databases, as well. I have to ask our IT adviser. I remember we had difficulty installing the 64-bit versions of the drivers.

Go to advanced search