The eviews input data shows the NA

It works fine but the NA is displayed because the excell cell is not formatted correctly.

Cause: The source format of the copy is inconsistent with the target format, that is, you have copied the data of the non-standard format in the excell to the eviews, but the format is incorrect and cannot be displayed normally because the eviews do not accept formats other than the regular ones. But there is no problem with the data, so it can be used normally.

Fixed: Changed the format of the cells that were displayed as na after copying the data to be normal.

Steps: 1. Check the format of the data in Excell, which is usually a numeric value.

2. Select the data range of the copied NA, and right-click to set the cell format.

3. Select Number-General in the Format Cell.

What are the numbers?

na stands for missing number, and there are two scenarios that may cause your results:

1. The number is too small, too small for the display accuracy of eviews, but it exists in the computer memory. This is rarely the case.

2. Instead of manually entering the numbers yourself, you copy and paste them from other documents into the workfile. In the source document, the type of data may be textual, which cannot be displayed in the workfile, because the sequences should all be numeric in nature. When compiling, eviews will cast the text to a numeric version.

Your situation is likely to be the second one.

Solution: Copy the source document data to Excel, and then create a workfile by importing the data.

Most likely, it's a memory issue. Usually restart the eviews and the computer, or wait a few minutes and try again. Encountered a few times. Although I have 8g of RAM - it may have something to do with the software itself importing and loading.

Q: How do I remove the data that the value of Socks Mountain is NA from eViews?

In eviews, you can use the following methods to get rid of data with a value of na:

1.Use the "Delete Observations" command: Select "Delete Observations" from the "Quick" menu in eViews, and then select the "By Condition" option.

In the dialog box that appears, enter the variables and conditions you want to delete, such as "if x = na", and then click "OK" to delete all data with the value of na.

2.Use the "proc make group" command: Select "make group" from the "proc" menu in eviews, and then select the "by condition" option.

In the dialog box that pops up, enter the variables and conditions you want to delete, such as "if x = na", and then click the "OK" button to create a new data group, in which all data with the value of na is deleted.

3.Use the "genr" command: Select "genr" from the "quick" menu in eviews, and then enter the name of a new variable, such as "y".

Next, enter a calculation formula, such as "y = x[not na(x)]" and click the "ok" button to create a new variable in which all data with the value of na is deleted.

All three methods can effectively remove data with a value of na, depending on the size and complexity of the data.