topic quickest way to generate total and % in file? in SAS Enterprise Guide

quickest way to generate total and % in file?

SciFiGuy0 — Tue, 16 Sep 2014 21:09:35 GMT

I'm trying to figure out the quickest way to generate totals and % of total in Enterprise Guide. Is there a way to do it using the Query Builder?

My data looks like this:

I want to calculate the sum of dollar amount for each color and then the % of the total overall dollar amount for each color.

Thanks

mohamed_zaki — Tue, 16 Sep 2014 21:58:40 GMT

Please follow the next steps:

1-Import your data

2-Select Query Builder

3-Drop the Color Column to the Select Data

4.1-Right click on the Dollar Amount column

4.2-Choose Select Summarized Column...

4.3-Choose SUM Distinct in the summary field from the new window opened

4.4-Click NEXT then Finish

5.1-Right click on the Dollar Amount column

5.2-Choose Select Summarized Column...

5.3-Choose MEAN Distinct in the summary field from the new window opened

5.4-Click NEXT then Finish

6-Click RUN

mohamed zaki

Reeza — Tue, 16 Sep 2014 22:31:04 GMT

Tasks>Describe>One Way Frequencies

Analysis Variable >Colour

Frequency> Dollar Amount

Optional:

Click Statistics and choose count and percentages only.

Click Results - Create data set with count and percentages.