topic Re: I want to change all the 0 of my SAS multivariables tables by "ns" character. in SAS Programming

I want to change all the 0 of my SAS multivariables tables by "ns" character.

tavil — Thu, 22 Oct 2020 23:38:32 GMT

Re: I want to change all the 0 of my SAS multivariables tables by "ns" character.

jimbarbour — Fri, 23 Oct 2020 00:04:39 GMT

Ah. I see. But perhaps you could give us just a little bit more information on your data and exactly what it is that you are looking for. A sample of data and chart or table of the desired results would be most apt.

Jim

Re: I want to change all the 0 of my SAS multivariables tables by "ns" character.

PGStats — Fri, 23 Oct 2020 03:10:51 GMT

Define a format and associate it with your variables. You only need to specify the 'special' values, other values will adopt the default format.

proc format;
value ns
0 = "ns";
run;

data test;
array x{5};
do i = -5 to -1;
    do j = 1 to 5;
        x{j} = i + j;
        end;
    output;
    end;
format x1-x5 ns.;
drop i j;
run;

proc print data=test noobs; run;

Re: I want to change all the 0 of my SAS multivariables tables by "ns" character.

ChrisNZ — Fri, 23 Oct 2020 04:02:11 GMT

Shortest post ever! 😋