EViews 10+ Problem importing alphanumeric series
Posted: Tue May 15, 2018 7:45 am
I am importing an alphanumeric series from Excel into an unstructured workfile page:
The alpha series contains ID values composed of numbers and/or letters. Rows that do not have an ID contain the words "NO ID". For example:
100000000
A00000001
100000002
100000003
100000004
NO ID
NO ID
NO ID
When the data are imported into EViews, the words "NO ID" do not get populated in the alpha object - these rows are just blank. Other values get imported without any issue.
I've tested this with different words, and the problem is the same. (For example, if "A00000001" appears in multiple rows, that value stops being imported.) ID values that are entirely composed of numbers do not have this problem - they can repeat in many rows and still be imported.
Am I doing something wrong, or is this a bug? Thanks!
Code: Select all
wfcreate u 1 1
import "test.xlsx" range="'Test'!A1" colhead=1 namepos=none names=("test") types=(a) @appendThe alpha series contains ID values composed of numbers and/or letters. Rows that do not have an ID contain the words "NO ID". For example:
100000000
A00000001
100000002
100000003
100000004
NO ID
NO ID
NO ID
When the data are imported into EViews, the words "NO ID" do not get populated in the alpha object - these rows are just blank. Other values get imported without any issue.
I've tested this with different words, and the problem is the same. (For example, if "A00000001" appears in multiple rows, that value stops being imported.) ID values that are entirely composed of numbers do not have this problem - they can repeat in many rows and still be imported.
Am I doing something wrong, or is this a bug? Thanks!