Well I am not really sure what happened but it worked, here is what I ended up using.
proc import out=work.data
datafile = 'filepath'
DBMS = EXCEL Replace;
RANGE="Sheet1$";
getnames = yes;
mixed = no;
scantext = yes;
usedate = yes;
scantime = no;
run;
I am really confused because it wouldn't run, I got up to walk around and clear my head. Ran it again without changing anything and it worked.
... View more
