There are three variables. company_code, year, count.
code year count Sum_count
10 2000 1 1
10 2001 . .
10 2002 1 1
10 2002 1 2
10 2003 1 1
10 2003 1 2
10 2003 1 3
20 2000 . .
20 2000 1 1
I wnat know the code how can I make Sum_count variable.
Sum_count is the sum of count(by code, year).
If you help me I will really appreciate about it.
My english is not good. I'm sorry.
You can make use of BY group processing and the SUM statement. See sample below:
You can make use of BY group processing and the SUM statement. See sample below:
Thank you!!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.