comp.soft-sys.sas - The SAS statistics package.
I think it's very weird. And it's very easy to reproduce the problem. SAS 9.2 (32-bit/64-bit) proc export data=whatever_dataset_with_datetime; outfile='path\filename' dmbs=xls replace; sheet='01'; run; Note: the reason I am using "dbms=xls" instead of "dbms=excel" is xls is only option in 64-bit sas. This "XLS" causes the following problem. After you submit it, everything is fine. OPEN the excel and SWITCH two columns, THEN SAVE it. run the same code again but with sheet='02', open the excel file, you will find the date format in sheet02 is LOST. Do you know what's the fix? Thanks
Hi all: I tried to export a SAS dataset to EXCEL and got some error message: 1606 proc export 1607 data=BackDateInfo 1608 outfile="D:\BackDateInfo.XLS" 1609 DBMS=EXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. How do I fix it? I am using Excel Professional Edition 2003. Thanks!
Hello all, We just got SAS 9.1 installed and I was happy to see that PROC EXPORT had a SHEET = option so that we can easily export to a specific sheet in a workbook. With my group, that is only half the battle. Is there a way to export to a specific cell in a workbook without using DDE commands (we are using DDE now)? Our office is using Excel XP and unlike Office 2003 Professional, it does not have the easy XML drag and drop option. Am I missing something obvious or is DDE our only option at this time? Thanks so much Paula Sims XXXX@XXXXX.COM
Hi everybody, Is there a way I can export a dataset to an excel spreadsheet without the column names? Thank you. Jeri