Hi Everyone I need a help to solve the below problem, Please help me on this ASAP. I have data like below data ab; input id$ category$ visit mmddyyyy10. ; cards; 100A xxx 2/1/2020 100A aa 3/1/2020 300C bb 6/2/2020 100A xxx 7/1/2020 200D ccc 9/3/2020 200D ccc 10/3/2020 400E ccc 10/2/2020 100A ddd 11/1/2020 ; run; Below are the sample of required output. id xxx aa bb ccc ddd 100A 2/1/2020 3/1/2020 11/1/2020 200D 9/3/2020 300C 6/2/2020 400E 10/2/2020 ###My desired out put is a dataset### Below is the query which is giving me required out put but i need help to make it in data step select distinct * from ( SELECT OPPORTUNITYID, UPPER(STAGENAME) as STAGENAME, CAST(CREATEDDATE as DATE) as CREATEDDATE FROM tablea WHERE UPPER(STAGENAME) in ('PURSUE','PITCH','LOW','MED','HIGH','CLOSED','LOST') AND STAGENAME ne '' AND t_date =(select max(t_date) from tablea) ) a pivot (MIN(CREATEDDATE) for STAGENAME in ( 'PURSUE' as PURSUE_DT, 'PITCH' as PITCH_DT, 'LOW' as EL_DT, 'MED' as EM_DT, 'HIGH' as EH_DT, 'CLOSED' as CLOSED_DT, 'LOST' as LST_DT) ) as Stages
... View more