Yes, it is a one time project. I will try fixing the excel ... View more

And in SAS the properties of this variable is    ... View more

proc import datafile="C:\CANCER\MEANADH\BC.xlsx" out=cancer.BC DBMS= xlsx REPLACE; sheet="sheet_1"; getnames=yes; run;   This is how the data looks in excel          DOB 3/21/1965 8/9/1962 6/20/1953 2/4/1962 1/8/1965             ... View more

Hello, This was in excel format and I have imported it into SAS. The original DOB is  However, after using the code the new DOB1 is    ... View more

Here is the log   proc print data=CANCER.bc(obs=10); var dob; format dob mmddyy10.; ERROR: You are trying to use the numeric format MMDDYY with the character variable DOB in data set CANCER.BC. run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

This is how DOB looks like   DATA CANCER.corr_DOS1; SET CANCER.BC; dob1= input (dob, yymmdd6.); format dob1 MMDDYY10.; RUN;   I didn't get any output. It is missing ... View more