Host Systems

Section Chair:
George Matthews

University of Georgia

Athens, GA

Installation Issues with the SAS System and Netware 4

Gerri Furlow, North Carolina State University, Raleigh, NC

Integrating the SAS System efficiently and effectively in a networked environment is a task that the SAS Software consultant is faced with for each new release of the SAS System. There are configuration issues that must be addressed for the fileserver and the client stations for the integration to work smoothly. This paper will focus on the network installation of the SAS System for Microsoft Windows Release 6.12 . Particular emphasis will be placed on the integration of the SAS System within a Novell Netware Version 4 environment.

Gerri Furlow is a Computing Consultant for the Computing Services Division of the Office of Information Technology at North Carolina State University. Her primary duties center around the technical support of SAS, SPSS, and the Microsoft and WordPerfect applications for faculty, staff, and students at NCSU. She has been using SAS for about 10 years.

Storage Strategies for Data, Formats, Catalogs and Other Information in Application Development Using The SAS System

Sharon Hixon-Mosley and Ray L Ransom, Centers for Disease Control and Prevention (CDC), Atlanta, GA

When doing cross-platform development using the SAS System, developers have many options for the storage and access of information needed by their applications. Using SAS/SHARE and SAS/ACCESS one can use alternative means of storage to the SCL lists commonly used by SAS/SCL developers. These alternative means of storage can provide power and flexibility through maintenance improvements, increased query speeds for large tables, central storage of data, efficient use of RAM and the power of the SQL language. Developers of a sexually transmitted disease (STD) information system at the Centers for Disease Control and Prevention(CDC) tried storing information in several standard and alternative structures recognizing benefits and short-comings of each approach. This paper will provide a brief description of storage options and compare performance with various SAS/AF FRAME classes and specific objects. An overview of storage solutions selected for CDC’s STDINFO application will be demonstrated. This information will assist other developers working in the UNIX, Windows 3.1, Windows NT, Window NT SQL Server and Windows 95 environments as all of these platforms are considered and discussed.

Sharon Hixon-Mosley is a contract training specialist for the Centers for Disease Control and Prevention in Atlanta, Georgia. She is a Microsoft Certified Product Specialist and has been using the SAS System for around 1 year and is currently on the development team to create an application that will disseminate data regarding national surveillance of sexually transmitted diseases.

Ray L. Ransom is a systems analyst with the Centers for Disease Control and Prevention in Atlanta, Georgia. He has been using the SAS System for 11 years and is currently leading a development team charged with the development of a GUI application to analyze and disseminate data regarding national surveillance of sexually transmitted diseases. Current challenges include Web publishing and programming using the SAS System.

SAS Macros in the Land of "X" (The Operating System)

Harmon Jolley, Healthsource Inc., Chattanooga, TN

The SAS System provides many capabilities to exchange data with the operating system and database management systems. This paper reviews some examples of SASmacros which can bring data from the outside world into the SAS System. The macros provide utility functions such as managing file space, obtaining database information, system commands, and monitoring system performance under the AIX operating system.

Harmon Jolley is a Project Manager in the Health Information Systems Division of Healthsource, Inc., responsible for deployment and support of the SAS System and data warehousing. Harmon's areas of expertise with the SAS System include PROC SQL, SAS/CONNECT, and SAS/ACCESS. He has four years of experience with the SAS System.

The Simplicity of the Import/Export Wizard - SAS for Windows 6.12

George Matthews, University of Georgia, Athens, GA

Prior to SAS 6.12, the techniques for accessing external pc files like spreadsheets and databases have been somewhat less than user-friendly. This paper will examine the simplicity of using the import/export wizard in the 6.12 release of the SAS System. The import/export wizard guides you through the process of importing data from external sources to SAS, and exporting SAS data to external sources. The external data source might include files from a standard file format, like spreadsheets, database files, and delimited files, or user defined files. This paper will present an overview of using the import/export wizard for reading and writing excel spreadsheet files.

George Matthews is a statistical software consultant for the University of Georgia. He has been programming in SAS for over 10 years. He specializes in BASE SAS, SAS/ASSIST, and SAS/ACCESS.

The Zen of Client/ Server Solutions: Being one with your environment

Gregory Barnes Nelson, Senior Consultant, ASG, Inc., Cary, NC

Being responsible for establishing and maintaining your computing environment for a team of SAS programmers and developers can be almost overwhelming. Deciding on the most appropriate platform and wondering if the solution you come up with today will withstand the Web-infested future of tomorrow is a daunting task. Should you really exploit the client/ server model? Is NT here to stay and what about UNIX? What about developing in SAS and deployment via the Web?

Among others, these questions raise real issues about how best to deploy SAS in your organizations. Although there is no "right" solution set for everyone, this paper helps you walk through the right questions to determine the best mix of software and hardware solutions that help you grow and at the same time, watch your software and hardware costs.

Mr. Gregory Barnes Nelson, Senior Consultant, Business Solutions, works with clients and a selected project team to implement customized business solutions in multi-platform, multi-protocol environments with emphasis on SASÒ applications development, data analysis, research design, program evaluation, needs assessment, project management, database management and scientific visualization and graphics. Greg as significant experience with The SAS System including AF (extensive Frame and SCL), FSP, EIS, GRAPH, the Access family of products, Connect, Share, and various SAS vertical market products including CFO/Vision and IT Service Vision. A psychologist by training, Greg is a technologist at heart. His current area of expertise include designing complex data management systems, user interface modules, and data warehousing design (both business process and data modeling) and implementation (e.g., distributed architecture and front-end development).

Developing A Host Specific Web Page

Dave Scocca

When I began using SAS on the Macintosh, I noticed that there were a lot of platform-specific issues which required a lot of time to find answers to among the normal SAS resources. As a result, I decided to compile the answers I found into the SAS for the Macintosh Resource page (http://sunsite.unc.edu/sasmac/). Here, I explain how I decided what to include on my page, and lay out a strategy by which other host-specific pages could be developed.

Dave Scocca, while working on a graduate degree in Political Science, works for the Research Support Group at the University of North Carolina at Chapel Hill. Dave manages the SAS for the Macintosh Resource Web Page, and have been using the SAS System for five years.

Section Chair:		George Matthews University of Georgia Athens, GA

	Installation Issues with the SAS System and Netware 4
	Gerri Furlow, North Carolina State University, Raleigh, NC
	Integrating the SAS System efficiently and effectively in a networked environment is a task that the SAS Software consultant is faced with for each new release of the SAS System. There are configuration issues that must be addressed for the fileserver and the client stations for the integration to work smoothly. This paper will focus on the network installation of the SAS System for Microsoft Windows Release 6.12 . Particular emphasis will be placed on the integration of the SAS System within a Novell Netware Version 4 environment.
	Gerri Furlow is a Computing Consultant for the Computing Services Division of the Office of Information Technology at North Carolina State University. Her primary duties center around the technical support of SAS, SPSS, and the Microsoft and WordPerfect applications for faculty, staff, and students at NCSU. She has been using SAS for about 10 years.
	Storage Strategies for Data, Formats, Catalogs and Other Information in Application Development Using The SAS System
	Sharon Hixon-Mosley and Ray L Ransom, Centers for Disease Control and Prevention (CDC), Atlanta, GA
	When doing cross-platform development using the SAS System, developers have many options for the storage and access of information needed by their applications. Using SAS/SHARE and SAS/ACCESS one can use alternative means of storage to the SCL lists commonly used by SAS/SCL developers. These alternative means of storage can provide power and flexibility through maintenance improvements, increased query speeds for large tables, central storage of data, efficient use of RAM and the power of the SQL language. Developers of a sexually transmitted disease (STD) information system at the Centers for Disease Control and Prevention(CDC) tried storing information in several standard and alternative structures recognizing benefits and short-comings of each approach. This paper will provide a brief description of storage options and compare performance with various SAS/AF FRAME classes and specific objects. An overview of storage solutions selected for CDC’s STDINFO application will be demonstrated. This information will assist other developers working in the UNIX, Windows 3.1, Windows NT, Window NT SQL Server and Windows 95 environments as all of these platforms are considered and discussed.
	Sharon Hixon-Mosley is a contract training specialist for the Centers for Disease Control and Prevention in Atlanta, Georgia. She is a Microsoft Certified Product Specialist and has been using the SAS System for around 1 year and is currently on the development team to create an application that will disseminate data regarding national surveillance of sexually transmitted diseases. Ray L. Ransom is a systems analyst with the Centers for Disease Control and Prevention in Atlanta, Georgia. He has been using the SAS System for 11 years and is currently leading a development team charged with the development of a GUI application to analyze and disseminate data regarding national surveillance of sexually transmitted diseases. Current challenges include Web publishing and programming using the SAS System.
	SAS Macros in the Land of "X" (The Operating System)
	Harmon Jolley, Healthsource Inc., Chattanooga, TN
	The SAS System provides many capabilities to exchange data with the operating system and database management systems. This paper reviews some examples of SASmacros which can bring data from the outside world into the SAS System. The macros provide utility functions such as managing file space, obtaining database information, system commands, and monitoring system performance under the AIX operating system.
	Harmon Jolley is a Project Manager in the Health Information Systems Division of Healthsource, Inc., responsible for deployment and support of the SAS System and data warehousing. Harmon's areas of expertise with the SAS System include PROC SQL, SAS/CONNECT, and SAS/ACCESS. He has four years of experience with the SAS System.
	The Simplicity of the Import/Export Wizard - SAS for Windows 6.12
	George Matthews, University of Georgia, Athens, GA
	Prior to SAS 6.12, the techniques for accessing external pc files like spreadsheets and databases have been somewhat less than user-friendly. This paper will examine the simplicity of using the import/export wizard in the 6.12 release of the SAS System. The import/export wizard guides you through the process of importing data from external sources to SAS, and exporting SAS data to external sources. The external data source might include files from a standard file format, like spreadsheets, database files, and delimited files, or user defined files. This paper will present an overview of using the import/export wizard for reading and writing excel spreadsheet files.
	George Matthews is a statistical software consultant for the University of Georgia. He has been programming in SAS for over 10 years. He specializes in BASE SAS, SAS/ASSIST, and SAS/ACCESS.
	The Zen of Client/ Server Solutions: Being one with your environment
	Gregory Barnes Nelson, Senior Consultant, ASG, Inc., Cary, NC
	Being responsible for establishing and maintaining your computing environment for a team of SAS programmers and developers can be almost overwhelming. Deciding on the most appropriate platform and wondering if the solution you come up with today will withstand the Web-infested future of tomorrow is a daunting task. Should you really exploit the client/ server model? Is NT here to stay and what about UNIX? What about developing in SAS and deployment via the Web? Among others, these questions raise real issues about how best to deploy SAS in your organizations. Although there is no "right" solution set for everyone, this paper helps you walk through the right questions to determine the best mix of software and hardware solutions that help you grow and at the same time, watch your software and hardware costs.
	Mr. Gregory Barnes Nelson, Senior Consultant, Business Solutions, works with clients and a selected project team to implement customized business solutions in multi-platform, multi-protocol environments with emphasis on SASÒ applications development, data analysis, research design, program evaluation, needs assessment, project management, database management and scientific visualization and graphics. Greg as significant experience with The SAS System including AF (extensive Frame and SCL), FSP, EIS, GRAPH, the Access family of products, Connect, Share, and various SAS vertical market products including CFO/Vision and IT Service Vision. A psychologist by training, Greg is a technologist at heart. His current area of expertise include designing complex data management systems, user interface modules, and data warehousing design (both business process and data modeling) and implementation (e.g., distributed architecture and front-end development).
	Developing A Host Specific Web Page
	Dave Scocca
	When I began using SAS on the Macintosh, I noticed that there were a lot of platform-specific issues which required a lot of time to find answers to among the normal SAS resources. As a result, I decided to compile the answers I found into the SAS for the Macintosh Resource page (http://sunsite.unc.edu/sasmac/). Here, I explain how I decided what to include on my page, and lay out a strategy by which other host-specific pages could be developed.
	Dave Scocca, while working on a graduate degree in Political Science, works for the Research Support Group at the University of North Carolina at Chapel Hill. Dave manages the SAS for the Macintosh Resource Web Page, and have been using the SAS System for five years.