Page 1 of 1

using upper() on a series?

Posted: Fri Sep 11, 2020 9:10 am
by dsdsdsdsd
hello ...

I am attempting a copy() between two pages ... I believe the problem is case sensitivity between the @src and @dest ... I tried
copy() ... ... @src @upper(country) ...

where 'country' is the source series with lowercase, but of course upper() is not intended to work on a series ...

Code: Select all

copy() pg_patents_panel\patents pg_main\patents @src country var01 @dest country dateid
screenshot_eviews_3.png
screenshot_eviews_3.png (296.69 KiB) Viewed 18354 times
Is there a way to handle the case issue using copy()?

- thanks for your time,
- Shannon

Re: using upper() on a series?

Posted: Fri Sep 11, 2020 9:13 am
by EViews Gareth
You can use @upper on a (alpha) series, but you cannot use it inline in the copy command.

Create a new alpha that is equal to @upper(country), then use the new alpha as the source id

Re: using upper() on a series?

Posted: Fri Sep 11, 2020 10:27 am
by dsdsdsdsd
aha ...

slightly new question: as it turns out I was using that lowercase country as an ID for that table/page ... now that I created the uppercase version, country_U, I may as well get rid of the lowercase series ... but because it is an ID/index column I cannot ... is there a way of doing that??

- thanks for your time,
- Shannon

Re: using upper() on a series?

Posted: Fri Sep 11, 2020 2:46 pm
by EViews Gareth
You'll have to unstructure the page (i.e. set the page structure to undated or none), change the series, then restructure it.

Re: using upper() on a series?

Posted: Mon Sep 14, 2020 3:01 am
by dsdsdsdsd
aha ... fair enough ... thanks ...