Unable to convert MS Access SQL query to SAS Code

[Tom]

What types of values do STARTDATE and LASTDATE contain?

Are they date values so that the difference is in days?

Or are they datetime values so that the difference is in seconds?

[jcis7]

Q1: What types of values do STARTDATE and LASTDATE contain?

A1: Start date I entered programmed into SAS as: startdate= '05-SEP-2017'd; but converts to 21067 in the SAS dataset

lastdate is a SAS date (datetime imported from MS Access (so it looks like in the SAS dataset 18APR2012:00:00:00 at first and then I converted to SAS date using datepart below so it becomes a SAS date) An example of lastdate is: lastdate=19254

Q2: Are they date values so that the difference is in days?

A2: They are in datetime in MS Access but when I imported to SAS, I used datepart to convert it to SAS day in an array called newdates:
do i=1 to dim(date);

newdate(i)=datepart(date(i));

end;

Q3: Or are they datetime values so that the difference is in seconds?

A3: They are in days.