@wdrop statement

[Andre2016]

Hello Guys,

So I have the following code :

Code: Select all

smpl @all genr bbmodel = bbdmodel alpha bbmodel @wdrop ("Astra 1125SP" , "SP") @wdrop ("Astra 1125SPX" , "SPX")

Is there a way to write it so that I don't have to revrite the @wdrop statement on every single line?

Thanks

[EViews Gareth]

Currently those lines are not doing anything, so hard so see what you mean.

[Andre2016]

Currently those lines are not doing anything, so hard so see what you mean.

I have a series called "bbmodel" which is an alpha series that I'd like to edit.

In that alpha series I'd like the following action:

If what appears is "Astra 1125SP" then I'd like it to be only "Astra 1125"
If what appears is "Astra 1125SPX" then I'd like it to be only "Astra 1125"

Thanks

[EViews Gareth]

Code: Select all

bbmodel = @replace(bbmodel, "SPX", "")

[Andre2016]

Code: Select all

bbmodel = @replace(bbmodel, "SPX", "")

Thanks Gareth,

[Andre2016]

Code: Select all

bbmodel = @replace(bbmodel, "SPX", "")

I have an issue.

when I do

Code: Select all

bbmodel = @replace(bbmodel, "Falcon 200", "Falcon 20")

All the values containing "Falcon 200***" changes e.g:

Falcon 2000S becomes Falcon 200S

Is there a solution so that when I change "Falcon 200" to "Falcon 20", everything else remain the same ?

Thnks

[EViews Gareth]

If there are spaces after the 200, you could include a space in the replace.

Otherwise you'll have to do a search replace with @instr, @left, @mid etc...