Hi All, I am using the below code ,when i run this code i am unable to create excel sheet,is it not possible to create excel sheet when we run ODStagsets+tableeditor options,or else do i have to click, export the reults from HTML page and then save it,what if i want to run the code in PC SAS,can anyone of you please help out. this code is taken from http://support.sas.com/resources/papers/proceedings12/146-2012.pdf Actually i have to run all this code on PC SAS,if there is no way in creating excel sheet ,can you please give me some idea's as how it can be achieved. %let home = C:\HoW\Eberhardt-Kong_13173; %let solutionHome = &home.\solutions; %let exerciseHome = &home.\exercises; %let dataHome = &home.\data; %let resultsHome = &home.\results; %let javaHome = C:\\HoW\\Eberhardt-Kong_13173\; %let javaDataHome = &javaHome.\data\; %let javaResultsHome = &javaHome.\results\; /* assign the libraries */ libname data "&dataHome"; options fullstimer source source2; ods tagsets.tableeditor file="&resultsHome\example1.html" options( button_text = "Create PivotTable" auto_excel = "NO" pivotrow="product_line" pivotcol="year" pivotdata="Profit,Quantity,Total_Retail_Price" pivotdata_stats=”Sum,Average,Max” excel_save_file="&JavaResultsHome\example1.xlsx" quit="yes" ); Title1 "Example 1 - Create the First Pivot Table"; proc print data=data.sales; run; ods tagsets.tableeditor close
... View more