BookmarkSubscribeRSS Feed
newbi
SAS Employee

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


1 REPLY 1
SASPhile
Quartz | Level 8

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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 870 views
  • 0 likes
  • 2 in conversation