How will clean the data having multiple delimited values of a variable

1.	How will clean the data having multiple delimited values of a variable in SAS like if data values are “ab,c,*&%$ ~d” and you want to make it like “abcd”?
Answer» we can count missing value in SAS USING NMISS function. For example – data a; x1=2; x2=3; x3=.; nvars_miss=nmiss(of x1-x3); put nvars_miss=; run; PROC PRINT data = a; run;

How will clean the data having multiple delimited values of a variable in SAS like if data values are “ab,c,*&%$ ~d” and you want to make it like “abcd”?

Answer»

we can count missing value in SAS USING NMISS function.

For example –

data a; x1=2; x2=3; x3=.; nvars_miss=nmiss(of x1-x3); put nvars_miss=; run; PROC PRINT data = a; run;