A SAS Stored Process Web Application that exports a Dataset to an Excel sheet

While creating Drill down reports, you might need to provide the users with the option of downloading the entire data to an excel sheet. For this you may need to create an interface(Code) where the Export button is displayed and a stored process that converts the Dataset to the excel sheet.



/******Code for Converting the data to excel ******/

data _null_;
rc=stpsrv_header('Content-type','application/vnd.ms-excel');
rc=stpsrv_header('Content-disposition','attachment; filename=temp.xls');
run;
ods tagsets.excelxp file=_webout style=sasweb options(embedded_titles="yes"
embedded_footers="yes"
print_header='&B&CThis is a test'
print_footer='&B&CThis is a footer printed on &D');
title "Export To Excel";
proc print data=&DSN ;
run;
ods tagsets.excelxp close;

customizing the SAS Web applications

1. Changing the banner title of the SAS® Information Delivery Portalhttp://support.sas.com/kb/37/734.html 2. Changing the banner title of the SAS® Logon Managerhttp://support.sas.com/kb/37/606.html 3. Changing banner properties for SAS Web Report Studio.http://support.sas.com/documentation/cdl/en/biwaag/63536/HTML/default/viewer.htm#/documentation/cdl/en/biwaag/63536/HTML/default/a002938529.htmlood at the sections : 1.Hide Banner Properties for SAS Web Report Studio 2.Customize the Product and Browser Window Titles for SAS Web Report Studio For Developing custome themes follow the document:http://support.sas.com/documentation/cdl/en/biwaag/63536/HTML/default/viewer.htm#/documentation/cdl/en/biwaag/63536/HTML/default/a003283566.htm

How to remove the "Show SAS log" button when a Stored process Server executes with errors

http://support.sas.com/kb/16/225.html

An Alternative for Creating a custom HTML input form for a SASStored Process

While Creating any Custom HTML form using the SAS Stored Process web application Instead of the put '< >' statement there is an alternative for writing the HTML to the browser.

Here is the SAS Note.

http://support.sas.com/kb/37/050.html