How to set complex condition in EViews?

[banhbengconuong]

Dear Eviews experts,

I would like to make a complex condition for the lag of model. Suppose based on SIC criteria, number of lag is "a"
Below is my set of conditions:
if a <3 is true then a=3, else a = a
if a>6 is true then a=6, else a=a
At this moment I am stuck with setting the two conditions by writing 2 separate conditions because a is always either 3 or 6.
Please help me to fix it. Thank you very much!!!!

[EViews Glenn]

Code: Select all

a = min(max(a, 3), 6)

[banhbengconuong]

Code: Select all

a = min(max(a, 3), 6)

I am sorry that when I write:
scalar a=min(max(1, 3), 6)
EViews says "Syntax error". Could you pls check that?
Many thanks

[EViews Glenn]

Sorry, use @min and @max.

[banhbengconuong]

Sorry, use @min and @max.

Sorry again, EViews said "too many arguments" even if I choose only scalar a=@min(3,6) for instance.

[startz]

Try

Code: Select all

a = (a<3)*3 +(a>=3)*a
a = (a>6)*6 + (a<=6)*a

[EViews Glenn]

Sorry, I'm thinking in different programming language syntax. To do Startz's excellent suggestion in one line

Code: Select all

a = (a<3)*3 + (a>6)*6 + (a>=3 and a<=6)*a