topic Re: need to change non missing observations into X in SAS Programming

need to change non missing observations into X

vraj1 — Mon, 23 Jan 2017 10:38:24 GMT

I need to change non missing observations into "X" and keep missing as '.'

I used the below code

data fin(drop=i);
set qs2;
array nvar(i) _numeric_;
do i= 1 to dim(nvar);
if nvar(i) ne . then nvar(i)= 'X';
end;
run;

But as the values are numeric and i am converting them as character i get an error.

Can there be any other way in arrays to do

Re: need to change non missing observations into X

gamotte — Mon, 23 Jan 2017 10:48:34 GMT

Hello,

You can use a format :

proc format;
value X .='.'
       other='X';
run;

proc print data=sashelp.class;
var _NUMERIC_;
format _NUMERIC_ X.;
run;

Re: need to change non missing observations into X

RW9 — Mon, 23 Jan 2017 12:39:30 GMT

Do not however, that doesn't "change" the results, only displays them differently. If you really want to "change" the data, then convert the column to character and then the replace should work fine