Instructions for SAS users

How SAS users may access datasets placed on Bengal

  • You will need to use the secure version of telnet, which is SecureCRT. If you do not have this software on your computer, you may download it free from DoIT.
  • Once you have the SecureCRT software on your machine, open it and follow these instructions:
    • Close the “Connect” pop-up box that automatically opens upon startup.
    • Choose “File,” then “Quick Connect.”
  • Fill out the pop-up box as follows. Refer to the image below if it helps.
    • Set the protocol to ssh1
    • In the “Host Name” box, type “bengal.missouri.edu”
    • Keep the port at 22
    • Enter your pawprint.
    • The box should look something like this:
    • crt-sas-box
    • Click on the “Connect” button.
    • You will be prompted for your password. Go ahead and enter it.
  • Change the directory to the ellsdata folder on the Hierarchical Storage Manager One by typing: cd /hsm1/ellsdata
  • Next, get to the folder containing the dataset of your choice by typing “cd” for “change directory,” and then the folder name given to you by the librarian. For example, cd icpsr#### (Example: cd icpsr9984).
  • View the list of files in the folder by using the list (ls) command. Make note of the name of the dataset file you wish to use.
  • Use SAS to open the file of your choice.The FILENAME statement will look like: filename house ‘/hsm1/ellsdata/icpsr9839/da9839.household’; You can also write the statement to look like: filename in ‘/hsm1/ellsdata/icpsr9984/da9984.demog1’; For permanent SAS datasets, you will need to use a statement that looks like: libname in ‘/hsm1/ellsdata/icpsr9934’;

Sample commands for special file types

1. How to use an OSIRIS dataset and Data Dictionary with SAS A complete discussion of using OSIRIS data sets with SAS can be found in the SAS Companion for the Unix Environment and Derivatives, Version 6, First Edition. Pages: 85-86 and 102-103.
filename odata ‘/hsm1/ellsdata/icpsr9999/odata.s9999’; filename odict ‘/hsm1/ellsdata/icpsr9999/odict.s9999’; proc convert osiris=odata dict=odict out=s9999;

The rest of your SAS program would go here.
2. How to use an ICPSR SAS Transport Data File
libname in xport ‘/hsm1/ellsdata/icpsr9999/sa9999.export’; proc copy in=in out=sa9999; The rest of your SAS program would go here.