importing excel with blank cells: sometimes ellipses, sometimes NA's

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

dsdsdsdsd
Posts: 21
Joined: Sun Sep 06, 2020 7:33 pm

importing excel with blank cells: sometimes ellipses, sometimes NA's

Postby dsdsdsdsd » Mon Sep 14, 2020 3:08 am

hello ...

I have imported an excel sheet and for some reason it is treating cells differently after the 'O' column (which is the 15th column) from excel ...

in the picture you can see the excel sheet with four cells highlighted ... and in the right you can see those same cells highlighted, but with ellipses in one and an NA in the other ... in excel both are of the same cell format category 'General' ...

any thoughts as to why the cells after O are being treated differently ??

- thanks for your time ...

screenshot_eviews_4.png
screenshot_eviews_4.png (404.38 KiB) Viewed 12897 times

dsdsdsdsd
Posts: 21
Joined: Sun Sep 06, 2020 7:33 pm

Re: importing excel with blank cells: sometimes ellipses, sometimes NA's

Postby dsdsdsdsd » Mon Sep 14, 2020 11:12 am

SOLUTION:

the problem was that in he excel file the first row of data for the columns through 'O' were blank and so eViews was creating them as alpha columns/series ...


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: Google [Bot] and 10 guests