keep the frequency argument when importing data

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

gyw1028
Posts: 2
Joined: Sat Feb 27, 2016 7:57 pm

keep the frequency argument when importing data

Postby gyw1028 » Sun Feb 28, 2016 12:37 am

Dear all,
I want to create a workfile with frequency argument, and import excel data.
When I create a workfile by using the following code:
wfcreate test d5 2013-7-1 2014-8-31
I can obtain a workfile with frequency argument, just like picture one:
one.png
one.png (2.41 KiB) Viewed 1934 times
When I import excel data by using the following code:
wfopen d:\dpr.xls range="Sheet1!B2:C428" names=(purchase,redeem)
The frequency argument is disappeared, just like picture two:
two.png
two.png (1.71 KiB) Viewed 1934 times
How can I keep the frequency argument when I import excel data?
Thanks!

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

Re: keep the frequency argument when importing data

Postby EViews Gareth » Mon Feb 29, 2016 9:19 am

EViews obtains the frequency information from the Excel file. If there is no frequency information in the Excel file, EViews won't be able to find it, so you'll need to use the pagestruct command to impose it.

gyw1028
Posts: 2
Joined: Sat Feb 27, 2016 7:57 pm

Re: keep the frequency argument when importing data

Postby gyw1028 » Wed Mar 09, 2016 10:06 pm

EViews obtains the frequency information from the Excel file. If there is no frequency information in the Excel file, EViews won't be able to find it, so you'll need to use the pagestruct command to impose it.
Thank you very much :D


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 1 guest