COALESCE function using SQL as shown below will take care of your issue...
DATA HAVE;
INPUT RACE1;
DATALINES;
1
2
3
4
5
6
7
8
9
;
RUN;
DATA HAVE2;
SET HAVE;
SELECT (RACE1);
WHEN (1) WHITE=1;
WHEN (2) BLACK=1;
WHEN (3,4,5) NATIVE=1;
WHEN (6,7) ASIAN=1;
WHEN (8,9) OTHER=1;
END;
RUN;
proc sql; create table have2 as select race1,
coalesce(white,0),coalesce(black,0),coalesce(native,0),coalesce(asian,0),coalesce(other,0)
from have2; quit;
Good Luck...!!!
... View more
