When your code generates error is a good practice on this forum to post the log with the code and errors. Paste the result into a code box opened using the forum menu icon {I}.
SAS date / time reading informats do not like that , that was in the middle of the date and time. So you need to parse the data a bit.
One way:
DATA WHATSAPP;
infile datalines dlm=":" ;
INFORMAT dttxt $19. NAME $CHAR20. MESSAGE $CHAR100.;
INPUT dttxt 1-19 NAME MESSAGE;
date_time = input(compress(dttxt,','),anydtdtm.);
format date_time datetime20.;
drop dttxt;
DATALINES;
1/18/17, 6:57:00 PM: TSV: Everyone claps for Diana who got selected for job
1/18/17, 6:58:32 PM: Christopher Walken (techguy):
1/18/17, 6:58:55 PM: TSV: I'm so happy for you Diana More reasons to go shopping
1/18/17, 7:02:37 PM: Gaggan Anand (next desk): Awesome Diana Congrats
;
RUN;
I changed to code to use : as delimiter as the posted example did not actually correspond to the columns specified by @21 and @26 when copied to my editor.
... View more
