Hi all,
I'm wondering if you can help me. I have a data set that's transposed with the variables in rows and the dates in columns. first data point is in cell F7 and the row/variable names start in B7. Is there any way to read in the row name? I've read through several old threads and all I could find was reference to "byrow", and a suggestion to use the drop down menu and capturing the code. In both cases I've been unsuccessful.
Alternatively, if I do read the series in with their preset names "series01", "series02", "series03" and so on, is there an easy way to create a loop that renames all 40 series. I.e. rename "series01" "prime1", rename "series02" "prime2" and so on?
Any help greatly appreciated!
Import byrow
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Import byrow
Our import wizard has a "Read series by row" transpose option. This option appears on different pages, depending on the file type you're trying to import. For an Excel file, it appears on the first page. For a text file, it appears on the third.
Here's a static picture of the checkbox I'm talking about:
You should be able to select the column that has all of your variable names, but here's how you would rename "series01", "series02", etc. to "prime01", "prime02":
Steve
Here's a static picture of the checkbox I'm talking about:
You should be able to select the column that has all of your variable names, but here's how you would rename "series01", "series02", etc. to "prime01", "prime02":
Code: Select all
rename series* prime*
Steve
Who is online
Users browsing this forum: No registered users and 14 guests