EG creating dynamic prompts with excluded values

SAS Addin Software requirements

SAS Addin 5.1

Link

Platform
Microsoft Windows 400 MB\2 GB
Microsoft Windows for x64  400 MB\2 GB
Supported Operating Systems
SAS Add-In for Microsoft Office is supported on the following platforms:
• Microsoft Windows XP Professional with Service Pack 3
• Microsoft Vista with Service Pack 1
• Microsoft Windows Server 2003 with Service Pack 2
• Microsoft Windows Server 2008
• Microsoft Windows Server 2008 R2
• Microsoft Windows 7
For the best user experience, we recommend one of the following platforms:
• Microsoft Windows Server 2008
• Microsoft Windows Server 2008 R2
• Microsoft Windows 7
Additional Software Requirements
One of the following versions of Microsoft Office is required:
• Microsoft Office 2007
• Microsoft Office 2010 (32-bit or 64-bit)
The SAS Add-In for Microsoft Office is now available as either a 32-bit or a 64-bit application. If you are using 32-bit Microsoft Office, you must use the 32-bit version of the SAS Add-In for Microsoft Office. If you are using 64-bit Microsoft Office, you must use the 64-bit version of SAS Add-In for Microsoft Office.

SAS Addin 4.3

Link

Software Requirements

platforms:

• Microsoft Windows XP Professional updated with Service Pack 3 or later (both 32‐bit and

x64‐bit versions)

• Microsoft Windows Vista ‐ Business, Enterprise, and Ultimate Editions (both 32‐bit and

x64‐bit versions)

• Microsoft Windows 7 ‐ all versions

• Microsoft Windows Server 2003 (both 32‐bit and x64‐bit versions)

• Microsoft Windows Server 2008 (both 32‐bit and x64‐bit versions)

Additional Software Requirements

One of the following Microsoft Office installs:

• Microsoft Office 2010 (32‐bit version only)

• Microsoft Office 2007

• Microsoft Office 2003

System Requirements Wizard

The System Requirements Wizard is used to ensure that a computer onto which you would like to

install SAS Add‐In for Microsoft Office software meets the minimum system software requirements.

Space requirements will vary depending upon the third‐party components and the individual files on

your computer that need to be updated.

The System Requirements Wizard will inform you of the components that do not meet the minimum

system requirements before updating them. The System Requirements Wizard will install these

components if you do not already have them installed on your system:

• Microsoft Runtime Components 8.0 SP1

• Microsoft Runtime Components 9.0 SP1

• Microsoft .NET Framework 3.5 SP1

• Microsoft Web Services Enhancements 3.0

• Microsoft Visual Studio Tools for Office 2.0

• Microsoft Visual Studio Tools for Office 3.0

• Microsoft Visual Studio Tools for Office 3.0 SP1

SAS

_____________________________________________________________________

Dan Strickland

Inland Fisheries Division

Texas Parks and Wildlife

3407-A S.Chadbourne Street

San Angelo, TX  76903

Phone:  512-666-4546

DanwStrickland@gmail.com

Learn how you can help Texas State Parks

How to determine if a process has a lock on a file

Link

Received this SAS error:
ERROR: A lock is not available for ******.********.DATA.

Introduction

Sometimes, you try to delete a file and receive access violation or file in use - errors. To successfully delete a file, you will need to identify the process which has locked the file. You need to exit the process first and then delete the particular file. To know which process has locked a file, you may use one of the methods discussed in this article.

Using Process Explorer

Process Explorer shows you information about which handles and DLLs processes have opened or loaded.

• Download Process Explorer from Microsoft site and run the program.
• Click the Find menu, and choose Find Handle or DLL...
• Type the file name (name of the file which is locked by some process.)
• After typing the search phrase, click the Search button

You should see the list of applications which are accessing the file. Here is a screenshot:

Note: There is also a command-line tool named Handle from Windows Sysinternalsthat can display open handles for any process in the system.