using upper() on a series?

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

using upper() on a series?

Postby dsdsdsdsd » Fri Sep 11, 2020 9:10 am

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 16037 times


Is there a way to handle the case issue using copy()?

- thanks for your time,
- Shannon

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

Re: using upper() on a series?

Postby EViews Gareth » Fri Sep 11, 2020 9:13 am

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
Follow us on Twitter @IHSEViews

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

Re: using upper() on a series?

Postby dsdsdsdsd » Fri Sep 11, 2020 10:27 am

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

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

Re: using upper() on a series?

Postby EViews Gareth » Fri Sep 11, 2020 2:46 pm

You'll have to unstructure the page (i.e. set the page structure to undated or none), change the series, then restructure it.
Follow us on Twitter @IHSEViews

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

Re: using upper() on a series?

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

aha ... fair enough ... thanks ...


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 12 guests