Search found 8 matches

by nlf
Mon Aug 30, 2010 1:07 pm
Forum: Programming
Topic: programming database registry
Replies: 1
Views: 2732

programming database registry

Hi, I'm using Eviews 7 and want to share my database registry with my colleagues so we are all using the same aliases for databases. I guess there are three ways to do it. One way is to find out the name of the file that resides on my computer that includes the registry information - I couldn't find...
by nlf
Thu Jul 29, 2010 1:30 pm
Forum: Data Manipulation
Topic: importing flat file from ftp
Replies: 4
Views: 5977

Re: importing flat file from ftp

Thanks for the code. I think I can work through the M13 issue new that I can pull it in. The M13 is the annual data but they appear to be NAs so it should be easy to cycle through.
by nlf
Thu Jul 29, 2010 8:00 am
Forum: Data Manipulation
Topic: importing flat file from ftp
Replies: 4
Views: 5977

importing flat file from ftp

Hi, I would like to import data from the BLS ftp site into eviews but I don't know how to transpose the data to get it in to a monthly workfile. the ftp is ftp://ftp.bls.gov/pub/time.series/sm/sm.data.9.dc Below is a sample of the ftp file. When the data gets to the end of the time frame (2010 m06),...
by nlf
Mon Jul 26, 2010 11:37 am
Forum: Data Manipulation
Topic: import xls with labels
Replies: 7
Views: 7515

Re: import xls with labels

correction. i just looked at the data and I got the series name and the third line of the column header as the label. My problem is that the third line is a query line and I can't put a line in between that and the data. So this command: import %fname range="employment" colhead=3 namepos=f...
by nlf
Mon Jul 26, 2010 11:30 am
Forum: Data Manipulation
Topic: import xls with labels
Replies: 7
Views: 7515

Re: import xls with labels

Great! I used namepos=first and got my series names and my labels.

Thanks for the help.
by nlf
Mon Jul 26, 2010 10:36 am
Forum: Data Manipulation
Topic: import xls with labels
Replies: 7
Views: 7515

Re: import xls with labels

"employment" refers to the worksheet name. My understanding is that the import command does not necessarily need a defined range.

I know I could make it easy on myself by using the read command but I want the labels as well as the series names.

Thanks,
Norton
by nlf
Mon Jul 26, 2010 9:31 am
Forum: Data Manipulation
Topic: import xls with labels
Replies: 7
Views: 7515

Re: import xls with labels

Sorry. I'm using Eviews 7
by nlf
Mon Jul 26, 2010 9:29 am
Forum: Data Manipulation
Topic: import xls with labels
Replies: 7
Views: 7515

import xls with labels

Hi - I am trying to import data from excel using a program rather than the import menu command and I want to tell eviews that I have three column headers and the first line contains series names. Here's what I have so far: import %fname range="employment" colhead=3 where %fname is the name...

Go to advanced search