topic Calculated Field based off a report output in SAS Procedures

Calculated Field based off a report output

anweinbe — Thu, 05 Dec 2019 19:33:02 GMT

Hello all.

I have a file that lists out individual holdings by 2 managers. I successfully created a summarized report of total holding by each manager using the code below: However, I actually need the summarized figure from this report in other calculations. Because it is a "report", I wasn't sure how I can call on the summarized field within.

What I am trying to do is say "this manager currently holds $10,000 in apple, and divide that $10,000 by the summarized total from the report to get a % of total column".

proc report data=temp.tsndata1;
columns mgrno fdate shareprice;
define mgrno/group;
define fdate/group;
define shareprice/analysis sum;
run;

Re: Calculated Field based off a report output

ballardw — Thu, 05 Dec 2019 22:06:12 GMT

See if this helps helps.

proc report data=temp.tsndata1;
columns mgrno fdate shareprice,(sum pctsum);
define mgrno/group;
define fdate/group;
define shareprice/analysis;
run;

The comma after shareprice indicates that you want to "nest" results and requesting multiple statistics.

Or you can use alias

proc report data=temp.tsndata1; 
   columns mgrno fdate shareprice shareprice=sharepctsum; 
   define mgrno/group; 
   define fdate/group; 
   define shareprice/analysis sum; 
   define sharepctsum / analysis pctsum;
run;

To get more precise suggestions you would need to provide example data and perhaps expected numbers hand worked from the results of your current report.