EViews 10+ Problem importing alphanumeric series

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

modelqs
Posts: 3
Joined: Thu May 10, 2018 1:20 pm

EViews 10+ Problem importing alphanumeric series

Postby modelqs » Tue May 15, 2018 7:45 am

I am importing an alphanumeric series from Excel into an unstructured workfile page:

Code: Select all

wfcreate u 1 1
import "test.xlsx" range="'Test'!A1" colhead=1 namepos=none names=("test") types=(a) @append


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!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11774
Joined: Tue Sep 16, 2008 5:38 pm

Re: EViews 10+ Problem importing alphanumeric series

Postby EViews Gareth » Tue May 15, 2018 7:54 am

Could you provide the Excel file?
Follow us on Twitter @IHSEViews

modelqs
Posts: 3
Joined: Thu May 10, 2018 1:20 pm

Re: EViews 10+ Problem importing alphanumeric series

Postby modelqs » Tue May 15, 2018 8:00 am

See the attachment:
test.xlsx
(8.77 KiB) Downloaded 6 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11774
Joined: Tue Sep 16, 2008 5:38 pm

Re: EViews 10+ Problem importing alphanumeric series

Postby EViews Gareth » Tue May 15, 2018 8:06 am

Code: Select all

import "test.xlsx" range="'Test'!A1" colhead=1 namepos=none names=("test") types=(a) na="" @append
Follow us on Twitter @IHSEViews

modelqs
Posts: 3
Joined: Thu May 10, 2018 1:20 pm

Re: EViews 10+ Problem importing alphanumeric series

Postby modelqs » Tue May 15, 2018 8:09 am

Great, thanks!


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 2 guests