Chapter Contents

Previous

Next
Getting Started with the SAS System Using SAS/ASSIST Software

Transferring Data

You can use Transfer data on the Remote Connect menu to upload (transfer from a local to a remote session) or download (transfer from a remote to a local session) SAS tables, SAS catalogs, external files, or members of a SAS data library, from one SAS session to another. Additionally, you can download graphics output from a remote session to a local session. To assist you with uploading and downloading data, you can assign librefs and filerefs in the local or remote session, view the contents of a remote table, or view a remote library listing from within the WorkPlace menu's Remote Connect item. Make sure you are connected to the remote session before you transfer the data.

In this section, you transfer the HOUSES table from the local SAS session to a remote table called HOUSES. You also view the contents of the remote HOUSES table and view the contents of the remote SASUSER library.


Instructions

  1. Follow this selection path:

    Tasks
    [arrow]
    Remote
    [arrow]
    Transfer data...
    [arrow]
    Upload
    [arrow]
    Upload a SAS Table...
    The Upload SAS Table window appears.

    Upload SAS Table Window

    [IMAGE]

  2. Select the remote session from the list shown at the bottom of the Upload SAS Table window. For this example, OS/390 Connection is selected. If you have only one remote session, you do not need to perform this step.

  3. Select Table to upload, and then select the SASUSER.HOUSES table. For information on selecting tables, see Selecting a Table.

  4. Select Remote table. The Specify Remote Table window appears.

    Specify Remote Table Window

    [IMAGE]

  5. In the Table field, type HOUSES as the name of the remote table. Select Permanent. In the field next to Permanent, type SASUSER as the permanent remote library in which you want to store the new HOUSES table. By creating a permanent table of SASUSER.HOUSES, you can remotely run the program that you create and save in the next section.

  6. Select OK to return to the Upload SAS Table window.

  7. Select Run. The HOUSES table is uploaded from the local host to the remote host into a permanent table called SASUSER.HOUSES. A window appears showing the progress of the upload. When the upload is complete, a message appears indicating that the upload completed successfully.

    Note:   If the table being uploaded is small, the window showing the progress of the upload appears only briefly on the display.  [cautionend]

  8. Select Goback to return to the WorkPlace Menu.

  9. To view the contents of the table you just uploaded on the remote system, follow this selection path:

    Tasks
    [arrow]
    Remote
    [arrow]
    Transfer data
    [arrow]
    Utilities
    [arrow]
    Remote table contents...
    The Remote Table Contents window appears.

    Remote Table Contents Window

    [IMAGE]

  10. In the Table name field, type SASUSER.HOUSES as the name of the table whose contents you want to view.

  11. Select the remote session that you want to use from the list in the window. For this example, OS/390 Connection is selected.

  12. Select OK. The contents of the SASUSER.HOUSES table that is on the remote host appear in the Output window.

    Remote Table Contents Output

    [IMAGE]

    Use the scroll bars or the UP and DOWN function keys, depending on your operating environment, to display the rest of the contents.

    Depending on your operating environment, when you are in the Output window, you may need to continue using the DOWN function key until all of the output is viewed before returning to the SAS/ASSIST window. You do this to ensure that any procedures running in the Output window are completed.

  13. To return to the WorkPlace menu, use one of the following methods, according to your operating environment:

  14. If you wish to view the contents of a SAS data library on a remote host, follow this selection path:

    Tasks
    [arrow]
    Remote
    [arrow]
    Transfer data...
    [arrow]
    Utilities
    [arrow]
    Remote library listing...
    The Remote Library Listing window appears.

    Remote Library Listing Window

    [IMAGE]

  15. In the Libref field, type SASUSER as the libref of the remote library that you want to list.

  16. Select the remote session that you want to use from the list in the window. For this example, OS/390 Connection is selected. If you have only one remote session, you do not need to perform this step.

  17. Select OK. The contents of the SASUSER library appear in the Output window.

    Remote Library Listing Output

    [IMAGE]

    Use the scroll bars or the UP and DOWN function keys, depending on your operating environment, to display the rest of the contents.

    Depending on your operating environment, when you are in the Output window, you may need to continue using the DOWN function key until all of the output is viewed before you return to the SAS/ASSIST window. You do this to ensure that any procedures running in the Output window are completed.

  18. To return to the WorkPlace menu, use one of the following methods, according to your operating environment:


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.