如何把missing value换成字符?

shiyiming

data a;
input id $ x percent8.2;
format x percent8.2;
cards;
a1 %12.51
a2 .
a3 %0.45
a4 %167.10
a6 .
a5 %9.33
...
;
run;
现在X想把x中missing values改成'N/A',新的data中x可以是numeric 也可以是char,但'%'一定要保留:
id      x
a1 %12.51
a2 N/A
a3 %0.45
a4 %167.10
a6 N/A
a5 %9.33
...
;
run;
不知道可不可以?
ps:我试过missing function,但好像%符号无法保住.
谢谢!!!

shiyiming

你判断下x是否为缺失，是的话重新赋值呗。if missing(x) then y='N/A';

shiyiming

[code:nenwdpmp]proc format;
value xfmt . ='N/A' other =[percent8.2]
;
run;
data a;
input id $ x percent8.2;
format x xfmt. ;
cards;
a1 %12.51
a2 .
;[/code:nenwdpmp]
格式只是你所看到的。京剧

shiyiming

wow, so nice.
actually I tried proc format, but performed with a different way and failed. shame.
Thanks a lot.