Security issues tend to be very site-specific and dependent on both the network environment and security configuration. It is therefore very difficult to offer help without knowing any details of this. My suggestion is you do all SAS installation and configuration inside the secure part of the network. Get a laptop with SAS/EG installed and working again in the high security area. Then take the laptop outside of the secure area to test. That way if it doesn't work it is not a SAS install problem, but to do with moving the laptop out of the secure area. Good luck! ... View more

If you a clicking on a SAS program in Windows Explorer and want to change the default action, go to the Tools, Folder Options in Explorer and select the File Types tab. Select the SAS extension and then change the application with which it is associated. ... View more

Usually the secret to getting Oracle connections working is you need Oracle client software (SQL*Net and SQL Plus)installed on your PC or server. Included in this install is a file called TNSNAMES.ORA that defines all of the Oracle databases you need to access. In most companies this is a standard file for all Oracle users. Message was edited by: SASKiwi ... View more

In your case then you want to run server-based batch jobs. I suggest you ask your server administrator if remote desktop connections are allowed on your server. If they are then you can log onto the server and show a server Windows session just like your desktop. You can then try running a SAS batch job from the command line as already described. If remote desktop connections are not allowed I suspect you have few options left, except asking if you can get x-type commands enabled. Check out this link: http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Enterprise-Guide.html Message was edited by: SASKiwi Message was edited by: SASKiwi ... View more

In my experience SAS batch jobs work best if your SAS job is just a text file of SAS code. You can export your EG projects to code text files, then you could use the Windows scheduler (check out the Control Panel) to run the SAS job. The trick is to define a command line like: sas -sysin "\mydir\mysasprogram.sas". Separate OUTPUT and LOG files are produced automatically. ... View more

Apart from the SAS Add-in the only other option I can think of is to get SAS to export the data out as a CSV (comma-delimited) file and then use Excel's data import functionality to read the data into a blank worksheet. From this worksheet you can use VLOOKUP Excel formulas to pick up the correct data and put it in the correct cell in your existing reports. If you want to explore the SAS Add-in option, suggest you search SAS support for relevant user papers. Either way this is probably going to be a fairly manual solution....good luck! ... View more

If you are connecting to the SAS spawner on Unix the only statements you need are: %let server=DC3C89.QC.DELL.TX 8562; options comamid=TCP remote=server; signon user=your_user password=XXXXXXXX; As Florent says no RLINK filename is necessary. Also you can probably drop the COMAMID= as well as TCP is usually the default. ... View more

Have you tried the MMSS. format that displays SAS times in minutes and seconds? ... View more

Do you have SAS/ACCESS to PC File Formats licensed on your EG Server? Without that your options would be probably limited to MS Excel Add-in. ODS can export to Excel but it builds XML spreadsheets for scratch each time, so unless you are prepared to change your layout to suit ODS this is probably not an option. ... View more

Such functionality is specific to the email software you use. For example when you MANUALLY send a Microsoft Outlook email you can set the message options to request a delivery and/or read receipt. As far as I am aware you cannot set these options from within the SAS email interface, but you can configure Outlook to request delivery and/or read receipts for ALL email sent. This means when you send email via SAS through this Outlook mailbox you would automatically get delivery/read receipts. The bottom line is check the features of your email client. ... View more

Suggest you check out the CATALOG procedure and the COPY statement that allows you to create a copy of your BUILD catalog. With the NOSOURCE and NOEDIT options you can create a copy that doesn't contain SCL source and won't allow editing but will still contain your compiled code. ... View more

I am pretty sure the guessingrows option doesn't work with EXCEL imports, but the save to CSV is a good choice as guessingrows works with that. Another way is to use a LIBNAME with the EXCEL option and then use DBSASTYPE to control the SAS column definitions. A quick and dirty approach is to put a single quote into the first blank row of the columns in the spreadsheet you wish to be treated as character. ... View more

The simple answer is yes. My recollection is that the editor, log, output and explorer areas appear in separate X-windows within one X-windows container so you can place and size each window separately on the screen. I suggest you check out the SAS Companion for Linux documentation for more details. Message was edited by: SASKiwi ... View more

Sorry, I missed out the renaming of the variables on the second SET statement: set inputdata (rename = (F1 - F200 = G1 - G200)) point = record nobs = obsnum; This is needed so you can compare values between the different rows without overwriting and to populate the VARS2 array correctly so the exact matches can be counted. ... View more