SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Output 6.8 PROC SQL Output That Computes Percentages within Subtotals

How It Works

This solution uses a subquery to calculate the subtotal counts for each answer. The code

joins the result of the subquery with the original table and then uses the calculated state

count as the numerator and the subtotal from the subquery as the denominator for the

percentage calculation.

The query uses a GROUP BY clause to combine the data so that the calculation is

performed for State within each answer.

group by survey.Answer, State;

Counting Duplicate Rows in a Table

Problem

You want to count the number of duplicate rows in a table and generate an output

column that ...