• Community
    • Home
    • Welcome
      • Getting Started
      • Community Memo
      • All Things Community
      • SAS Customer Recognition Awards (2024)
      • SAS Customer Recognition Awards (2023)
    • SAS Community Library
    • SAS Product Suggestions
    • Upcoming Events
    • SAS Customer Recognition Awards
    • All Recent Topics
  • Learn
    • New SAS User
    • SAS Software for Learning Community
    • Ask the Expert
    • SAS Certification
    • SAS Tips from the Community
    • SAS Training
      • Programming 1 and 2
      • Advanced Programming
      • Course Case Studies and Challenges
      • Trustworthy AI
    • SAS Global Forum Proceedings 2021
    • Tech Report Archive
    • SAS Insights Archive
  • Programming
    • SAS Programming
    • SAS Procedures
    • SAS Enterprise Guide
    • SAS Studio
    • Graphics Programming
    • ODS and Base Reporting
    • SAS Code Examples
    • SAS Web Report Studio
    • Developers
  • Analytics
    • Statistical Procedures
    • SAS Data Science
    • Mathematical Optimization, Discrete-Event Simulation, and OR
    • SAS/IML Software and Matrix Computations
    • SAS Forecasting and Econometrics
    • Streaming Analytics
    • Research and Science from SAS
  • SAS Viya
    • SAS Viya
    • SAS Viya on Microsoft Azure
    • SAS Viya Release Updates
    • Moving to SAS Viya
    • SAS Visual Analytics
    • SAS Visual Analytics Gallery
    • Your Journey to Success
    • SAS Viya Workbench
      • SAS Viya Workbench: Getting Started
      • SAS Viya Workbench Discussion
      • SAS Viya Workbench: Release Updates
  • Administration
    • Administration and Deployment
    • Architecture
    • SAS Hot Fix Announcements
    • SUGA
  • Solutions
    • Microsoft Integration with SAS
    • Decisioning
    • SAS Decision Builder
    • Data Management
    • Customer Intelligence
      • SAS Customer Intelligence
      • SAS Customer Intelligence 360 Release Notes
      • SAS 360 Match
    • Risk and Fraud
      • SAS Risk Management
      • Fraud, AML and Security Intelligence
      • SAS Risk Release Updates
      • Risk & Finance Analytics
      • Insurance Fraud
      • MRM AI Governance Working Group
      • SAS Quant Community
    • SAS Health
      • SAS Health and Life Sciences
      • SAS Life Science Analytics Framework
  • Hubs
    • Regional Hubs
      • SAS User Groups
      • SAS Community Nordic
      • AML Nordic User Group
      • SAS Japan
      • SAS Korea
      • CoDe SAS German
      • SAS Plattform Netzwerk
      • SAS Brazil Community
      • SAS Spanish Community
      • SAS Users Group in Israel
      • 欢迎来到SAS中文社区!
      • Ottawa Area SAS Users' Society
      • Toronto Area SAS Users Group
      • SAS Türkiye Community
    • Special Interest Hubs
      • SAS Hacker's Hub
      • SAS Innovate 2026
      • SAS Analytics Explorers
      • The Curiosity Cup
      • SAS Inner Circle Panel
      • SAS Hackathon Team Profiles (Past)
      • SAS Explore
      • Reporting and Optimization
      • Intern Alumni Network Community
Sign In

Search the Community

Showing results for 
Search instead for 
Did you mean: 
Search Options
  • Subscribe to RSS Feed for this Search
Advanced Hide Advanced
  • Posts
  • Users
  • Places
  • Products
Advanced Search Options
Search Modifiers:
You can apply modifiers to the terms you enter in the search field.
Use quotes to search for an "exact phrase".
Use the plus sign to search for +one +or +more +words.
Use the minus sign to -exclude -certain -words from your search.
Limits search results to topics that have no replies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
1,676 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

Cumulative Sum - All Solutions Not Working

by Fluorite | Level 6 toomanystepsint in SAS Data Management
‎09-04-2024 11:23 AM
‎09-04-2024 11:23 AM
I have a dataset.   It has 3 variables: -year -date -number   I want the cumulative value of number resetting every year.   The typical sas advice does not work for me. &n...
Show results in replies (3)
  • ...irst.year then cumsum=0; cumsum+number; run; As a SAS user, I think computing cumulative sums in SAS i...
  • @toomanystepsint    You asked for advice to (emphasis mine) I want the cumulative...
  • ...umber   I want the cumulative value of number resetting every year.   The typical sas a...

Cumulative Distribution Function (CDF) for Generalized Extreme Value (...

by Calcite | Level 5 Tom25 in SAS Programming
‎07-20-2025 01:36 PM
‎07-20-2025 01:36 PM
Hello,   I previously read that the Cumulative Distribution Function (CDF) for the Generalized Extreme Value (GEV) distribution can be calculated using the CDF function with the 'GEV' d...
Show results in replies (1)
  • For a general implementation of the GEV in Base SAS (using PROC FCMP and the DATA step), see the ar...

Calculating cumulative sum

by Obsidian | Level 7 ndamo in SAS Programming
‎09-01-2022 11:35 AM
‎09-01-2022 11:35 AM
I am facing cumulative sum calculation. In my dataset, the columns to be summed are something like Cycle_1 to Cycle_65. My program works to calculate the cumulative from cycle_1 to cycle_9. H...
Show results in replies (1)
  • Perhaps your issue is you created a CHARACTER visit variable with left aligned digit strings so tha...

Calculating cumulative sum

by Barite | Level 11 ilikesas in SAS Data Management
‎12-10-2014 11:12 PM
1 Like
‎12-10-2014 11:12 PM
1 Like
Hi, my question might be too simple but I actually have some trouble figuring it out... what I want to do is to calculate the cumulative sum of a column, so if I have the following table: v...
Show results in replies (2)
  • ...ssume that in the previous case I had to calculate the cumulative sum for one company, but now I need to d...
  • Hi, For many companies you need by processing. Just make sure data is sorted by company variable...

VA Report Example: Ways to use the Cumulative Period operator

by SAS Employee TeriPatsilaras in SAS Communities Library
‎09-23-2020 12:46 PM
9 Likes
‎09-23-2020 12:46 PM
9 Likes
In this post, I will show ways to use the cumulative period operator but first let’s break down the inputs. See the SAS documentation for more details about the SAS Visual Analytics Operators for D...
  • Find more articles tagged with:
  • GEL
Labels:
  • SAS Visual Analytics
  • SAS Viya
  • Tips and Tricks
Show results in comments (3)
  • ...sing the Cumulative period option. I have got a table with three columns: Date (Date), Value1 (n...
  • Great article. It has helped me a lot. I also needed to calculate monthly cumulative difference o...
  • ...herefore there is no "by group" that the Cumulative Period can aggregate on.  In the new Value3 c...

Cumulative Sum

by Calcite | Level 5 scouttier in SAS Programming
‎11-01-2017 03:44 PM
‎11-01-2017 03:44 PM
Hello, I would like my data to look something like this: Area Value CumValue A 5 45 A 5 45 A 15 45 A 20 45 B 10 10 C 5 5 D 10 25 D 5 25 D 5 25...
Show results in replies (2)
  • ...emoves duplicates and condenses each area into one. I would like each area to remain and have the final cumulative...
  • @scouttier: If you want to do it in one data step, this will work: data want; do until(last.are...

Cumulative ID Tracking with Date summatization

by Quartz | Level 8 shasank in SAS Programming
‎09-27-2024 12:45 PM
‎09-27-2024 12:45 PM
Hi Community,    I have a requirement to summarize a table with dates. Any help is appreciated.     Raw data: SubjectName QueryID ParentQueryID OpenDate 0001-S0...
Show results in replies (1)
  • What you gonna do ? If there were not link in ID . Like: 0001-S002 818930 818929 21-Nov-22 0001-S...

Cumulative Sum

by Fluorite | Level 6 RDellaVilla in SAS Programming
‎11-12-2021 01:39 PM
‎11-12-2021 01:39 PM
Hi,  I have some issues to compute some Cumulative Sum. I have a dataset organized with some variables, and I have grouped all the different results according to three different variables (in t...
Show results in replies (2)
  • So as for the Log, no mistake is shown/nor warning message: "   427 *Cumulative A...
  • First thing is that if it is FIRST.PERMNO it is by definition also FIRST.EVTDATE because you have n...

Cumulative sum

by Quartz | Level 8 dac_js in New SAS User
‎06-25-2022 10:21 PM
‎06-25-2022 10:21 PM
I have data in following format:   data have; input id var1 var2; datalines; 1 0 0 1 1 0 1 1 0 1 0 0 2 1 1 2 1 0 2 0 0 2 1 1 2 1 0 ; run;   Trying to create cumulative...
Show results in replies (2)
  • Like this? If you try to place the cumulative totals into the same named variable you add a great d...
  • Use new, retained variables: data want; set have (rename=(var1=_var1 var2=_var2)); by id; if fir...

Cumulative Amount of consecutive days

by Quartz | Level 8 Zatere in SAS Programming
‎07-18-2023 04:10 PM
‎07-18-2023 04:10 PM
Hello, I would ask for your help on the below.   I want to find the sum of a values for X consecutive days by ID.   Consecutive days means days that happen one after the other wit...
Show results in replies (2)
  • ...ommunities.sas.com/t5/SAS-Programming/Cumulative-Amount-based-on-sequential-dates/td-p/791870 
  • @Zatere wrote: I have done a few testing and I think that it works! Thanks a lot. It is a...
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros