I am incredibly new to sas or any database programming. I use SAS EG as I find it easier to work with. Question, how can I change my datetime column into a Date9. format so I can match using these dates? I would like to do this using the query builder if possible. When I use the datepart function in the advanced expressions I end up with negative numbers on my new calculated column.   Thanks 🙂   ... View more

I have the following Three variables:   Person   Registration   Registration_Date   I would like to remove any complete duplicates and any rows that contain the same Person and Registration, keeping the latest registration. Example Below   Person   Registration   Registration_Date Pete             A                 2019 Marco          A                 1993 Sam             B                  2002 Sam             B                  2003 Sam             C                 1960 David            A                  2002 David            A                  2002       This should result in:   Person   Registration   Registration_Date Pete             A                 2019 Marco          A                 1993 Sam             B                  2003 Sam             C                 1960 David            A                  2002       ... View more

Completely new to SAS Enterprise Guide. I am currently working on a table where I have "Offender" and "County" The offender can repeat but should only be counted as 1 even if it shows up 10 times. How can I count the occurance of county based on a unique Offender?   Offender          County 1                       Duval 1                       Duval 1                       Leon 2                       Hillsborough 4                       Duval 1                       Duval 5                       Clay 2                       Leon   This should result in:   Duval   2 Leon    2 Clay     1 Hillsborough   1 Manatee  1 ... View more