Hi,
I created a program to import some series from an Excel file.
Basically, the import code is built that way:
import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector","Sector","Last Updated","Index","Description") na="#N/A" @freq M @id @date(earliest_top) @destid @date @smpl @all
It works but when I open the workfile and refresh the series (automatic update), I get this error message: "EARLIEST_TOP is not defined in "IMPORT(MODE=UO)"
How can I solve this issue ?
Regards
Automatic update of a workfile based on Excel files
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13330
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Automatic update of a workfile based on Excel files
Could you provide the file?
Follow us on Twitter @IHSEViews
Re: Automatic update of a workfile based on Excel files
The file is based on data from IHS Markit (for information).
Regards,
Cecile
Regards,
Cecile
- Attachments
-
- PMI_ALL_composite.xlsx
- (586.72 KiB) Downloaded 30 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13330
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Automatic update of a workfile based on Excel files
Appears to work ok for me. Is there something else you're doing?
- Attachments
-
- pmi.gif (3.59 MiB) Viewed 416 times
Follow us on Twitter @IHSEViews
Re: Automatic update of a workfile based on Excel files
Thank you! I tried and it works for me that way as well too.
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040
Who is online
Users browsing this forum: No registered users and 8 guests