Hello,
I have text file in the following format:
isin startdate enddate volume art
xyz 2002q1 2006q3 100 10
zas 2001q1 2016q3 200 50
...
I would like to have import this file and create time series for every isin from the start to enddate. The variables volume and art should be the same for every single observation. How can I accomplish this?
Thanks.
Import data with start and end date in columns
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Import data with start and end date in columns
Do you wish them to be on the same page (meaning that there are lots of NAs given the differing start dates and end dates) or different pages?
Are they all the same frequency?
Are they all the same frequency?
Follow us on Twitter @IHSEViews
Re: Import data with start and end date in columns
Yes, I would like to have them on the same page.
Yes, the frequency is always quartely; data range is from 2003 to 2016.
Yes, the frequency is always quartely; data range is from 2003 to 2016.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Import data with start and end date in columns
Code: Select all
wfcreate q 2003 2016
%list = @wread("c:\temp\test.txt")
for %ser {%list}
%sname = @word(%ser,1)
%start = @word(%ser,2)
%end = @word(%ser,3)
%vol = @word(%ser,4)
%art = @word(%ser,5)
smpl {%start} {%end}
series {%sname}_vol = @val(%vol)
series {%sname}_art = @val(%art)
smpl @all
next
Follow us on Twitter @IHSEViews
Re: Import data with start and end date in columns
Thanks a lot!
Who is online
Users browsing this forum: No registered users and 23 guests