DATA Step, Macro, Functions and more

Storing negative numbers

Reply
SAS Employee
Posts: 73

Storing negative numbers

I have data with type and amount columns.  Wheres type can be debit or credit.  Depanding on type i would to store the amount in positive or negative.

If the type is credit then i would like to store amount value in negative  "-1000" else positive.

Also, is it good idea to store the negative values in table or to calculate the values at query level for reporting ?

Thanks


Super Contributor
Posts: 673

Re: Storing negative numbers

data have;

input type $1-7  amount;

cards;

credit  1000

debit   2000

unknown 3000

;

run;

data want;

set have;

if upcase(type) eq 'CREDIT' then amount=0-amount;

else amount=amount;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 193 views
  • 0 likes
  • 2 in conversation