BookmarkSubscribeRSS Feed
woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

Hello, i like to move sas datasets from windows to linux in bulk (*). I am not quite sure if proc cport/cimport can be used to move sas datasets in bulk. Please advise. Thanks!

6 REPLIES 6
SASKiwi
Opal | Level 21

The simple answer is yes.

 

An alternative method, if you have SAS/CONNECT installed on both servers is to use PROC UPLOAD which can move entire SAS libraries with one statement. UPLOAD handles the data conversion on-the-fly so you don't need CPORT / CIMPORT.

woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

Thank you @ SASKiwi. Unfortunately, we don't have sas/connect. 

Kurt_Bremser
Super User

Since both Windows and Linux use the same processor architecture, I would simply copy the files first and test them on Linux.

PROC CPORT/CIMPORT can transport whole libraries in a single file.

woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

Thank you KurtBremser. would you please provide any doc/link to refer to transfer complete library? I see document with exporting single sas dataset. 

Quentin
PROC Star

I think Kurt is recommending you simply copy the files using non-SAS tools (e.g. sFTP, Samba, whatever) for copying files between the environments.  SAS datasets are just files.  You will pay a small performance price on the linux side when reading files that were written by Windows, but if that cost is too high, you can always translate / recreate the datasets on the linux side after you have moved the files.

Check out the Boston Area SAS Users Group (BASUG) video archives: https://www.basug.org/videos.
ballardw
Super User

@woo wrote:

Thank you KurtBremser. would you please provide any doc/link to refer to transfer complete library? I see document with exporting single sas dataset. 


https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p1h7x7gvk42uv0n16apets89tmvp.htm

 

Change the memtype to DATA from CATALOG for only the data sets. If you leave off the memtype the default will be to export the data and catalogs.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1027 views
  • 2 likes
  • 5 in conversation