Hello, I am new to SAS and i am trying to get unique list of customers with latest orders and their information. Below is snap shot of dummy data i created. CUSTOMER PRODUCT_ID SERIES_1 SERIES_2 SERIES_3 SERIES_5 ORDER_DATE AIR ACADEMY WELI 1 201305 AIR ACADEMY WELL 1 201206 AIR ACADEMY UWEL 1 201305 AIR ACADEMY UWEL 1 201205 AIR ACADEMY FELD 1 201408 COBAN WELI 1 201408 KIEWITZ WELL 1 201404 COBAN WELL 1 201205 COBAN UWEL 1 201104 KIEWITZ UWEL 1 201005 KIEWITZ FELD 1 201104 COBAN WELL 1 201405 COBAN FELD 1 201405 and i would like the data to be like below CUSTOMER PRODUCT_ID SERIES_1 SERIES_2 SERIES_3 SERIES_5 AIR ACADEMY WELI,UWEL 1 COBAN WELL,FELD,WELI 1 KIEWITZ WELL 1 Any idea how i can achieve this in SAS? thank you in advance. Regards.
... View more