Japan has a superfast train called the Shinkansen. The first I heard of it was when my sister visited Japan on a scholarship. Engine-awestruck, we wanted a ride, but weren’t able to get to Japan. Nor, did we know the language. (With over 5000 kanjis, it took my sister 3
Tag: excel
How SAS engines can read a range of data in Excel
Export to Excel 2007/2010 using SAS Enterprise Guide
Since its 4.2 release, SAS Enterprise Guide has been able to import Microsoft Excel 2007 and 2010 spreadsheet files (usually encountered as .XLSX files). But while SAS Enterprise Guide can export XLS files (which are compatible with all versions of Microsoft Excel), it does not have the ability to export
In the year 9999...
...if man is still alive, will he be importing Excel spreadsheets and wondering why his leap years are off? I received this report from SAS Technical Support, on behalf of a customer who uses SAS Enterprise Guide to import spreadsheet data: The date "12/31/9999" will import as "02Jan****" when reading