Descriptions
Moderators: EViews Gareth, EViews Moderator
Descriptions
I am importing data into EViews from an excel file and I would like to import the associated descriptions. Some of the series are new and others were initially created in an EViews program file which did not include the descriptions. The descriptions are importing for all the new series but not for the pre-existing ones. Is there a way to import the descriptions from the excel files for the pre-existing series?
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13600
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Descriptions
We'll need more information. Providing the Excel file would be best.
Re: Descriptions
The series ygdpmp in the attached workfile was entered manually with no associated description. When it is re-imported via the excel file, the description does not appear for that series but a description does appear for the other series (ygdpmp2007cf) when it is imported via the same excel file. It seems that in the case of descriptions the initial entry supercedes the subsequent ones.
I am using the following command:
import(type=excel) C:\Users\whited\Desktop\test.xls range=Sheet1!a2:ai3 byrow namepos=first colhead=2 @freq a 1981
The workfile and the excel files are attached.
Thanks
I am using the following command:
import(type=excel) C:\Users\whited\Desktop\test.xls range=Sheet1!a2:ai3 byrow namepos=first colhead=2 @freq a 1981
The workfile and the excel files are attached.
Thanks
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13600
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Descriptions
Ah, I see. If the object already exists in the workfile into which you are importing, then the description is not overwritten. If you delete the existing object first, then do the import, it should work fine.
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 2 guests
