The SAS Output Delivery System and reporting techniques

ODS Excel and Pretext and ASIS

Reply
Occasional Contributor
Posts: 17

ODS Excel and Pretext and ASIS

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.

Contributor
Posts: 65

Re: ODS Excel and Pretext and ASIS

[ Edited ]

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!  Smiley Happy

 

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:

 

Use ASIS=ON in ODS Excel.jpg

 

Ask a Question
Discussion stats
  • 1 reply
  • 516 views
  • 0 likes
  • 2 in conversation