Proc Expand generate -0

[hhchenfx]

Hi Everyone,

I have a column out which contain only value 1, 0,-1 based on IF THEN ELSE statement.

Then, I use proc expand to calculate moving sum and the output has -0 (in scientific format). 

I can kill the -0 with INT() but my program has hundred of column like that. Thus it is better that I solve the issue inside the proc expand.

Can you please help?

Thanks,

HHC

[PaigeMiller]

First, you could change the format of all of these variables such that –0 will appear as zero. Although I am surprised that a sum of integers would give a –0, and I am thinking perhaps you haven't really described everything going on.

If that's not it, you could write an ARRAY to perform whatever task you want on all variables.

[PGStats · Accepted solution]

Change the conversion method to something other than the default (SPLINE). Try METHOD=STEP, for example.

[hhchenfx]

Thanks a lot!

It works.

HHC