replace string data

[arnoudbl]

He all,

I got a question concerning the replacement of string data, when replacing data i usually insert i.e. k3h=@recode(k3h=na,0,k3h), however i need to replace Don't know. When commanding k3h=@recode(k3h="Don't Know",0,k3h) it responses with 'Numeric operator applied to string data'. Pleace help, i appreciate the effort!

Arnoud

[startz]

Assuming that k3h is an alpha series, this strikes me as a bug. But try

Code: Select all

series k3hEqualsDontKnow = k3h="Don't know" k3h=@recode(k3hEqualsDontKnow ,0,k3h)

[EViews Glenn]

I'm not by my computer so I can't test this but I think the second argument needs to be a string, as in

Code: Select all

k3h=@recode(k3h="Don't Know","0",k3h)

[arnoudbl]

@ eviewsglen & startz

Thanks a lot for the effort, unfortunately both answers do not solve the issue... any other thoughts?

[EViews Gareth]

Post your work file

[startz]

Glenn's solution works on my machine. If k3h is an alpha series, you can't set it to 0 because that's a number rather than a string.