topic Re: convert from 0.00% to blank for a column value in SAS Programming

convert from 0.00% to blank for a column value

PujaDas — Thu, 15 Dec 2016 07:22:10 GMT

Hi,

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 it simply makes 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

Re: convert from 0.00% to blank for a column value

Reeza — Thu, 15 Dec 2016 07:24:13 GMT

Show your code, and provide sample data please.

Re: convert from 0.00% to blank for a column value

Kalind_Patel — Thu, 15 Dec 2016 07:34:25 GMT

Hi @PujaDas;

If you want to change numeric variable to blank,

you have to use options missing="";

you can also use format or picture format, as @Reeza asked for the code, it will give more clarification to us that what you actually want to do!

Re: convert from 0.00% to blank for a column value

Kurt_Bremser — Thu, 15 Dec 2016 08:00:08 GMT

What purpose does the intermediate step serve, when the end result should be a blank for zero anyway?

Rather do

length charval $10;
if numval = 0
then charval = " ";
else charval = put(numval,percent10.2);

Re: convert from 0.00% to blank for a column value

PujaDas — Thu, 15 Dec 2016 08:44:24 GMT

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;

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;

endcomp;

Re: convert from 0.00% to blank for a column value

Kurt_Bremser — Thu, 15 Dec 2016 08:49:33 GMT

Do not confuse displayed values with stored values, and stay true to variable types.

If a variable is defined as numeric, do not use strings for comparison.

A numeric variable with a percentw.d format will display as 0.00%, but the value will be 0.

if numvar = '0.00%'

will never work, but

if numvar = 0

will work.

To get more specific information, I suggest you post the output of proc contents for the dataset used in the proc report.

Re: convert from 0.00% to blank for a column value

PujaDas — Thu, 15 Dec 2016 09:04:14 GMT

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.

Re: convert from 0.00% to blank for a column value

PujaDas — Thu, 15 Dec 2016 09:18:04 GMT

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;

Re: convert from 0.00% to blank for a column value

Kurt_Bremser — Thu, 15 Dec 2016 09:23:34 GMT

So you use the 5.2 format in the put function, and then expect ytd2 to be just '0'?

Think again.

16         data _null_;
17         ytd1 = 0;
18         YTD2=put(round(YTD1,.01),5.2);
19         put ytd2=;
20         run;

YTD2=0.00