SAS中文论坛

标题: 如何把missing value换成字符? [打印本页]

作者: shiyiming 时间: 2012-2-21 10:19
标题: 如何把missing value换成字符?
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 时间: 2012-2-21 13:47
标题: Re: 如何把missing value换成字符?
你判断下x是否为缺失，是的话重新赋值呗。if missing(x) then y='N/A';

作者: shiyiming 时间: 2012-2-22 00:06
标题: Re: 如何把missing value换成字符?
[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 时间: 2012-2-22 01:20
标题: Re: 如何把missing value换成字符?
wow, so nice.
actually I tried proc format, but performed with a different way and failed. shame.
Thanks a lot.

欢迎光临 SAS中文论坛 (http://www.mysas.net/forum/)