EViews.com

Hello,

I would like to know what is wrong for the following code

series ddddd=@recode((dfs_h>dfs_h(-1)) and (dfs<dfs_l),1,0)

It doesn't work, does @recode works with "and", "or" ??

I am trying @recode because I can't use the IF inside a FOR loop.

Thanks

Nothing wrong with it that I can see:

Hi there,

how do i use 2 svector with @recode command?
(related files as attached, please check.)
Actually, the purpose is that if "cusip_alpha" = "scomp_cusp_al", i would like to create a column called DS_s, which is base on "type", in group Scusp, is anyone have better solution for this?
Thank you so much!!!!

Hello,

You could use something like,
and then add DS_s to group Scusp afterword.

Hi Matt,

Thank you for your advise. :)
After i tried, it still have some problem, you may see the picture from the attachment
For example,
R4(cusip_alpha) = R3206(Scomp_cusp_al) = 000360206, then
R4(DS_S) should be 544294(type)
But, as you can see from the attchment, R4(DS_s) shows "NA"

i'm not sure is the reason that my data contain string or @recode command can't not be used like this way...
please help, thanks a lot!!!!!!! :D

Ah, you want to test if each value in scomp_cusp_al matches ANY value in cusip_alpha, and copy the corresponding type value. @recode is not the way to do this. Basically, you need to manually go through every observation in scomp_cusp_al and search for a matching observation in cusip_alpha.

Hi Matt,

i have another question that i need to create new columns ds_s_F/ds_c_F base on the ds_s/c_{%cntry}({%cntry}=a1, a2, dd1, dd2, dd3, dd4, dd5)
you may see the attached.
If one of ds_s/c_{%cntry} have 'value', ds_s/c_F = 'value', otherwise, = '0'
i not sure @recode command could use in this kind of issue, or not?

thanks a lot!!!

You want to examine values within each row, yes? For that @recode could work well. However, it's probably easier to use other EViews facilities. For example, you can add the series/columns you want to check to a group and then use @rfirst to identify the first non-NA value for each row of the group. Since your data appears to have only one unique non-NA value per row, identifying the first non-NA value matches what I believe you're requesting. Here's some sample code for ds_s_F,

Hi Matt,

Thank you so so so much~~~ :D

Hi there,

i would like to do downsize within 2 files as attached.
and, create a new file that when obs = ds_s_F, and keep the obs.
how do i do it?
thanks!!!

It's unclear to me which observations you want to keep. Regardless, if you can create a dummy series indicating which observations you want to keep, you can then contract the workfile page using that series and save it as a new workfile.

Hi Matt,

i would like to check whether the code in the 2nd pic exist in the column DS_S_F in the 1st pic
if not exist then drop the whole column of the code
for example,
if B1(867270) not exist in the DS_S_F, then drop the column

At the end, it will have a new file with the code that DS_S_F exist

i'm not sure you understand my explanation or not...?

I understand now, you want to eliminate columns (series), not observations. Once you've imported both files, you can go through each series name of the second file (using @wlookup) and see whether it is present in DS_S_F (similar to the code several posts ago) within the first file. If not, then delete the series.

Hi Matt,

i just try to use @wlookup command, but im not quite sure the function.
i attached 2 files, please check. Thanks!!!

Here's an example that gets you part way there. I'd forgotten that EViews will prepend "num" to numeric series names during an import, but that's easy to work around.