topic Re: Proc Expand generate -0 in SAS Programming

Proc Expand generate -0

hhchenfx — Sun, 03 Jan 2021 18:42:23 GMT

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

Re: Proc Expand generate -0

PaigeMiller — Sun, 03 Jan 2021 18:47:55 GMT

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.

Re: Proc Expand generate -0

PGStats — Sun, 03 Jan 2021 20:24:54 GMT

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

Re: Proc Expand generate -0

hhchenfx — Sun, 03 Jan 2021 22:02:08 GMT

Thanks a lot!

It works.

HHC