SAS Viya

shalatemasinge — Thu, 13 May 2021 13:47:42 GMT

I need to create a calculated column in SAS Viya using case statement

see below how I want the results

case Q4_1_WebSite_Experience
when '1' then 'Irritated'
when '2' then 'Dissapointed'
when '3' then 'Neutral'
when '4' then 'Satisfied'
when '5' then 'Delighted'
else 'None'
end as WebSite_Experience

Re: SAS Viya

Sam_SAS — Thu, 13 May 2021 13:59:23 GMT

Hello,

The expression syntax for VA is limited compared to other systems. In a calculated item, you would need to use nested IF statements. Not very elegant but it works.

You could achieve the same result by using a custom category , which is a more GUI-based approach.

If you have permissions to change the source table, then you have more options. PROC SQL, for example. This would be ideal if your expression might become more complex than what you shared above.

Sam

topic Re: SAS Viya in SAS Visual Analytics

SAS Viya

Re: SAS Viya