A Quick Recommendation on SAS Setup at UT by Fridtjof Thomas

|

This is a quick guide on the recommended SAS setup for UT users. This is excerpted from a longer guide on software setup and windows 10.

SAS 9.4 TSIM3

Large (16GB) download from UT Knoxville

This download will take several hours due to its size (zipped file 16GB).  You may want to ask the Biostatistics Division (Tristan Hayes) for a local copy of the file.  You will still need to download the license file from UT Knoxville (same link as given above, but a small, less than 1MB download).

Make sure to include these modules in your SAS installation:

  • SAS PC File Server (needed to read 32-bit Excel files into a 64-bit SAS installation)
  • SAS Power and Sample Size – PSS (if you intend to use this module at all).

 

Check which MS Excel version you have and whether you will need the SAS PC File Server:

Open Excel | File > Account | About Excel

Mine reads 32-bit Excel (12/31/18) – I need the SAS PC File Server to correctly import 32-bit Excel files into 64-bit SAS data sets.  The following example is taken from http://support.sas.com/kb/43/802.html to show how to use the SAS PC File Server to import and export data from 32-bit Excel:

PROC IMPORT OUT=yoursasdata
DATAFILE='drive:\yourdirectory\yourfile.xls'
DBMS=  EXCELCS  REPLACE;
SHEET='yoursheet';
RUN;

PROC EXPORT OUTFILE='drive:\yourdirectory\yourfile.xls'
DATA=yoursasdata
DBMS=   EXCELCS  REPLACE;
SHEET='yoursheet';
RUN;