Help using Base SAS procedures

SAS Addin Excel output - Can I format the excel output coming out of Stored Process?

Reply
Occasional Contributor
Posts: 8

SAS Addin Excel output - Can I format the excel output coming out of Stored Process?

I am using the below code in stored process to generate an excel output as well as html output.

%let _odsstyle=festival;

%STPBEGIN;

filename mycsv catalog "&_TMPCAT..myfile.csv"; ods csv body=mycsv rs=none;

footnote '<a href="' &_REPLAY 'myfile.csv">Open in Spreadsheet </a>';

your code…….

ods csv close;

%STPEND;

Problem : When I access the stp file from excel sas addin, I am getting the output fine with no issues. However I am loosing out on the _odsstyle resolution alike html. Can I add anything extra with

ods csv body=mycsv rs=none; to make the excel output a little bit colorful. May be make the headers bold, put some colors in the background (alike festival option) ?

Any help would be much appreciated.

Many Thanks!

Ask a Question
Discussion stats
  • 0 replies
  • 121 views
  • 0 likes
  • 1 in conversation