topic Re: SQL Case-function problem: best way to leave one value alone? in SAS Data Management

SQL Case-function problem: best way to leave one value alone?

EinarRoed — Wed, 28 Nov 2012 19:49:11 GMT

I have a question about this code:

case VARNAME

when "Oil and Penguins" then "Oil and Penguins"

else propcase(VARNAME) end

It puts all the values in the VARNAME column into proper case, but makes an exception for "Oil and Penguins" because it shouldn't become "Oil And Penguins". It works correctly, but I strongly suspect that the second line is a bit clumsy. Is there a better way to tell it to leave "Oil and Penguins" alone? Something along the lines of "when 'Oil and Penguins' then nothing"?

Re: SQL Case-function problem: best way to leave one value alone?

PGStats — Wed, 28 Nov 2012 20:30:53 GMT

I guess

case VARNAME

when "Oil and Penguins" then VARNAME

else propcase(VARNAME) end

would be a tad neater.

Re: SQL Case-function problem: best way to leave one value alone?

EinarRoed — Wed, 28 Nov 2012 21:10:00 GMT

Can't believe I overlooked doing that. :smileyshocked:

Thanks!