Easy Query

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

Tatha
Posts: 39
Joined: Thu May 21, 2009 2:55 pm

Easy Query

Postby Tatha » Wed Jun 10, 2009 4:33 am

For the first time, I'm trying to add description/labels to data in my database (earlier, I maintained a list of series names elsewhere). I took just 2 series as test series: CZ_OECD_CLI and HU_OECD_CLI which are stored in a database called 'emea'. Used the following commands:

CZ_OECD_CLI.label(r) OECD leading economic indicator for CZ, trend-restored
CZ_OECD_CLI.displayname OECD leading economic indicator for CZ
CZ_OECD_CLI.label(s) OECD

HU_OECD_CLI.label(r) OECD leading economic indicator for Hungary, trend-restored
HU_OECD_CLI.displayname OECD leading economic indicator for Hungary
HU_OECD_CLI.label(s) OECD

After overwriting the old series in the database, I can see these series and they say ,[displayname] OECD leading economic indicator for CZ
and all that. Easyquery when name is matched to *oecd* finds these series, but an easyquery with Description matching *OECD* turns up nothing. My aim is to add longer descriptions to all my series in the form of labels and display names and search for them that way. What am I doing wrong?

Thanks in advance,
Tatha

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

Re: Easy Query

Postby EViews Gareth » Wed Jun 10, 2009 8:02 am

You need to use label(d) to set the description.

Tatha
Posts: 39
Joined: Thu May 21, 2009 2:55 pm

Re: Easy Query

Postby Tatha » Wed Jun 10, 2009 8:52 am

Worked like a charm :) Many thanks Gareth.

ecardamone
Posts: 40
Joined: Wed Sep 17, 2014 12:23 pm

Re: Easy Query

Postby ecardamone » Mon Sep 22, 2014 7:20 am

Is there a better way to document a series than what I have below? For example, is there a way to do this in a single line without repeating USGOD_ND? Thanks for help!

USGOD_ND(C)
USGOD_ND(D) United States, Gross Output, Manufacturing
USGOD_ND(S) BEA
USGOD_ND(U) Millions of US Dollars
USGOD_ND(R) History edge: 2013
USGOD_ND(R) Primary data: 1997-2012
USGOD_ND(R) Supplement:
USGOD_ND(R) NAICS 31-33, 511, 512
USGOD_ND(R) Note: Pre-1997 data backcasted using NAICS 2002 data growth profile
USGOD_ND(R) Note: Data extended using proxy WIS IP 2013
USGOD_ND(R) Note: Data extended using growth pattern of WIS IP 2013 United States


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests