Hello SAS world, I'm working with DI Studio (v4.901) to import flat files, perform some minor editing and sorting, and append the results into a permanant file where Dataflux will take the records and standardize the data. My date column in question is sent as CCYYMMDD. (20170119) I'm importing it as length 8, informat yymmdd8.0, format date9. So.. my results are 19JAN2017. My final transformation is a table loader (appending records) into a end result table. By the end of my process, I need to change this date value into a datetime22 format to match the end result table. I expect the 'time' value to be 0, but the date to be in the date9. format still. (19JAN2017:00:00:00) Can I do this by changing the mapping at time of the table import.. or in one of my transformations such as the table loader? Any helpful suggestions are apppreciated, Chris N.
... View more