Hello, I am trying to have my format to read exactly as below but in order for it to work I had to put in ZZ to force it to keep last Here is my code Proc Format; Value $test; "NIA Lvl 1"= "NIA 1" "NIA Lvl 2"="NIA 2" "NIA Lvl 3"="NIA 3" "NIA X" "NIA XYZ" "NIA O"= NIA Old" "NIA No"=NIA None" NIA Miss"=NIA Missing" Run; Data Qtr2; set Qtr; array{15} do count =1 to 15; if try {count}=. then try {count}=0; end; If NIA= NIA No" then "ZNIA None"; if NIA="NIA Miss" then "ZZ NIA Missing"; run; I then create a PDF report However, the zz show up in my report and it is in the order listed. how can i keep the order just as listed but without the ZZ showing on the report
... View more