Tips:Conversion from Excel Date to SAS Date

http://www.sascommunity.org/wiki/Tips:Conversion_from_Excel_Date_to_SAS_Date

 

Time function MDY( )

data x; /*first=download_date=MDY(&x_month,&x_day,&x_year);*/ first=mdy(9,2,2012); last=mdy(5,15,2013); count=last-first; run; proc print;run;

Date variable: from String to Numeric with a date format

year=substr(DateOfService,1,4)+0; D=substr(DateOfService,6,5); x=indexc(D,"/")-1; x2=indexc(D,"/")+1; month=substr(D,1,x)+0; day=substr(D,x2,2)+0; s_date=MDY(month,day,year);

FORMAT date date9. ;