topic How do I add a column to a dataset that stores categories from three other columns? in New SAS User

How do I add a column to a dataset that stores categories from three other columns?

DoctorShemp — Mon, 26 Nov 2018 23:11:50 GMT

New SAS user here!

In my dataset I am comparing three different diets (A,B, and C) in how they affect weight loss. Currently, my data has a column for the weightloss, followed by three columns A, B, and C. If A=1 it means the person was on diet A (columns B and C would have 0, the diets are mutually exclusive). I don't want three columns with 1s and 0s like this though. I just want one simple column called "Diet" That stores either A, B, or C. How do I do this?

Re: How do I add a column to a dataset that stores categories from three other columns?

Reeza — Mon, 26 Nov 2018 23:22:49 GMT

You can code them as A, B, C or 1, 2, 3.

name = whichn(1, A, B, C);

I think this would code it as 1, 2, 3. If that works for you.

Re: How do I add a column to a dataset that stores categories from three other columns?

r_behata — Mon, 26 Nov 2018 23:27:46 GMT

data have;
input  a b c ;
cards;
1 0 0
0 1 0
0 0 1
0 1 0
run;

data want;
set have;
array nm a b c;
diet=' ';
do i =1 to dim(nm) while(diet eq ' ') ;
	if nm[i] > 0 then diet=vname(nm[i]);
end;

drop a b c i;
run;

Re: How do I add a column to a dataset that stores categories from three other columns?

PGStats — Mon, 26 Nov 2018 23:43:20 GMT

Use the transformation

diet = char("ABCX", whichn(1, A, B, C, 1));

Re: How do I add a column to a dataset that stores categories from three other columns?

DoctorShemp — Mon, 26 Nov 2018 23:44:52 GMT

Thank you! this is the simplest solution that did exactly what I was trying to do.

Thank you to everyone else who responded as well, this community is crazy helpful