Importing data from .csv files, prompt and matched dates

[fmramos]

Hi there, EV team!

A question about the "import" command. I'm trying to import a CSV file. Through visual clicks I managed well to import the data and asking the EV to read data and match dates in a d7 frequency. However, when I do it through a .prg file, I continue to receive the prompt asking to select, for instance, the import method (sequential, matched read, append to the end etc). Help files didn't help me in trying to avoid the prompt and simply saying to apply a matched read automatically. Any clues?

I'm doing something like:

import C:\xxx\xxxx\xxxx\file.csv ftype=ascii rectype=crlf skip=0 fieldtype=delimited custom=";" mult colhead=1 namepos=custom eoltype=pad badfield=NA @freq D7 @id @date(date) @destid @date @smpl @all

When inside the prompt window, I just have to click on "matched read". However, I'd like to impose this into the command, avoiding the prompt.

Any help is welcomed.


Tks, Fabio

[EViews Gareth]

Can you upload the file?

[fmramos]

Sure! Tks for the prompt replying, Gareth (and have a great year!).

File attached, ";" as columns delimiter. Dates in the format yyyymmdd. Best, Fabio.

[EViews Gareth]

Seems to work fine for me. Is your copy of EViews up to date?

fab.gif (1.53 MiB) Viewed 550 times

[fmramos]

So weird. I'm using EV13, 8 Jan build, which is the latest update, as per what I noticed. I keep getting a prompt as per the screenshot below :( I'm trying to figure out what is happening, too.

[EViews Gareth]

Try running it in an program, not as a command.

[fmramos]

It worked :)

I (think I) figured out what was going on. It works if the import process happens as an irregular file. So... I Need to regularize after. The series I get is mostly 5 (trading) days/week, but sometimes we have 7 days/week with empty cells, and some days with 5d/week with NA... So... The app can't read data as regular. The clash of regular vs. irregular data might cause problems. Better to add pagestruct(reg) for tons of series with daily data.

Well, a problem with data series standardization...

[EViews Gareth]

More specifically, when issuing a command, EViews presumes you're sat there willing to input something, so if there is a doubt about what's going on, EViews is more willing to prompt you with some options.

If you're running a program, EViews assumes you don't want to be prompted, so goes with a default.

[fmramos]

Image below.Tks.