Help using Base SAS procedures

sas import file excel

Reply
Occasional Contributor
Posts: 9

sas import file excel

Hi all,

I have a problem to import an excel file with xls = dbms.

I have a datetime field format var1 "03/11/2015 10:04:04" with two space between the date and time. When I import the file I truncates the field by putting only the date. How can I import the field as described above?

thank's a lot

bie bie

PROC IMPORT OUT= WORK.OFFERTE_EB

            DATAFILE= "my path"

            DBMS=xls REPLACE ;

  GETNAMES=yes;

RUN;

Super User
Posts: 10,516

Re: sas import file excel

When automatic conversions from Excel fail (moderately often due to Excel users) one solution is often to save the Excel to another format such as CSV an import that file as you can modify the code generated by a proc import call to use custom formats or provide more complicated parsing.

Occasional Contributor
Posts: 9

Re: sas import file excel

I can not change the file format should I use excel and I can not change the format of the field excel

Super User
Posts: 17,868

Re: sas import file excel

Can you access the file via the libname method?

Look into DBASTYPE option, as well as scandate, scantime options.

Ask a Question
Discussion stats
  • 3 replies
  • 273 views
  • 0 likes
  • 3 in conversation