Thanks a lot. ... View more

Thanks for the reply. I haven't the last variable in output data https://prnt.sc/rxscbf, but now I now notice in proc print it appears ... View more

in log everything is ok, but the output is wrong. data DTC1; input ID EVENT: $11. AESTDTC: $16.; format AESTDTC1 yymmdd10.; AESTDTC1=input(AESTDTC,yymmdd10.); keep ID EVENT AESTDTC1; datalines; 102 Vomit 2016-01-12T16:05 102 Headache 2016-01-19 103 Severepain 2016-02-17 102 Migraine 2016-02-18T02:00 103 Nausea 2016-02-19 ; proc sort data=DTC1; by ID; run; data DTC2; input ID RFSTDTC: $10.; datalines; 102 2016-01-20 104 2016-01-05 103 2016-02-05 ; proc sort data=DTC1; by ID; run; proc sort data=DTC2; by ID; run; Data DTC3; merge DTC1 DTC2; by ID; run; ... View more

Hi SAS experts, could you tell me what is the problem? because the merge didn't work.Thanks for any help.    data DTC1; input ID EVENT: $11. AESTDTC: $16.; format AESTDTC1 yymmdd10.; AESTDTC1=input(AESTDTC,yymmdd10.); keep ID EVENT AESTDTC1; datalines; 102 Vomit 2016-01-12T16:05 102 Headache 2016-01-19 103 Severepain 2016-02-17 102 Migraine 2016-02-18T02:00 103 Nausea 2016-02-19 ; proc sort data=DTC1; by ID; run; data DTC2; input ID RFSTDTC: $10.; datalines; 102 2016-01-20 104 2016-01-05 103 2016-02-05 ; proc sort data=DTC1; by ID; run; proc sort data=DTC2; by ID; run; Data DTC3; merge DTC1 DTC2; by ID; run; ... View more

ok, thank you. ... View more

Dear Tom, Is it possible to achieve same result without tranwrd (without removing 'UM' or other letters)? I need to have a dynamic code. I started to solve on this way , but it didn't work yet. Thanks in advance.   data task_1; input date: $9. ; day=substr(date,1,2); month=substr(date,3,3); year=substr(date,6,4); if (day) then day1=day; if (year) then year1=year; month1=put(month,3.); if (month) then month1=month; newdate=cats(year1,month1,day1); datalines; 21APR2004 18JUL1981 umfeb2007 UMUMK1968 umumkumk ; ... View more

It's valid,thanks a lot. ... View more

Thank you. I got this output. https://prnt.sc/rtgk4a   There's no way to get like this?  https://prnt.sc/rtgn9n ... View more

Thanks for the reply. It could be as a column of text strings if it's a way to get this output. About "um" and "umk"  yes, I have only this data in this task. ... View more

'um' and 'umk' ... View more