multiple repetitive if statements

[Jonathan]

Hi,
Is there a clean way to do something like the following:

if %mif %m_long="January" then
%m_short = "01"
else
if %m_long="February" then
%m_short = "02"
else
if %m_long="March" then
%m_short = "03"
.
.
.
endif
endif
endif

That works but it's really clunky, especially for states or MSAs or any list of more than three or four. Thanks!
Jonathan

[startz]

Hi,
Is there a clean way to do something like the following:

if %mif %m_long="January" then
%m_short = "01"
else
if %m_long="February" then
%m_short = "02"
else
if %m_long="March" then
%m_short = "03"
.
.
.
endif

endif
endif

That works but it's really clunky, especially for states or MSAs or any list of more than three or four. Thanks!
Jonathan

Code: Select all

%m_short = @recode(%m_long="January","01",%m_short) %m_short = @recode(%m_long="February","02",%m_short)

or something like that

[Jonathan]

Okay, I guess looping through a table of paired values is best for a long list. Thanks for the fast reply!
Jonathan

[EViews Gareth]

Create an svector with the short values you want in it, then just do this:

Code: Select all

svector longs = @uniquevals({%m_long}) for !i=1 to @rows(longs) %long = longs(!i) %short = shorts(!i) {%m_short} = @recode({%m_long} = %long, %short, {%m_short}) next

(where I called my short svector "shorts").

[Jonathan]

Thanks for that. The use of recode is something I need to consider more.
Jonathan