Hi all, I want to ask a question regarding input DATETIME to SAS. I am using data from Thomson Reuters Tick History (TRTH). In Version1 of TRTH, data had two separate columns for Date and Time. However, in the second version, TRTH changes that structure and now they provide DATETIME column. I want to input csv data to SAS by using codes (not manual (File-Import Data)). When I use data from version 1, I employed the format (and informat) Date11. for Date and time18.3 for time. For example, I run the following codes and it works very well: data test; infile _____________ " delimiter = _______________; informat Date_G_ DATE11. ; informat Time_G_ time18.3 ; format Date_G_ DATE11. ; format Time_G_ time18.3 ; input Date_G_ Time_G_; run; However, now, I need to use format and informat for DATETIME column. In csv format, it looks like that : 2018-04-06T15:45:00.377379752Z I did some search, however cannot get result. I would appreciate it if you could help me regarding that. Thanks in advance. Best
... View more