topic Re: How to create a variable from three variables in a dataset in SAS Programming

How to create a variable from three variables in a dataset

ChuksManuel — Wed, 26 Sep 2018 06:10:27 GMT

Hello guys,

I' m new to the forum.

Please how do i create a new variable from 3 variables (cbrchyr, copdev, ephev).

My goal is to create a variable that would pick, for example, a "YES" response (coded as 1) in ANY of the variables cbrchyr, copdev and ephev to mean a "Yes" response in my new variable. While the remaining responses that are not "YES" (coded as 2,7,8,9) are coded as 2 (NO).

I have attached a copy of my output. I want to create a variable that would list obs 27, 37, 38, 44 and 47 as Yes (1).

Please i'll be glad to get any kind of help.

Below is my inital code. I have used the "coalsce" statement and i just can't get it right.

LIBNAME perm 'D:\';
DATA Newsasdata (keep= cbrchyr copdev ephev );
SET perm.nhis2012sampleadult;
RUN;

Re: How to create a variable from three variables in a dataset

ChrisNZ — Wed, 26 Sep 2018 06:27:23 GMT

Like this?

if index(catt(VAR1,VAR2,VAR3),'1') then VAR4='Y';

Re: How to create a variable from three variables in a dataset

ChuksManuel — Wed, 26 Sep 2018 07:02:32 GMT

Thank you!

It worked. My other question is, how do i code the other observations as "2" in my new variable (var 4)

Re: How to create a variable from three variables in a dataset

RW9 — Wed, 26 Sep 2018 08:03:27 GMT

To paraphrase @ChrisNZ

var4=ifn(index(catt(var1,var2,var3),'1'),1,2);

So if the first parameter is true, return 1, else return 2

Re: How to create a variable from three variables in a dataset

ChuksManuel — Wed, 26 Sep 2018 08:09:18 GMT

Thanks Chris!

Re: How to create a variable from three variables in a dataset

FredrikE — Wed, 26 Sep 2018 08:10:03 GMT

if index(catt(VAR1,VAR2,VAR3),'1') then VAR4='Y';
else var4='N'

//Fredrik

Re: How to create a variable from three variables in a dataset

ChuksManuel — Wed, 26 Sep 2018 08:12:04 GMT

Thanks guys!

Re: How to create a variable from three variables in a dataset

ChrisNZ — Wed, 26 Sep 2018 22:12:30 GMT

@ChuksManuel

Really?

You never used ELSE before?