https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/814849#M40732 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/362518">@durgeshrpatil</a>&nbsp; The code has been provided earlier in this thread.</P> Tue, 24 May 2022 11:29:17 GMT PaigeMiller 2022-05-24T11:29:17Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43311#M5089 I need to convert a column of numbers to the opposite signs (positive to negative and negative to positive). I have been able to set up a computed column using the case function. However some of the values are zeros and nulls and these are coming out as "1". Any ideas or other functions I could use? <BR /> <BR /> Thanks! Wed, 10 Jun 2009 21:15:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43311#M5089 EG_Mel 2009-06-10T21:15:15Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43312#M5090 Just multiply by -1 . Thu, 11 Jun 2009 02:46:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43312#M5090 Doc_Duke 2009-06-11T02:46:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43313#M5091 - (minus) can be a "unary operator", like [pre] fall = - rise ; [/pre] It is also referred to as a "prefix operator" in the doc at <A href="http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000780367.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000780367.htm</A> .<BR /> <BR /> PeterC Thu, 11 Jun 2009 11:48:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43313#M5091 Peter_C 2009-06-11T11:48:43Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43314#M5092 If the var is called "x", then<BR /> <BR /> x = -x;<BR /> <BR /> changes the sign and you don't create a new variable. In the context of an assignment statement (data step), "=" means "assign the value of the expression on the right to the variable on the left". Similar to the SQL 'as' clause. Thu, 11 Jun 2009 13:11:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/43314#M5092 Doc_Duke 2009-06-11T13:11:52Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/339406#M22541 <P>how can I convert the negative numbers to positive only without changing positive numbers?</P> <P>&nbsp;</P> <P>your help will be appreciated</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 08 Mar 2017 20:07:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/339406#M22541 lalohg 2017-03-08T20:07:31Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/339416#M22542 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/39435">@lalohg</a>&nbsp;You mean, take the absolute value? &nbsp;Use the <A href="http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#p0xkrj83an7dknn1sgukpmnphcje.htm" target="_self">ABS() function</A>:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">x = abs(x);</CODE></PRE> Wed, 08 Mar 2017 20:13:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/339416#M22542 ChrisHemedinger 2017-03-08T20:13:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/339424#M22543 <P>Yes!!! &nbsp;Thanks Chris</P> Wed, 08 Mar 2017 20:29:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/339424#M22543 lalohg 2017-03-08T20:29:21Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/814834#M40731 Could you please share in the code Tue, 24 May 2022 09:51:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/814834#M40731 durgeshrpatil 2022-05-24T09:51:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/814849#M40732 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/362518">@durgeshrpatil</a>&nbsp; The code has been provided earlier in this thread.</P> Tue, 24 May 2022 11:29:17 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-positive-number-to-negative-and-negative-to-positive/m-p/814849#M40732 PaigeMiller 2022-05-24T11:29:17Z