I am very new to SAS and I'm having a problem with PROC REPORT. I have looked through "The Little SAS Book" and some online doc, but can't find an answer. I have some raw data that I'm trying to calculate. can anyone tell me how to subtract one variable from another to produce a variable that is not in the input data or is that not possible with PROC REPORT? This is a sample of my input and also of my SAS code, if that helps. I am trying to sum VOLCAPGB then subtract the variable VOLCAPGB from the grouped variable CONTRACT to produce REMAINING. I basically want the end result to look like this(below in bold), of course this example is just a portion of my data, its rather large. Any help would be greatly appreciated.
I tried to compute the REMAINING variable and my job fails with the below message; which appears that I'm not able to compute the variable with another one that is being analized. I'll keep digging to see what I can come up with. Thanks again for the help.
ERROR: There is more than one ANALYSIS usage associated with
the column defined by the following elements.
Sorry I found that I had a syntax error. I was able to get the compute to work, kind of. It is giving me a value of zero, but i think that should be easy to fix. Thanks you very much for the information and the help.