I have one variable that's values are either 'state' of 'country'. State meaning its a state in the united states. Country meaning it is outside of the united states.   My second variables values are state or country codes. This is the variable I want to format with two different formats based on what my first variable is.   Basically, if my first variable has a value of 'state' then I want to apply my state format to the second variable. And if my first variable has a value of 'country' then I want to apply my country format to the second variable.   As an example, if my first variable has a value of 'state' and my second variable has a value of 'TX' then the state format would make that value in my second variable read 'TEXAS'. But if  first variable has a value of 'country' and my second variable has a value of 'TX' then the country format would make that value in my second variable read 'TURKMENISTAN'.   I know this next line of code is incorrect but I think it tells you what I'm trying to do if var1='state' then var2 $state. else var2 $country.;     I'm using Enterprise Guide 7.1 Thanks, Kelli ... View more