Importing excel text for use as strings

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

bobh
Posts: 6
Joined: Wed Mar 20, 2013 6:49 pm

Importing excel text for use as strings

Postby bobh » Thu Mar 21, 2013 8:02 am

In 7.2, what is the best way to import text from an excel file as strings in Eviews? I've tried importing as Alpha series but I can't figure out how to assign individual alpha elements as a string. Thanks.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing excel text for use as strings

Postby EViews Gareth » Thu Mar 21, 2013 8:10 am

Yep, you'll have to read them in as alpha series, then use:

Code: Select all

string a = alpha(2)
to access the 2nd element of ALPHA etc..

bobh
Posts: 6
Joined: Wed Mar 20, 2013 6:49 pm

Re: Importing excel text for use as strings

Postby bobh » Thu Mar 21, 2013 8:39 am

I figured there was a simple solution that I was missing. Worked great. Thanks.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest