its already been converted into char in the existing code.I cant ignore that.   YTD2=put(round(YTD1,.01),5.2); if YTD2='0' then YTD='0.00';   YTD=YTD2 || Percent_Sign;     ... View more

YTD2= PUT(ROUND(YTD_1,.01),5.2); IF YTD2='0' THEN YTD_1='0.00';   YTD= YTD2 || PERCENT_SIGN;   its been don ein the existing code for some purpose.We cant avoid that. So its not in numeric.   ... View more

Sample data :                            OnedayRound     YTD      NAV      roundedNAV   Fund1 Details      0.00%                0.00%   0.00       0.000   I have tried the below two but the desired output is not coming. NOTE : value of the column is converted to char to || percentage Sign.   CODE 1 : Compute Index_id; if Index_Id ne '0' then     if( OnedatRound =(' ' | '0.00%') & YTD=(' ' | '0.00%') & NAV=(' ' | '0.00) & roundedNAV=(' ' | '0.000'))     tehn do;        OnedayRound=' ';            YTD=' ';        NAV=' ';        roundedNAV=' ';   end; end; endcomp;;     CODE2:(have tried only for YTD column) compute percentage; if Index_Id ne '0' then    if(YTD='0.00%')    YTD_1=' ';       if (YTD_1=(' ' || Percent_sign)       then do;       YTD=' ';       end; end; endcomp; ... View more

Hi,   Thank you for your support. Actually the requirement is to check the value of a column if '0.00%' then it would be blank. First of all to check for a condition that if the value of a column is 0 then make it as '0.00%'. I have done it to make it as char fist using put() then || with percentage.Its working fine. For the next case While I am trying to check if the column value is '0.00%' then make it as blank,dats not working. I feel that when I am trying to check if the value is equal to '0.00%' then make it as col1=' ' ,it simply make it as blank || %. which cant match the condition anymore. thats why expected output is not coming. can you please help me how to resolve this one??   thanks, Puja ... View more

Sorry for creating the confusion.. i am changing no its col1.. i have done the typing mistake here..i have attachd the log here.. ... View more

Hi, Yeah sorry i havnt put in with proper indentation. One thing, here i am trying to put blank whereever the value of the column is zero.. so in this case, i feel col1_char=" " should not be in the else part. Am i right? ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

I have tried this one. But is not reflected here. Compute col1_char; If index_id ne 0 Then do; If col1='0' Then do; Col1_char=put(col1,7.2); Col1_char=" "; Endcomp; Can you please let me know where i am doing mistake? The demo report is attached with this. ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

First of all thnak you for your suggesion.   For Proc Report I have tried this one : compute index=0; if index ^= '0' then do; if maths='0' and history='0' and science='0' text ' ';   Its not working.Can you please help me out with what is the correct one?     Thanks, Puja ... View more