format excel date to sas date

shalmali — Fri, 13 Jul 2012 20:05:18 GMT

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.

Re: format excel date to sas date

ballardw — Fri, 13 Jul 2012 22:09:53 GMT

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.

topic Re: format excel date to sas date in SAS Programming

format excel date to sas date

Re: format excel date to sas date