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"?
I guess
case VARNAME
when "Oil and Penguins" then VARNAME
else propcase(VARNAME) end
would be a tad neater.
PG
I guess
case VARNAME
when "Oil and Penguins" then VARNAME
else propcase(VARNAME) end
would be a tad neater.
PG
Can't believe I overlooked doing that. :smileyshocked:
Thanks!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.