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.
Search found 20 matches
- Fri May 05, 2023 1:58 am
- Forum: Data Manipulation
- Topic: convert Date series into Series indicating Year/Quarter
- Replies: 1
- Views: 3729
- 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...
- Mon Aug 02, 2021 12:11 am
- Forum: Data Manipulation
- Topic: resize current page - inserting observations message
- Replies: 1
- Views: 8577
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...
- 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...
- 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?
- Tue Jun 08, 2021 2:14 pm
- Forum: Data Manipulation
- Topic: "integrate" a time series variable
- Replies: 3
- Views: 10636
"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...
- 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 ...
- 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...
- 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.
- 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.
Another question: how do I import the series from ODBC as characters? My ODBC is read-only.
- 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...
- 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?
- 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?
- 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?
Another question: How do I import german letters (ö,ä,ü) into an Eviews Workfile from an ODBC database?
- 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.