Quartz | Level 8

## Calculated Field based off a report output

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculated Field based off a report output

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.

Super User

## Re: Calculated Field based off a report output

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.

Discussion stats