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: 
katsas1
‎01-12-2017
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Selecting rows with only one unique value per subject

by Calcite | Level 5 in SAS Programming
‎01-03-2017 11:57 AM
‎01-03-2017 11:57 AM
This solution worked great. It's particularly useful if duplicate records need to be retain (like dollar amounts for each row). Thank you! ... View more

Re: Selecting rows with only one unique value per subject

by Calcite | Level 5 in SAS Programming
‎12-29-2016 06:34 PM
‎12-29-2016 06:34 PM
Nodup deletes duplicated observations. I'm after retaining records with a single unique sport per venue and removing those with more than than one unique observation. Nodup retains venues with multiple unique observations.  ... View more

Selecting rows with only one unique value per subject

by Calcite | Level 5 in SAS Programming
‎12-29-2016 05:59 PM
‎12-29-2016 05:59 PM
The dataset looks something like this    VENUE  SPORT A           Hockey B           Basketball C           Softball  B           Hockey  C           Softball A           Football    I need to select only venues with one unique sport played there, so in this case Venue C would get selected because only one sport (softball) is played there. Any help would be greatly appreciated. Thanks.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-12-2017 05:57 PM
Quick links