Did you try formatting the date as date? Add a statement like: FORMAT startdate date10.; DATA Work.dataset; infile datalines; input startdate anydtdte16.; if startdate ~=.; numericdate = startdate; format startdate date10.; datalines; StartDate (variable name) Start Date {"ImportId":"startDate","timeZone":"America/Denver"} 5/12/2019 16:16 ; RUN;
... View more