Hi all, I'm currently converting SAS programs to EG projects so that we can move a group of non-programming analysts to solely EG ie remove Base SAS completely. I've had someone tell me the process I'm using wont work if Base SAS is removed; they are telling me that EG is utilising the Base SAS engine. Here is how I've set things up - can someone please let me know if this will work? Main processing of code occurs on remote server I've set up a local server under SAS Enterprise Guide Explorer ie I ticked the 'Automatically add local SAS server (if installed) to server list' I use the 'Download data files to PC' task to download the final datasets I have code that runs on the local server that outputs the file to the users c: drive ie outputs Excel spreadsheets I notice that SAS.exe turns up in Widows Task Manager when I hit local so I suspect that this may not work if Base SAS is removed but can someone please confirm? The reason I want it processed locally is I have a VB script that converts the XML files to native Excel and then deletes the XML file. I dont have access to a PC with just EG unfortunately to test. Many thanks in advance Steve ... View more

Hi all, I am trying to produce a Sgplot graph using an example I found on the SAS website as a guide. Whenever I run it with my data or run the example given I get dashed lines around the bars. It does the first one with a solid border but subsequent ones are dashed. I'm outputting to PDF and I've tried upping the dpi to no avail. I found a post stating that SAS 9.3 can use vector graphics but couldn't find where to tell SAS to do so. Here is the code and a screen dump of the result. Does anyone have a fix for this? data trt;    input PatientID $ Start_date :date9. End_date :date9. Treatment;    format Start_date End_date date9.;    datalines; A   05Jan2011  31Mar2011  1 A   01May2011  01Sep2011  2 B   01Feb2011  31Aug2011  3 C   15Jun2011  15Oct2011  1 D   15Jan2011  15Mar2011  1 D   01May2011  15Sep2011  2 D   01Oct2011  15Dec2011  3 E   01Apr2011  15Nov2011  1 ; run;     ods pdf file = "&dir\Test.pdf" notoc ;         title1 "Treatment Time Line by Patient";         proc sgplot data=trt;            highlow y=PatientID low=start_date high=end_date /                    group=Treatment                    type=bar                    barwidth=0.1;            yaxis label="Patient ID" reverse;            xaxis label="Study Time";         run;     ods pdf close ; Screen Dump: I've tried using different styles as well as various graphic options but still get the same result. cheers Steve ... View more

Hi all, I've been tasked with moving a group of analysts over to EG to save money on Base SAS licenses. What I've been doing is taking SAS programs and converting them to use in EG. What I'm finding is that if EG is asked to create a large number of XML files via the ExcelXP tagset it crashes. Sometimes it just freezes during a proc report other times I get a SAS.exe has stopped working. I've tried a number of approaches and nothing so far has worked. What I've tried is: Adding NOSOURCE and NONOTES to options Adding ODS NORESULTS Not opening my Base SAS which uses RSASUSER before running the program Does anyone have any other suggestions that I could try? The same code works without any issue whatsoever in Base SAS. Very frustrating! cheers Steve ... View more