Generally, PROC IMPORT is preferred while importing date from excel to SAS. dt1=22025 dt2=22025 ERROR =0 N =1 Importing dates from Excel to SAS

The log below with the date value in a numeric format: the number of days since January 1, 1960. The quotes are necessary, as well as the letter ‘d’. You can create SAS date constants using the form.’ ddmmmyy'd or 'ddmmmyyyy'd. Īnother method is to use the correct width of the informat according to the raw data. This way, you can tell SAS explicitly which column and variable should begin.

The first solution is to use formatted input with a column pointer. You have identified a mismatch in the date informat and the column’s width you can fix this in two ways. This is because only two digits are specified for the year part in dt1 variable. The dt2 variable expects the date to begin from column 12 but begins from column 9. The above illustration shows a mismatch between the width of the column specified by the informat variable dt1 and the actual date value. That means the width of the date informat for the dt1 variable is ten, and the monyy format specifies the format width of 5. Therefore, if you examine the actual column shown in the rule, you will see a mismatch where SAS is expecting a date in the format of mmddyy10. The date format is correct, but the raw data value is eight digits wide instead of 10. The first step in investigating these errors is to check whether you have used the correct date format to read the date values.įor example, if the date informat used is mmddyy10. and the data value given is in the format of ddmmyy10.

Sas date formats