export excel file and create a code for only the latest record by visit date for

Question

export excel file and create a code for only the latest record by visit date for each client served and a code that will contain only the duplicates (other visits). export excel file and create a code for only the latest record by visit date for each client served and a code that will contain only the duplicates (other visits). P12 ID First name Visit Date DateofBirth Marital Status Gender Residence 21 Adriana 5/13/1993 5/4/195611 Texas 1Adriana 6/5/1993 5/4/1956 1 4 2 Akasha 10/27/1995 10/25/1963 5 2 Akasha 11/19/1995 10/25/1963 6 2 Akasha 12/12/1995 10/25/1963 10/6/1996 9/9/1966 10/29/1996 11/18/1966 1/4/1996 5/22/1964 5 Amanda 1/27/1996 5/22/1964 9/8/1994 5/13/1960 10/1/1994 5/13/1960 1 Texas 2 Kansas 2 Kansas 2 Kansas 1 Florida 1 Florida 1 Kansas 1 Kansas 2 7 3 Alice 8 4 Alicia 9 5 Amanda 1 Maryland 1 Maryland 2 Georgia 2 Georgia 2 Georgia 1 Florida 1Georgia 1 Missouri 1 Florida 1 Florida 1Florida 1 Florida 1Texas 1Texas 1 Louisianna 1 Maryland 1 Maryland 1 Florida 1Florida 1 Florida 1Florida 1 Kansas 1Kansas 11 6 Amber 12 6 Amber 7 Anantha 3/16/1997 1/12/1968 15 7 Anantha 6 8 Ariana 17 9 Ashlyn 7 Anantha 4/8/1997 1/12/1968 5/1/1997 1/12/1968 2/13/1994 8/22/1958 8/19/1995 3/29/1963 2 18 10 Audrey 5/19/1995 6/22/1962 4/23/1994 3/20/1959 0 12 Barbara 5/16/1994 5/29/1959 12 Barbara 6/8/1994 5/29/1959 9 11 Avery 12 Barbara 7/1/1994 5/29/1959 3 3 13 Charlotte 1/29/1997 8/25/1967 4 13 Charlotte 2/21/1997 8/25/1967 5 14 Chloe 6/25/1992 8/28/1953 9/11/1995 6/7/1963 10/4/1995 6/7/1963 16 Destiny2/19/1996 10/9/1964 8/21/1996 4/22/1966 9/13/1996 4/22/1966 2/5/1991 6/10/1949 2/16/1995 9/15/1961 3/11/1995 9/15/1961 6 15 Claire 7 15 Claire 9 17 Ellie ) 17 Ellie 18 Emma 19 Faith HData

Explanation / Answer

Proc Import DATAFILE”your XLSX file”

Out=work.myexcel

DBMS=XLSX

REPLACE;

RUN;

Proc SQL;

Select*from myexcel;

Group by First_name;

Sort by Visit_Date;

Quit;

Proc Print data=myexcel;

Run;

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.