Hi,
I use a routine that reads a table from Excel and makes it a table in eViews with some expressions to become eviews series, but some of them are truncating the characters, so that eViews doesn't recognize the expression (it complains about the "unmatched parenthesis" because of the truncation). Is there a manner of avoiding eViews to truncate the expression when it gets the data from Excel?
Thank you in Advance!
Avoid Table to Truncate Characters
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
-
EViews Steve
- EViews Developer
- Posts: 844
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Avoid Table to Truncate Characters
Are you using the import or importtbl command? Is the truncation happening during this first import?
Or maybe it would be better to provide details on how your routine is actually working...
Sent from my iPhone using Tapatalk
Or maybe it would be better to provide details on how your routine is actually working...
Sent from my iPhone using Tapatalk
-
EViews Steve
- EViews Developer
- Posts: 844
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Avoid Table to Truncate Characters
Found it.
EViews has a limit of 1000 characters for an alpha series and your example above is cut-off exactly at 1000 characters. Because IMPORTTBL uses IMPORT internally, it is restricted by the same alpha series maximum character limit.
Perhaps you can use a shorter prefix name? (e.g. "p::" instead of "pnadc::")
Steve
EViews has a limit of 1000 characters for an alpha series and your example above is cut-off exactly at 1000 characters. Because IMPORTTBL uses IMPORT internally, it is restricted by the same alpha series maximum character limit.
Perhaps you can use a shorter prefix name? (e.g. "p::" instead of "pnadc::")
Steve
Who is online
Users browsing this forum: No registered users and 2 guests
