topic Using proc report in SAS Store Procedure in Developers

Using proc report in SAS Store Procedure

rodrichiez — Mon, 16 Jul 2018 20:09:18 GMT

Hello,

I've created a SP with a proc report definition to format the final result, but when I run the SP from SAS Ad-In for Office in Excel, the result is displayed with no format at all, I tried the macro below but it doesn't worked:

%MACRO setopt;
%if %upcase (&_odsdest) = RTF %then %do;
%let _odsstyle=rtf;
%let _odsstylesheet=;
%let _odsoptions=bodytitle startpage=no
nokeepn notoc_data;
%end;
%else %if %upcase (&_odsdest)= PDF %then %do;
%let _odsstyle=printer;
%let _odsstylesheet=;
%let _odsoptions=bookmarkgen=no compress=9 startpage=no;
%end;
%else %if %upcase (&_odsdest)= HTML %then %do;
%let _odsstyle=sasweb;
%let _odsstylesheet=;
%let _odsoptions= rs=none;
%end;
%else %if %upcase (&_odsdest)=TAGSETS.SASREPORT11 %then %do;
%let _odsstyle=normal;
%let _odsstylesheet=;
%let _odsoptions=;
%end;

PROC REPORT DATA=WORK.QUERY_FOR_FACT_CSAC_BK_0000 nowd headskip
style(header)= [cellheight=.20in font_weight=bold foreground=white background=darkblue]
style(lines)= [background=cxCDE6F4 cellheight=.10in bordercolor=black]
style(column)= [background=lightgrey foreground=blue];

What can I do?

Re: Using proc report in SAS Store Procedure

pau13rown — Mon, 16 Jul 2018 20:53:32 GMT

is there a particular variable that doesn't appear formatted? don't you need some define statements? there you can specify the format

Re: Using proc report in SAS Store Procedure

rodrichiez — Tue, 17 Jul 2018 13:42:15 GMT

None of the variable appear formatted, I put define statements and even so when I run the SP from the SAS Add In in Excel the result is unformatted.

Re: Using proc report in SAS Store Procedure

rodrichiez — Mon, 23 Jul 2018 16:22:05 GMT

Update:

Solution:

In SAS Add-In Properties, click on Results tab and select HTML as Format.