Hi I have a small problem which I tried to solve but got stuck. I created the following data set - data car;
infile datalines dsd;
input brand $ loan ;
datalines;
mini,70
,30
,20
,10
toyota,80
,40
;
run; f There are two variables - brand and loan. what i need to do is in first observation of each brand, loan variable should show only outstanding loan amount. for example - for brand mini in first observation, output should be - mini 70-(30+20+10) = 10, and rest all observations remaining same. EXPECTED FULL OUTPUT brand loan mini 10 30 20 10 Toyota 40 40 I NEED TO DO THIS USING DO LOOP.
... View more