I'm sorry, it seems that I'm doing something wrong! Data want keeps having 0 observations!! To help clarify, the string variables in my set are named "ICD_10_dx_1 to ICD_10_dx_50".
This is the code I used based on yours:
data want; set have; array x[10] $ _temporary_ ('S00' 'S10' 'S20' 'S30' 'S40' 'S50' 'S60' 'S70' 'S80' 'S90'); array v[*] ICD_10_dx_1-ICD_10_dx_50; output=1; do i=1 to dim(v);
if not missing(v{i}) and v{i} not in: x then do;output=0;leave;end;
end;
if output then output;
drop output i;
run;
data want; set have; array x{10} $ _temporary_ ('S00' 'S10' 'S20' 'S30' 'S40' 'S50' 'S60' 'S70' 'S80' 'S90'); array v{*} $ ICD_10_dx_:; output=1; do i=1 to dim(v); if not missing(v{i}) and v{i} not in: x then do;output=0;leave;end; end; if output then output; drop output i; run;
Where am I going wrong?!
... View more