Hello,
I have an Eviews database that contains data series in a few different frequencies. I would like to export the entirety of this database into Excel files based on the frequency. For example, 3 output files for Annual, Quarterly, Monthly.
I am thinking the best way to do this would be to have an if/else statement checking the frequency attributes before adding the series to separate groups in preparation for export. However, I am having issues checking the frequency. First and foremost, is this the right approach?
I am unable to use this syntax to find the frequency of a series in a database (not defined or illegal command):
%frequency_string = DATABASE_NAME::SERIES_NAME.@attr("Freq")
However bringing the series into a workfile first also won't work since the frequency attribute of any series added to a workfile will automatically be changed to the frequency of that workfile as well (even if unstructured).
Thank you for taking the time to look into this. It is much appreciated.
PS - I could PROC -> copy the database to Aremos TSD text file and read that way, but this chops off descriptions that are too long and this is undesirable. Is there a similar function that would fully retain the attributes of the series?
Exporting Entire Database to Excel file
Moderators: EViews Gareth, EViews Moderator
-
- Posts: 5
- Joined: Fri Oct 14, 2022 3:31 pm
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Exporting Entire Database to Excel file
You could use the wquery command to ask the database to return you a list of all series that are annual, fetch them, save them to Excel. Then do the same for quarterly, and so on.
Follow us on Twitter @IHSEViews
-
- Posts: 5
- Joined: Fri Oct 14, 2022 3:31 pm
Re: Exporting Entire Database to Excel file
Thank you Gareth :)
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: Google [Bot] and 8 guests