Import YYYY-MM-DD and hh:mm:ss

[hhchenfx]

Hi Everyone,

I have a csv file as below, and can you please help me to import it.

I always have hard time dealing with date and time.

Thank you so much.

HHC

price,product_code,date,time
100.0,AA,2022-07-27,07:00:00
450.0,AAXGH,2022-07-27,07:30:00

[PaigeMiller]

PROC IMPORT reads the data perfectly

proc import datafile="f:\my documents\example.csv" dbms=csv out=want;
run;

[Kurt_Bremser · Accepted solution]

data want;
infile "path to your file" dlm="," dsd truncover firstobs=2;
input price,' product_code $ date :yymmdd10. time :time8.;
format date yymmdd10. time time8.;
run;

[hhchenfx]

Thank you all for helping.

HHC