As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Dating SAS® and MS Excel

From sasCommunity
Jump to: navigation, search
Erik W. Tilanus

independent consultant

Vinkeveen, the Netherlands

Abstract

Exchanging formatted date and time values between SAS and Excel may appear problematic, since the formats do not always match. Using local language versions of Excel can aggravate the problems. Internally both SAS and Excel use a numeric representation of dates and times. However they differ in anchor point (day 0) and in method. Using the internal structure, problems can be avoided, although a relatively simple transformation is required.

Online materials