Problem with wildcard

[kkeough]

I am having a problem with my eview program.

'-----OPEN DATA BASE----'
dbopen A:\Regional_Studies\Regional_Banks\Historical_Banks\Moodys_11-4-13_BANKS\ca_county_banks\ca_wages.bnk

'-----Create Workfile----'
WORKFILE KernNAICSwage.WF1 A 1981 2030

'-----Get the Data----'
FETCH CA_WAGES::RYPEW????ACA029

When I run it I get the error, CA_WAGES::RYPEW????ACA029 was not found in "FETCH CA_WAGES::RYPEW????ACA029

However, if I put in individual variables like RYPEW1133ACA029 or RYPEW2111ACA029it pulls them.

What am I doing wrong?
Thanks!

[EViews Jason]

When fetching from database use * for the wildcard character.

Code: Select all

FETCH CA_WAGES::RYPEW*ACA029

should work for you

[kkeough]

I get the same error message. Do I just need to do each one individually instead of using a wildcard? I used it in the command box and wrote a program and ran it through the program, neither worked.

[EViews Jason]

What is the build date and version of your EViews copy (help->about EViews)?

You should also make sure you are up to date (help->EViews update)

[kkeough]

It says Standard Edition - Jan 21 2014 build.
I tried to do the update, but it said no updates avaiable

[kkeough]

Sorry I forgot the edition, I am running Eviews 8.

[kkeough]

I can just pull every NAICS code individually. I was just wondering why the wildcard wasn't working. It has always worked for me before and has worked for the other databanks.

I was thinking it maybe a problem with the data feed, but since I can pull them individually it seems strange.

[EViews Jason]

Because you are using an Aremos database, fetching with wildcards is a bit complicated. In the database window, if you press the 'All' button you will see all the series in the database. Aremos mnemonics are usually of the form seriesname.freq. Append to the end of your query string the series freq. For example:

Code: Select all

FETCH CA_WAGES::RYPEW*ACA029.q

[kkeough]

That was it, thank you so much!