ODS Excel and Pretext and ASIS

CurtisER — Tue, 10 May 2016 17:50:23 GMT

In 9.4M3, ODS EXCEL is new.

Previously, ODS Tagsets.ExcelXP has been the mainstay for generating Excel spreadsheet. I would like to refer to SAS KB #44126 "ASIS=ON does not maintain leading or trailing blanks in the output generated by the ExcelXP tagset".

It appears that ODS EXCEL still does not honor ASIS=ON or PRETEXT options in the CALL DEFINE statement. If so, I would have to continue to use Tagsets.ExcelXP? Thanks.

Re: ODS Excel and Pretext and ASIS

SuzanneDorinski — Sat, 21 May 2016 21:42:09 GMT

I used the code from that SAS Knowledge Base note you referenced. The note suggests a workaround using the MSOffice2K tagset. I ran that PROC REPORT code using the ODS Excel destination in SAS University Edition, and it works!

This is the code I tried:


%let path=/folders/myfolders/ODS Excel examples;

ODS EXCEL FILE="&path/Use ASIS=ON.xlsx";
 
proc report data=sashelp.cars nowd;  
   col origin cylinders mpg_highway mpg_city;
   define origin        / group;
   define cylinders     / group;
   define mpg_highway   / mean format=4.; 
   define mpg_city      / mean format=4.;  
                            
   compute origin;    
      if origin ne "Europe" then do; 
         call define(_col_,"style","style={pretext='   ' asis=on}"); 
      end; 
   endcomp; 
run;

ODS EXCEL CLOSE;

And this is the output:

topic Re: ODS Excel and Pretext and ASIS in ODS and Base Reporting

ODS Excel and Pretext and ASIS

Re: ODS Excel and Pretext and ASIS