If you want PROC IMPORT to have an option to import all fields as character, please vote: PROC IMPORT -- all fields as character ... View more

The best response ever!!! ... View more

I would then suggest that you need to re-think your approach.  Excel is not a <insert whatever task you can think of> tool.  Whilst you could do this, i.e. have a base Excel file, then each day you export your SAS data to CSV, and that base Excel file opens the CSV data and posts it into the base file (using VBA), I can't recommend this approach.  Excel is limited in many ways, one being the number of tabs which you will hit pretty quickly.  Secondly will anyone actually ever look at the data.  This is my biggest gripe.  So much data gets dumped into Excel which no-one ever looks at.  Is this for data transfer purposes, i.e. will someone else have to import and work with the data, then use a proper data transfer format (CSV, XML etc.).  If this is a report, do people really want to see thousands of rows of data on numerous sheets, I personally wouldn't look at it.  Consider summarising, grouping, graphing, or somehow reflecting the data in a easy to read format, then people might take notice of it.  If its just a dump, then proc report it to a PDF file and be done with it.  You will note that for the three options, Excel is not mentioned... ... View more

Hi: I think that the images are disabled temporarily because of the spamming issue that was happening. cynthia ... View more

Try '01jan1960:00:00:00'dt - '31dec1899:00:00:00'dt 31dec1899 as Excel incorrectly views 1900 as a leapyear. ... View more

Indeed, you are correct. Unfortunately, it does not like the ods "style" that I've applied.  Users will just have to put up with the warning message. ... View more

Looks similar to this much older problem: 18720 - CIMPORT may generate floating point overflow errors importing amainframe file on the PC Do you have SAS/CONNECT available as a workaround? ... View more

HI, Bill:   Here's something to get you started and a little "light" reading on the topic of PROC REPORT. http://support.sas.com/resources/papers/proceedings13/366-2013.pdf http://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf Cynthia        proc format; value $ctry 'GERMANY'='yellow'              other='white'; run;      ods html file='c:\temp\report_bands.html' style=sasweb; ods tagsets.excelxp file='c:\temp\report_bands.xml' style=sasweb; ods msoffice2k file='c:\temp\report_bands.xls' style=sasweb; proc report data=sashelp.prdsale nowd; where prodtype in ('FURNITURE', 'OFFICE'); title '1a) Using PROC REPORT';   column country rowcolor division prodtype,(actual actual=summax);   define country / group;   define rowcolor / computed /* noprint */;   define division / group;   define prodtype / across;   define actual / sum 'Sum';   define summax / max 'Max' style(column)={foreground=green font_weight=bold};   break before country / ;   compute country;     length holdctry $10;     if upcase(_break_) = 'COUNTRY' then        holdctry = country;   endcomp;   compute rowcolor / character length=100;     stylestr = catt('style={background=',put(holdctry,$ctry.),'}');     rowcolor = stylestr;     call define (_row_,'style',stylestr);   endcomp; run;       proc report data=sashelp.prdsale nowd; where prodtype in ('FURNITURE', 'OFFICE'); title '1b) Using PROC REPORT';   column country rowcolor division prodtype,(actual actual=summax);   define country / group;   define rowcolor / computed   noprint  ;   define division / group;   define prodtype / across;   define actual / sum 'Sum';   define summax / max 'Max' style(column)={foreground=green font_weight=bold};   break before country / ;   compute country;     length holdctry $10;     if upcase(_break_) = 'COUNTRY' then        holdctry = country;   endcomp;   compute rowcolor / character length=100;     stylestr = catt('style={background=',put(holdctry,$ctry.),'}');     rowcolor = stylestr;     call define (_row_,'style',stylestr);   endcomp; run; ods _all_ close; ... View more