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: 
kb179208
‎12-19-2019
  • 6 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Selecting observations from a by group containing a specific set o...

by Fluorite | Level 6 in SAS Enterprise Guide
‎12-04-2019 05:15 PM
‎12-04-2019 05:15 PM
I think I know what my problem is. I reformatted the DATE (mmddyyy) variable into a different variable DATE2, where it only shows the year. However, since I set DATE2=DATE it is still picking up the values as distinct.   Thank you once again for all the help!! I am not the best with SQL queries in sas. ... View more

Re: Selecting observations from a by group containing a specific set o...

by Fluorite | Level 6 in SAS Enterprise Guide
‎12-04-2019 04:54 PM
‎12-04-2019 04:54 PM
You are right, the code works for the example I provided so I should have been more clear. I have some IDs that may have 3 observations, but each with a date of 2016. I want to exclude these as they do not also contain date values of 2017 and 2018. ... View more

Re: Selecting observations from a by group containing a specific set o...

by Fluorite | Level 6 in SAS Enterprise Guide
‎12-04-2019 04:39 PM
‎12-04-2019 04:39 PM
One additional question... say that I had duplicate values of some dates (e.g., ID:1 has 2 observations where the date is 2016. Is there a way to modify the code such that it works for these instances as well keeping duplicate values? ... View more

Selecting observations from a by group containing a specific set of da...

by Fluorite | Level 6 in SAS Enterprise Guide
‎12-04-2019 04:26 PM
‎12-04-2019 04:26 PM
Hello all,   I am wondering if it is possible to select observations from a by group containing a specific set of dates. Take the following data for example...   ID    Date 1     2016 1     2017 1     2018 2     2016 2     2017 3     2016 3     2017 3     2018   Based on the data above, I want outputs where IDs can be matched to 2016, 2017, AND 2018 (See example output below)   ID    Date 1     2016 1     2017 1     2018 3     2016 3     2017 3     2018     Any help would be greatly appreciated. Thank you.    P.S. I am using SAS EG version 7.1. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-19-2019 07:53 PM
Likes given to
View All
Quick links