Page 1 of 1

Problem with wildcard

Posted: Wed Jan 29, 2014 3:26 pm
by 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!

Re: Problem with wildcard

Posted: Wed Jan 29, 2014 5:17 pm
by EViews Jason
When fetching from database use * for the wildcard character.

Code: Select all

FETCH CA_WAGES::RYPEW*ACA029
should work for you

Re: Problem with wildcard

Posted: Wed Jan 29, 2014 5:21 pm
by 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.

Re: Problem with wildcard

Posted: Thu Jan 30, 2014 1:08 pm
by 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)

Re: Problem with wildcard

Posted: Thu Jan 30, 2014 3:54 pm
by kkeough
It says Standard Edition - Jan 21 2014 build.
I tried to do the update, but it said no updates avaiable

Re: Problem with wildcard

Posted: Thu Jan 30, 2014 3:57 pm
by kkeough
Sorry I forgot the edition, I am running Eviews 8.

Re: Problem with wildcard

Posted: Thu Jan 30, 2014 4:00 pm
by 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.

Re: Problem with wildcard

Posted: Fri Jan 31, 2014 11:21 am
by 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

Re: Problem with wildcard

Posted: Fri Jan 31, 2014 11:51 am
by kkeough
That was it, thank you so much!