topic Re: Creating a single variable from multiple variables in SAS Programming

Creating a single variable from multiple variables

Dhana18 — Fri, 21 Jun 2019 16:47:11 GMT

I have a data set like this;

id k_race p_race b_race

1 black

2 white

3 asian

i want this to be like

id race

1 black

2 white

3 asian

how do i code this? please help.

Re: Creating a single variable from multiple variables

alexgouv — Fri, 21 Jun 2019 16:58:48 GMT

There are multiple ways to do this but one pretty easy way is:

data want(drop = k_race p_race b_race);
   set have;
   if k_race ne '' then race = k_race;
   else if p_race ne '' then race = p_race;
   else if b_race ne '' then race = b_race;
   else if k_race = '' and p_race = '' and b_race = '' then race = 'Missing';
run;

Re: Creating a single variable from multiple variables

Reeza — Fri, 21 Jun 2019 16:59:12 GMT

PROC TRANSPOSE

Re: Creating a single variable from multiple variables

PaigeMiller — Fri, 21 Jun 2019 17:01:52 GMT

Use the COALESCE function

Re: Creating a single variable from multiple variables

Reeza — Fri, 21 Jun 2019 17:30:14 GMT

COALESCEC() for character values.