EViews.com

The problem is EViews does not recognize the first column on 'sheet22' as being dates. Q[Q] YYYY(ex. Q1 1950) is an unorthodox date format. Because it is unrecognized, EViews is creating an undated workfile with an ID series. To get what you want, change your command to: wfopen(page=x) "C:\exce...

The documentation for the import command options when converting from a low to higher frequency is incorrect . The import command only support simple conversion methods. The docs should read for low to high conversion: e= arg where arg is one of the following: f - first observation l - last observat...

Points #1 and #3 is on our list of features to add/investigate.

Point #2 has been resolved in EViews 7.

What version of EViews are you using? Be sure that your copy is also up to date. The latest of version EViews 7.1 works as desired.

The fix will be available in the next patch

This will get you most of the way there ignoring the M13 issue. wfopen "ftp://ftp.bls.gov/pub/time.series/sm/sm.data.9.dc" colhead=1 firstobs=1 alpha serid = @replace(series_id,"00","") 'shorten series names otherwise unstacking will complain about the names being too l...

In the data, 'M13' is listed as a period value. How do you wish to handle the observations for those periods?

If there isn't data to the right or below the desired region, EViews will automatically import the right and bottom most observation. If there is data to the right you could use '@drop=' to remove any extraneous series. But if the series names change or if there are lot of series to remove this may ...

The error message is a bit strange in that it indicates the series name to be "DO_SERIES11.M". This is not a valid EViews series name. Post your lines of code which constructs the series name as well the line that executes TRAMO. I suspect this to be the culprit and that EViews is giving a...

Using the exact data and command you posted, I was able to get a series named EEL72DC with the description equal to "Employment, Accommodation and Food Services, By Place of Work NAICS REG_MTH_HIST:EEL72DC.M" as one line. I believe this is what you wanted. Please make sure you have the lat...

As stated by Startz, first try updating your copy of EViews.

If the problem remains, contact support@eviews.com and if possible include the 2010 excel file.

You can use either, but Glenn is correct in that you should use 'wfopen'. 'Open' is also an older command that has been left in EViews for backward compatibility reasons. In simpler cases the results should be same, but 'wfopen' is the preferred method.

There are 2 things wrong with your command. First is you have a space in between / and data.xls. It also wouldnt be a bad idea to put your entire path in quotes for directory or files names that contain spaces. So Read "E:/data.xls" The second thing is you are missing either the series nam...

Unfortunately you cannot specify a destination cell. In EViews 7, you could have used insertcol and insertrow to pad out the data. In EViews 5, you will need to manually pad by copying the data to their desired location via a loop within a program.

1)The code I posted is not correct. for %series myworkfile::* %x=%series.@name %series.label(r) %x next It should read %object_list = @wlookup("myworkfile::*") 'get a list of object names in myworkfile for !i = 1 to @wcount(%object_list) ' loop through the objects %obj = @word( %object_lis...