data want;
set SwimMinutes;
array VarArray(*) Mon Tue Wed;
do i=1 to dim(VarArray);
Day=i;
Minutes=Vararray(i);
output;
end;
drop i Mon Tue Wed;
run;
... View more
This occurs because excel stores dates in days from January 1, 1900, while sas stores dates in days from January 1, 1960, so 28/09/2024 is stored as 45563 in excel and 23647 in sas.
... View more
