topic Import YYYY-MM-DD and hh:mm:ss in SAS Programming

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

hhchenfx — Thu, 28 Jul 2022 20:25:44 GMT

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

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

PaigeMiller — Thu, 28 Jul 2022 20:36:22 GMT

PROC IMPORT reads the data perfectly

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

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

Kurt_Bremser — Thu, 28 Jul 2022 20:45:04 GMT

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;

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

hhchenfx — Fri, 29 Jul 2022 01:07:20 GMT

Thank you all for helping.

HHC