09-16-2013 02:57 PM
ok, it's a situation where i have 2 values for an identifier from one of my data tables, ex t1Infotable_colors
i want my statement to be something like this:
if t1infotable_colors (in a list) pink or blue then i want it to display "pretty" else "ugly" (the actual words as output in the computed column?
obviously the table and values are not my actual values/etc but this is for informational purposes only i am familiar with how to write in crystal syntax, i am new to SAS/SQL how to write this expression to get the desired output for my computed column
because it is a "computed column" does it have to be a calculation?
i am trying to find the equivalent of a formula editor for creating my own formula field on my report.
09-16-2013 04:20 PM
You can also use the recode function in computed column rather than advanced expression to do this.
09-16-2013 03:11 PM
I believe the query builder uses proc sql so you would need to use a case statement instead of an if/then..
case when t1infotable_colors in ('pink','blue') then 'pretty' else 'ugly' end