Create a new variable keeping values from 2 different variables

[epi101]

Hello, 

I have var A and Var B and using those two I would like to create a combine variable using the value for either A or B depending on the survey year. 

So, if survey year=5 then combine variable= values in variable A

       if survey year 6 then combine variable= values in variable B

Thanks for your help in advance! 

[RyanK]

When you say combine, do you mean concatenate? Are the current values text or numeric?

[PGStats]

To do this in a SQL query, use a case expression:

case when survey_year=5 then mean(A) else mean(B) end as yearMean