I have the following data in Excel in a single column:
Times
8:00
8:30
9:00
9:30
10:00
10:30
I import the sheet into SAS as work.test using the ImportWizard, then try
data example;
set test; where Times=36000;
and the data set "example" has no rows. If I try
data example;
set test; where Times=28800;
the data set "example" has 1 row. If I try
data example;
set test; where Times<= 36000;
the data set "example" has
Times
8:00
8:30
9:00
9:30
but not 10:00. If I try
data example;
set test; where Times<= 36000.0000000001;
then 10:00 is included. If I try
data example;
set test; where Times<= 36000.00000000001;
then 10:00 is excluded. Any ideas?
... View more