EViews.com

Just lag the data once it is in your workfile.

How do I do that?

I am pulling weekly (Monday) data from a db into a workfile that is weekly (Wednesday) and am finding that it defaults to being a week off. For instance, the weekly (Monday) DB has data through January 6th, 2025 but when brought into the workfile it remaps it to January 1st instead of the 8th. Even ...

That worked. Thank you.

I am trying to set a series equal to a series, but only for the observations that meet the qualifications. So, in months where BP1FH_S{%s} > BPPRIV_S{%s} make BP1FH_S{%s} in those months equal to BPPRIV_S{%s}.

I believe so, yes. Here's the entire code up to that point. It will run through everything just fine up until the recode line. 'REGION & DISTRICT DEFINITIONS 'NE %ne = "CT MA ME NH NJ NY PA RI VT" %d1 = "CT MA ME NH RI VT" %d2 = "NJ NY PA" 'NC %nc = "IA IL IN K...

Hi! I am attempting to replace observations from one series with another. So, if and observation for X > Y, make X = Y. However, the following code is throwing an error: %ne = "CT MA ME NH NJ NY PA RI VT" %nc = "IA IL IN KS MI MN MO ND NE OH SD WI" %so = "AL AR DC DE FL GA K...

...and this morning it's working fine. Sorry for the false alarm!

When using the following fetch command I only receive back the series beginning with "a": fetch(db = FRED) ??BPPRIV However, there are many more series available. If I Query the db directly for CTBPPRIV it shows it there. This command does return all available series matching the criteria:...

Thanks for your response.

When I use the copy command it copies the formula as a formula. I would like to copy the formula as a series, which the manual paste special allows for.

Is there a way to copy series/formulas as values using the programming language?

This is an option in the "Paste Special" menu as "Paste as" --> "Series (by Value)". I don't see any equivalent in the programming language.

Thanks

Hello, I have a host of formulas and linked series in a workfile that I would like to store in a database. When I do this via the store command, it keeps their status as formulas and links.However, because the series that belong to said formulas and links aren't there, the formulas and links break. ...

Hi, I am trying to create a series that contains the trendline values associated with another series. For example: I have a quarterly series "z"; sample 1980 through 2015Q1. I would like to create series "z_trend" that contains the data that when graphed would display a linear tr...

Thank you very much! This is great!

Currently they are in a temp variable

%MET = "35614 31084 etc"
%METR = "newy losa etc"

BUT, I can organize it whatever way is the best way to go about replacing one with the other.

Thanks!

Brendon

Hello, I am attempting to rename a group of series by replacing part of the series name with an equivalent but different name. See below for an example: pop_35614 rename as pop_newy pop_31084 rename as pop_losa Basically, I have two lists: one with the numbers (35614, 31084, etc.) and a matching one...