EViews.com

Posted: **Thu Mar 23, 2017 2:04 am**

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 http://forums.eviews.com/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.

Posted: **Thu Mar 23, 2017 7:53 am**

Could you provide the file?

Posted: **Thu Mar 23, 2017 9:32 am**

Yes

Book1.xls: series names and description example; (23.5 KiB) Downloaded 531 times

Posted: **Thu Mar 23, 2017 9:42 am**

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

Posted: **Fri Mar 24, 2017 2:21 am**

Perfect. Cheers, Gareth

EViews.com

Import/read excel column as alpha series

Import/read excel column as alpha series

Re: Import/read excel column as alpha series

Re: Import/read excel column as alpha series

Re: Import/read excel column as alpha series

Re: Import/read excel column as alpha series