https://communities.sas.com/t5/New-SAS-User/Negative-Money-displaying-wrongly-in-SAS-Guide/m-p/596894#M16043 <P>Hi there,</P><P>&nbsp;</P><P>I'm currently working with a data base that contains negative currency values like this.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="s1.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33158i9F66388664DB920A/image-size/large?v=v2&amp;px=999" role="button" title="s1.png" alt="s1.png" /></span></P><P>&nbsp;</P><P>The problem is when i display the table on SAS those values displays as a super big number.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="s2.png" style="width: 494px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33159iDE4C58F18BBC7F88/image-size/large?v=v2&amp;px=999" role="button" title="s2.png" alt="s2.png" /></span></P><P>&nbsp;</P><P>I've tried several formatting options but the results are useless, SAS is reading the number in that way. Any help will be welcome.</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 16 Oct 2019 13:51:16 GMT CarlangA 2019-10-16T13:51:16Z https://communities.sas.com/t5/New-SAS-User/Negative-Money-displaying-wrongly-in-SAS-Guide/m-p/596894#M16043 <P>Hi there,</P><P>&nbsp;</P><P>I'm currently working with a data base that contains negative currency values like this.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="s1.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33158i9F66388664DB920A/image-size/large?v=v2&amp;px=999" role="button" title="s1.png" alt="s1.png" /></span></P><P>&nbsp;</P><P>The problem is when i display the table on SAS those values displays as a super big number.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="s2.png" style="width: 494px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33159iDE4C58F18BBC7F88/image-size/large?v=v2&amp;px=999" role="button" title="s2.png" alt="s2.png" /></span></P><P>&nbsp;</P><P>I've tried several formatting options but the results are useless, SAS is reading the number in that way. Any help will be welcome.</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 16 Oct 2019 13:51:16 GMT https://communities.sas.com/t5/New-SAS-User/Negative-Money-displaying-wrongly-in-SAS-Guide/m-p/596894#M16043 CarlangA 2019-10-16T13:51:16Z https://communities.sas.com/t5/New-SAS-User/Negative-Money-displaying-wrongly-in-SAS-Guide/m-p/596919#M16046 <P>What format are you applying to the variable? In the first picture and the second picture?</P> <P>And is the first picture from an external data base? If so you may have a conversion issue based on the display rules from the data base.</P> <P>&nbsp;</P> <P>What value to expect to see?</P> <P>&nbsp;</P> <P>What is the actual value of the number? (May have to display as best32. )</P> Wed, 16 Oct 2019 14:43:05 GMT https://communities.sas.com/t5/New-SAS-User/Negative-Money-displaying-wrongly-in-SAS-Guide/m-p/596919#M16046 ballardw 2019-10-16T14:43:05Z