Hello,
I am trying to attach the description and units to a group of series.
I would like to read the names of the series, descriptions and units from an excel file to 3 alpha series in an attribute change (to follow what's described in viewtopic.php?t=4369).
The excel file looks as follows:
A B C
1 ser_1 desc_1 units_1
2 ser_2 desc_2
3 ser_3 desc_3 units_3
I have been trying with the import and read functions but so far haven't managed.
Could you please give me some guidance on how to do the import?
Thank you in advance.
Import/read excel column as alpha series
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Import/read excel column as alpha series
Could you provide the file?
Follow us on Twitter @IHSEViews
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Import/read excel column as alpha series
Assuming your data page is called "Untitled":
Code: Select all
pageload(page=attr) book1.xls colhead=1
pageselect untitled
importattr(mode=overwrite, name=names) attr
Follow us on Twitter @IHSEViews
Re: Import/read excel column as alpha series
Perfect. Cheers, Gareth
Who is online
Users browsing this forum: EViews Steve and 23 guests