Hi,   I used to be able to run the PROC EXPORT code below without any issues but now SAS gives me an error. I suspect it is because IT just installed a maintenance release. Do you think it is the reason and is there an option to avoid this error?   proc export data=final outfile="\\fileshare\users\rm\example5.xlsx" dbms=xlsx replace ; sheet="Data_import"; run;     I Get the error message: Can not replace sheet because it has existing formulas that reference other pages ERROR: Export unsuccessful. See SAS Log for details. ... View more

Hi, We have SAS installed on a server and we use enterprise guide to connect to SAS. In the past 2 years, we had several occurrences where all the files in SASapp are suddenly deleted. It is a random event and we haven't been able to figure out why these files sometimes disappear. Our temporary solution is to have a a copy of the SASapp folder and when it disappears we just paste the files from the backup. However, we would like to understand how this thing happen. There is no real time effect. It happened 2 times last weeks on different day and times. it also happened 6 months ago and several times before. Multiple users are using EG to connect to the SAS server and they don't have the right to modify the files in SASapp. Our workspaces are on a dedicated drive. We also noticed that sometimes files and folders are written in SASapp. It is very strange and we haven't been able to identify any reasons or any way to troubleshoot it. Do you have any clues of what is going on on our server? Regards ... View more

Hi, I am trying to have a stored process write to the browser some javascript function before generating an Excel file using excelXP tagset. It seems to work on chrome but I get an issue  with IE. The stored process basically write my first data step to the beginning of the excel file. I  don't understand why because I redirect the code to Excel only after my first data step. /* First data step to write to the browser*/   data _null_;   file _webout;    put "<script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js'></script>";   put"<script type='text/javascript'>";   put"function detectIE() {";       put"var ua = window.navigator.userAgent;";       put"var msie = ua.indexOf('MSIE ');";       put"var trident = ua.indexOf('Trident/');";       put"if (msie > 0) {";           put" // IE 10 or older => return version number";           put"return parseInt(ua.substring(msie + 5, ua.indexOf('.', msie)), 10);";       put"}";       put"else if (trident > 0) {";           put"// IE 11 (or newer) => return version number";           put"var rv = ua.indexOf('rv:');";           put"return parseInt(ua.substring(rv + 3, ua.indexOf('.', rv)), 10);";       put"}";   put"else {";   put"window.stop();";   put"document.execCommand('Stop');";   put"alert('Please use Internet Explorer');";   put"newWindow = window.open('', '_self', '');";     put"window.close(newWindow);";   put" // other browser";       put"return false;";   put"}";   put"}";   put"window.onpaint = detectIE();";   put '</script>'; run; /* Then I redirect the Excel for the Excelxp tagset*/ %let RV=%sysfunc(stpsrv_header(Content-type,application/vnd.ms-excel)); %let RV=%sysfunc(stpsrv_header(Content-disposition,attachment; filename= Histostaffperformance.xml));  ODS listing close; ODS noresults;  ODS tagsets.ExcelXP     file=_webout   STYLE=SRReportStyle_custom2         options     (Embedded_titles = 'yes'                          Embedded_Footnotes   = 'yes'                    sheet_name= 'Histo_performance'                    autofilter= 'yes'                    frozen_headers= '3'                    autofit_height= 'yes'     absolute_column_width= '20,20,15,30,13'                    ); TITLE1 j=l color=cxF8971D h=14pt bold "Histology - Staff Performance"; PROC REPORT DATA=all NOWD style(Header)=[just=center ]; COLUMN  taskdate histotech testtype steps count; DEFINE Taskdate  /CENTER 'Date'  ; DEFINE histotech /CENTER "Histotech"   ;   DEFINE testtype /CENTER "Test Type"   ;   DEFINE steps /CENTER "Step"   ;   DEFINE count /CENTER "# cases"   ;   run; RUN; ods tagsets.excelxp close;   ods listing; ... View more

Hi, I am working on a simple web application for my customers to let them run some stored processes. The layout is very simple, I have a left DIV which is a menu to select the stored process and a right DIV to display the form and the output of the stored process. I am able to create some custom input forms in HTML and use ajax and serialize() to read the data and generate the output in the corresponding DIV. it works great but I need to develop the HTML code for the form. Now I am trying to do something similar but instead of developing HTML code for the input, I want to use the prompt features from EG. I added the prompt and I am able to run the stored process when I enter the URL in IE: http://myserver.com:8080/SASStoredProcess/do?_action=form,properties,execute,nobanner,newwindow&_program=%2FUser+Folders%2From%2FMy+Folder%2Fsecgdna However, when I try to use my web page (with the menu in left DIV and output/input in right DIV), I get an error in IE. What is driving me crazy is that it is working fine in firefox or chrome ( I have to use IE for this project).   <script> $(document).ready(function() {     $("#container").load("http://myserver:8080/SASStoredProcess/do?_action=form,properties,execute,nobanner,newwindow&_program=%2FUser+Folders%2From%2FMy+Folder%2Fsecgdna");         });   </script> <body> <div id="menu" > <b >item1</b><br> </div> <div id="container" style="margin-left: 230px; width: 100%; height:100%; "> </div> </body> </html> The page load without any issusde and I see the prompt created in EG. But when I click on RUN,  I get the following error : Line: 526546630 Error: Object doesn't support this property or method ... View more

Hi, I am trying to generate some barchat using GTL but I have a problem with the bar width and I am not sure to understand why. When I add the barlabel=true option, the bar are very narrowed. but if I remove this option it looks much better. Do you kwnow why this label option modify the bar widht? Here is the code I use: proc template;   define statgraph testgraph;   begingraph;   layout gridded / border=false;     layout datalattice columnvar=path  / headerlabeldisplay=value HEADERLABELATTRS=(SIZE=6px) cellwidthmin=20              columnheaders=bottom border=false columndatarange=union             columnaxisopts=(TICKVALUEATTRS=(SIZE=6pt) display=(line TICKS tickvalues))             rowaxisopts=(offsetmin=0              label='% Subjects' griddisplay=on);       layout prototype  / walldisplay=(fill) WALLCOLOR=white;;         barchart x=quarter y=colj / skin=modern barlabel=true BARLABELATTRS=(SIZE=6pt);                                      endlayout;     endlayout;   endlayout;   endgraph; end; run; ods graphics on / reset=all height=800px width=1000px   antialias=on;   proc sgrender data=test template=testgraph; run; ods graphics off Plot without barlabel option: Plot with barlabel option: ... View more

Hi, I am trying ot learn more about WIK but I am getting confused with all the informaiton I found online. We develop many reports and we would like to be able to have a GUI where users could enter some parameters and run SAS program. Right now we have a solution using web method but it is not very flexible. my idea is to go with stored process and then use the WIK for hte interface. We are currently using EG 5.1 on server and we have integration technologies module. Do we need anything else for the WIK? Is WIK part of the SAS integration technologie module or do we need to pruchase something? I am jsut trying to understand to proporse a solution to my manager. Regards ... View more

Hi, I am testing some code developed on PC SAS on our new EG server and I noticed that some procedures are very slow on EG. I am running this simple code below:   ods output ParameterEstimates=_LinEst;     ods listing close;     proc glm data=_LinearData;    model Log2Fam = reg_cycle / Solution;    by Plate WellID;     run;     quit;  It takes 15 seconds on PC SAS but more than 11 minutes on EG server. The input data set has more than 100000 row. Is it slow on EG because SAS need to send a lot of information from the server to the client with the ods output? How can make this procedure faster on EG ? Thanks ... View more

Hi, I am trying to import an excel file using libname on EG. It works fine, I can connect to the file and the using a data step I can just create a table. However, it creates SAS data sets with columns names that do not comply to SAS naming conventions. I get columns with names like 'sample ID 1'. How am I suppose to use these variable names in a SAS code? I am currently moving from display manager to EG and I am not how to solve this issue. thanks for your help Romain ... View more