Hi all~
I want to calculate the percentage of each degree student numbers in each year.
but if I use aggregated measure to do this, the results are as follows picture.
how can I do so the result will present like each year's percentage sum for 100%.

Hi all~
I want to calculate the percentage of each degree student numbers in each year.
but if I use aggregated measure to do this, the results are as follows picture.
how can I do so the result will present like each year's percentage sum for 100%.

What application are you using? SAS, EG, SAS Studio, WRS?
I don't recognize the interface
sorry ,I should describe it clearly.
Actucally, I use SAS VA.
I merged the thread into the one in the VA community.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.