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

@Xianyu wrote: 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. Not really. In fact, 1900-01-01 is day 2, and 1899-12-30 is day zero. Excel keeps a simplified algorithm (as copied from Lotus 1-2-3) which thinks 1900 was a leap year, therefore dates before 1900-03-01 are calculated incorrectly there. More modern office software (e.g. LibreOffice) has this corrrected and is therefore able to work with dates prior to 1900. ... View more