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

using sas 9.4 and unable to import data from .xlsx file  error: file is not available  same code is working for csv and .xls file    filename exldata dde "excel|C:\Users\astha.verma\Desktop\SELF\jigsaw\SAS\SAS data sets\[Loandetails.xlsx] Sheet1!r2c1:r12c6" notab;   data exldata1; infile exldata delimiter = '09'x dsd missover; length name position $20.; informat DOJ mmddyy10. DOB mmddyy9.; format DOJ mmddyy10. DOB mmddyy9.; input Name $ Income DOJ DOB Position $ Workex; run; ... View more

I tried to use STIMERw. and TIMEw. informats but am getting error   Kindly go through the attached doc for the refff.     ... View more