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!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.