topic Re: Create a new variable keeping values from 2 different variables in SAS Procedures

Create a new variable keeping values from 2 different variables

epi101 — Fri, 11 Jan 2019 16:25:44 GMT

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 — Fri, 11 Jan 2019 20:07:41 GMT

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

PGStats — Fri, 11 Jan 2019 20:23:12 GMT

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