cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ohsofaizy
‎01-14-2019
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: New User - How to sum a column based on criteria from other column...

by Calcite | Level 5 in New SAS User
‎01-09-2019 04:16 PM
‎01-09-2019 04:16 PM
Thank you! Let me take a look at this and see if I can figure it out. Thanks! ... View more

Re: New User - How to sum a column based on criteria from other column...

by Calcite | Level 5 in New SAS User
‎01-09-2019 04:12 PM
‎01-09-2019 04:12 PM
Since the cash is greater than 0 (10 in this case), and there are no trading ids within a range of 12 the quantity of 400 will remain. Ultimately the sum of the "quantity" column should still be the same in both tables. ... View more

Re: New User - How to sum a column based on criteria from other column...

by Calcite | Level 5 in New SAS User
‎01-09-2019 04:03 PM
‎01-09-2019 04:03 PM
I edited Amazon...it should be 1000. Thanks for the heads up. Samsung has two entries because two of the trading ids are within the range of 12 so must be added together. The third Samsung entry has a trading id which is in not in range of any other trading id so is shown alone. ... View more

New User - How to sum a column based on criteria from other columns?

by Calcite | Level 5 in New SAS User
‎01-09-2019 03:41 PM
‎01-09-2019 03:41 PM
Security Trading ID Quantity Cash Apple 560 400 10 Apple 561 400 0 Apple 562 200 0 IBM 987 60 10 IBM 435 50 5 Amazon 755 500 10 Amazon 756 500 0 Nike 757 500 0 Samsung 982 100 10 Samsung 983 200 0 Samsung 122 400 10   Hi   Based on the table above I am trying to figure out a way in SAS 9.3 (EG 5.1) using proc SQL   Whenever cash > 0 then I would like to group the security and sum 'quantity' if trading IDs are within a range of 12. Ultimately I would like this particular table to come out as:    Security Quantity Apple 1000 IBM 60 IBM 50 Amazon 1000 Nike 500 Samsung 300 Samsung 400 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-14-2019 04:25 PM
Quick links