Used the first part of your data to demo the process I would take to label the checkbox values
data have;
length chks $ 10;
input chks $;
datalines;
1,2
1
1,2,3
1,2,4
1,3
1,4
1,4,3
1,5
2
2,3
2,4
2,5
2,6
;
proc format;
value $status 1='Admitted' 2='Discharged'
3='Transferred' 4='Left AMA'
5='Expired' 6='Unknown' 7='Eloped';
run;
data want;
set have;
length parse $12 status_ednf_nnf1 $500;
do i=1 by 1 until (parse='');
parse=put(scan(chks, i, ','),$status.);
if i=1 then
status_ednf_nnf1=parse;
else
status_ednf_nnf1=catx(',', status_ednf_nnf1, parse);
end;
keep chks status_ednf_nnf1 ;
run;
proc print;
run;
... View more