Installing SAS 9 3 Raymond R Balise Health

Installing SAS 9. 3 Raymond R. Balise Health Research and Policy

If you are upgrading from an early SAS • As with any install on Windows, be sure to back-up your machine before you install software. • I use the Windows control panel to remove all SAS programs before I upgrade. This gets rid of all the old programs that SAS provided but keeps my work intact. After uninstalling everything I reboot. After rebooting I find the SAS folder in the Programs Folder and delete it and then reboot again. You should not have saved into that folder but if you saved your work there obviously you want to move it before deleting the folder. • This process takes a while and in theory is not necessary but it helps to assure that you have a completely clean install of SAS.

JAVA • SAS will want to use JAVA. Get it here: java. com/en/. If you think that you have the latest version (6 Update 27), you can use the Do I have Java? hyperlink on the page to double-check.

Installing SAS • The next slides show you how to check what version of Windows you are running. Keep in mind that SAS only works correctly on Windows Professional or better versions of XP, Vista or 7. All Home editions of Windows will have problems running SAS. • Use the following notes to check to see if you are running 32 bit or 64 bit Windows and then download the correct version of SAS 9. 3.

Which Windows in Windows 7 OS? Go to Start Button > Control Panels look at System: This is the Professional not Home edition of Windows 7 Look here to see 32 bit vs. 64 bit

Which Windows for Vista Go to Start Button > Control Panels look at System:

Which Windows in Windows XP Go to Start Button > Control Panels look at System: 32 bit 64 bit

Order SAS • You can order 32 or 64 bit SAS here: itservices. stanford. edu/service/softwarelic/sas

Make a folder to store the SAS installer • Below you see how to make a folder called archive on your c: drive with Windows 7. Double click Computer on the desktop then: 2 3 When the new folder appears type archive. 1 Mac users, if you don’t know how to make a folder on your c: drive please ask for help if you have any questions.

How to make a folder with Windows Vista 2 3 Double click My computer on the desktop then… 1. Click on your c drive. 4

How to make a folder with Windows XP 1. Double click My Computer 2. Double click Local Disk C: 3 b. If the Make a new folder task and hyperlink are missing click this. 3 a. Click Make a new folder. 4. Name the folder archive.

After paying • You will get two emails. The second will have the link to download: https: //someplace. real. not. here. com/ The download can take HOURS off campus. Use a wired connection on campus if you can. Click the real address

Save the download tool to the archive folder:

Double click the Computer icon on your desktop and use the left windowpane to browse to the c: archive folder then… … double click this. This program is a downloading tool. It will get you the SAS software depot and start the installer.

1. Click browse 3. After it displays the path c: archive click Start Download 2. Click the archive folder then OK

On campus with a wired connection the download takes about 45 minutes. Off campus it may take many hours. Start the download and go out to dinner…

Using the SAS Installer Depot After the download you have the SAS install depot saved on your box. Installing can take less than 5 minutes or over an hour depending on your machine.

The archive folder will have the full SAS installer Depot. You do not need to download again. The following slides show you how to install. If you forget to install part of SAS double-click the setup program to add parts later.

1 2

If you have Office 2007 or 2010. Check “on” the boxes shown in this and the following 2 slides before pushing next. Some will not be checked by default so check carefully.

If you must run 32 bit Office on a 64 bit machine add this also. See slide 49.

This choked one of my machines that has Adobe Acrobat Professional installed. Skip this check if you have it installed

1 2

Quit Power. Point before you push Start. (Go to lunch. )

Your choice on if to send them your hardware info.

The archive folder will have more than 8 Gig of data. Keep if until you are certain that you have everything you need. Then delete if you need room.

After Installing • The next slides give advice on what to do after installing SAS. – Patch your software – Set your windows so it will show file suffixes. – If you use Microsoft Office set it to show you file paths.

Getting Patches • Remember where you save the patch files. • Visit this site to download SAS Enterprise Guide patches: ftp: //ftp. sas. com/techsup/download/hotfix/HF 2/E 66. html – Download the big EG patch is E 66014. – This is the same patch for 32 and 64 bit windows. • All SAS patches for 9. 3 are here: ftp: //ftp. sas. com/techsup/download/hotfix/HF 2/93_all_hosts. html – If you are running 64 bit SAS get the Windows for x 64 versions, otherwise just get the Windows files.

Installing patches • After downloading patches. Start the SAS deployment Wizard: Click this.

Browse to the folder where you saved the downloads. After patching with E 66014 You can check to see if you are patched here.

Stay up to Date • Ask SAS to email you when they have patched stuff: support. sas. com/techsup/news/tsnews. html

Can You Recognize File Types? • Windows adds a period and a suffix to the names of files to indicate what program uses the file. By default, the suffix is hidden. Fix that and you will be sure to import the right file. No suffix shown.

Viewing File Types in Windows • Tell Windows 7 to show you the file suffixes: – From the Start button click on the Control Panel 1. Type: file type 2. Click 3. Uncheck

2 1 4 Follow these steps to show file extensions (suffixes) in Vista. 3. Uncheck 5

Show File Extensions (Suffixes) in XP 2 1 4 3. Uncheck 5

The Path Says Where Files are Found When you want to find a file to analyze on your PC, you need to know the path. Click here… … and the path is shown as: C: ProjectsTalksR 4 Clinicians

Click to return to installer slide. 32 bit vs 64 bit Excel • Office 2010 can run in 32 bit and native 64 bit mode on a machine running 64 bit Windows 7. • 64 bit SAS and 32 bit Office do not integrate. • By default Office will install the 32 bit version. • With 32 bit office you need to tweak SAS to get it to load Excel files or run 64 bit Office instead.

Installing 64 bit Office • If you do not use Add-ons to office (like the SAM and PAM for microarray analysis plug ins) then you can install and run the 64 bit version of Excel. – If needed uninstall the 32 bit version of Office 2010. – Find the x 64 folder on the Office DVD and run the setup program.

Click to return to installer slide. If you must use 32 bit Office • If you must use 32 bit office on a 64 bit machine send a help request to SAS and they will send you advice on how to use the PC Files Server to access Excel files: support. sas. com/ctx/supportform/create. Form

If you plan to use Excel With XP, click the Windows Start menu and choose Run In the dialog type regedit and click ok. With Vista or Windows 7 search for and open regedit. 1. Open up the tree to this path HKEY_LOCAL_MACHINE ► SOFTWARE ► Microsoft ► Jet ► 4. 0 ► Engines ► Excel 2. Double click Type. Guess. Rows. 3. Type 0, that is zero not the letter o, in the DWORD editor and click ok. 4. If you can find them, repeat for these paths HKEY_LOCAL_MACHINE ► Software ► Microsoft ► Office ► 12. 0 ► Access Connectivity Engine ► Engines ► Excel HKEY_LOCAL_MACHINE ► Software ► Microsoft ► Office ► 14. 0 ► Access Connectivity Engine ► Engines ► Excel HKEY_LOCAL_MACHINE ► Software ► Wow 6432 Node ► Microsoft ► Office ► 12. 0 ► Access Connectivity Engine ► Engines ► Excel • Microsoft ACCESS will silently change this setting! – So watch this setting if you use ACCESS.

Using File Paths You can use Windows Explorer to find your files or you can add a button to MS Office products to show the path with a single click. With Office 2007 or 2010 it is easy to add a button, which will show up here, to show you the path when it is pushed.

Here’s how to add that button: 3 5 2 1 4 6

Once you have the button, push it to get the path to show here. The full path includes the path to the folder and the file name with the suffix using backslashes: C: ProjectsTalksR 4 CliniciansMarriage. Dev 20072009. xls