uploading a sas dataset to sas university edition

Finally, a few practical examples are given of using SAS/Connect commands.įor complete information, please see the SAS/Connect documentation. The instructions below describe a one-time preliminary step that must be performed (editing the 'tcuunix.scr' SAS file), followed by instructions for setting up an SSH tunnel and then establishing a SAS/Connect session between your PC and Koti. The information that is passed through the tunnel (in both directions) is encrypted before transmission and then unencrypted upon receipt. Then you establish a SAS/Connect 'session' between SAS on your PC and SAS on Koti so that all information that is exchanged between them will be sent through that tunnel. With SSH tunneling, first you create a secure 'SSH tunnel' (connection) between your PC to Koti. To obtain a secure connection, you must use a method known as SSH tunneling, as will be explained below. You will be connecting to SAS 9.4 (TS1M7) on Koti.īecause Koti is approved for and may house sensitive data, you are required to use a secure connection between your PC and Koti. You must use the 'traditional' SAS programming environment - not SAS Studio, SAS OnDemand, SAS University Edition, or SAS Enterprise Guide. To establish such a connection, you can use SAS 9.3 or 9.4 on your PC. This web page describes how to set up such a connection between SAS on your PC and Koti, and it provides a few examples of actual SAS/Connect commands you can use. For example, from SAS on your PC you can issue commands to SAS on Koti to process a data file stored on Koti and then send the results back to SAS on your PC for you to display locally. These commands provide you the ability to manage, access, and process data in a distributed and parallel environment. Once connected, you can issue commands to SAS on your PC to interact with SAS on Koti. SAS/Connect allows you to establish a 'connection' between SAS running on your PC and SAS running on Koti.

Example 1 - PROC FREQ of a Koti file (executed remotely)Įxample 2 - PROC FREQ of a Koti file (executed locally)Įxample 5 - Locally view and edit SAS files stored on Koti OVERVIEW

Uploading a sas dataset to sas university edition