format excel date to sas date

Reply
Frequent Contributor
Posts: 96

format excel date to sas date

Hi All

I have a data set in excel which has some date information. I am trying to import it to sas. I have formated the date coloum in excel to date. As a result, in excel I can read the dates as mm/dd/yy. However when I import the data to SAS and read the dates, it is in different format. Also the date column is converted into character. For instance, the data in excel is as follows:

Firm     date

A     05/22/2008

B     2/19/2003

When I read the date in the SAS, it looks as follows:

Firm     date

A          39590

B          37671

The code I used to import the excel file into SAS is:

proc import out=work.a

datafile = "c:\users\destop\sas\b.xls"

dbms =xls replace;

getnames=yes;

run;

I would appreciate if someone help me modify this code so that I can read the date correctly.

Thank you.

Super User
Posts: 10,497

Re: format excel date to sas date

Try applying a format such as mmddyy10 to the SAS data.

for example:

Proc print data=work.a;

var date;

format data mmddyy10.;

run;

The numeric values in the SAS data set are the number of days since 1 Jan 1960 and formats will display those numbers in a more human readable version.

Ask a Question
Discussion stats
  • 1 reply
  • 313 views
  • 0 likes
  • 2 in conversation